CODEWITHSUNDEEP
google-bigquerygoogle-cloud-dataflowapache-beam
BackBenChers
BackBenChers

Reputation: 304

Reading BigQuery Numeric Data Type From Table

While reading data from BQ table NUMERIC data type is Still not supported in Apache Beam but using API I can use NUMERIC data type in BQ.

So while reading data from BQ with below Snippet:

BigQueryIO.readTablerow().from(options.valueprovider);

I got an Exception Numeric is Not supported yet.

Is there any other way I can read data from BQ if NUMERIC field is Present Except RestAPI Call.

Upvotes: 0

Views: 924

Answers (1)

Elliott Brossard
Elliott Brossard

Reputation: 33745

Dataflow now supports reading NUMERIC from BigQuery using the Java library. At the time of this writing, you will either need to download a snapshot release or wait until the next official Beam release in order to make use of this feature.

Edit: if you want to download the current version of Beam, you can do so like this:

~$ git clone https://github.com/apache/beam.git

Then you can use the Gradle build task, for example:

~$ cd beam
~/beam$ ./gradlew build

Or generate files for Eclipse, if you're using it as your development environment:

~/beam$ ./gradlew -p sdks/java/build-tools/ eclipse

You can find more information about using Gradle in the Gradle user documentation.

Upvotes: 2

Related Questions