Geek Answers Handbook

Google BigQuery does not parse a “2nd timestamp” field

I am trying to import a large amount of data into a flat table using CSV. When importing BigQuery reports:

- File: 0 / Line:6659 / Field:11: Could not parse '' as a timestamp

In the diagram, I have 2 timestamps: fields 4 and 11. Both values ​​are zero. For the second timestamp, the row entry in field 11 is indeed zero.

Is this supposed to work like this, or do I need to send it as "0"?

+4
source share
2 answers

Note the difference between a null value and an empty string. The line above 6659 has blank lines but no zeros.

To reproduce, I created a table with this diagram:

[{"name":"a","type":"TIMESTAMP","mode":"NULLABLE"},
 {"name":"b","type":"TIMESTAMP","mode":"NULLABLE"}]

Then download this file:

"",""

:

File: 0 / Line:1 / Field:1, Could not parse '' as a timestamp

:

,

, , .

, , BigQuery , ETL timestamp BigQuery.

+2

- File: 2 / Line:9940 / Field:13: Day 0-0-0 does not exist for
 timestamp: 0000-00-00 00:00:00

"9718470";"2769586jfghjkdf";"2015-08-03 15:57:28";"2015-08-03 16:10:10";"479";"128833308";"May 2015";"1461782";"ab_20150616";"1130567689";"69466";"emailid@hotmail.com";"0000-00-00 00:00:00";"2015-08-03 23:53:44"

13- TIMESTAMP BigQuery, "0000-00-00 00:00:00" . "0000-00-00 00:00:00" .

,

"9718470";"2769586jfghjkdf";"2015-08-03 15:57:28";"2015-08-03 16:10:10";"479";"128833308";"May 2015";"1461782";"ab_20150616";"1130567689";"69466";"emailid@hotmail.com";;"2015-08-03 23:53:44"

"someValue";; "someOtherValue" "someValue", "0000-00-00 00:00:00" ; "someOtherValue " someValue ";" ";" someOtherValue

, ; .

+1

More articles:


All Articles