How can we handle null values for Data type INTEGER while using Federated/External tables for Google Bigquery?

Asked Feb 01 '19 at 11:29

Active Feb 01 '19 at 14:35

Viewed 241 times

While Using below query ,i am getting the error .

bq mk --use_legacy_sql=false --nullmarker="\N" --external_table_definition=/tmp/bqschema dataflowjson.TEST1 FATAL Flags parsing error: Unknown command line flag 'nullmarker' Run 'bq help' to get help

My Date is like :

Datatype that i am giving as : NAME:STRING,AGE:INTEGER,CITY:INTEGER

edited Feb 01 '19 at 14:35

asked Feb 01 '19 at 11:29

DataVishesh

What do you mean by "handle NULL"? – Elliott Brossard Feb 01 '19 at 13:55
I have explained the entire issue in this thread .Can you suggest.I am getting error while querying external table. – DataVishesh Feb 01 '19 at 14:36
As you'd have guessed, --nullmarker is not a valid option for bq mk. Have you tried removing it? What's the result? – totooooo Feb 02 '19 at 14:04

How can we handle null values for Data type INTEGER while using Federated/External tables for Google Bigquery?

0 Answers0