[jira] [Created] (BEAM-2969) BigQueryIO fails when reading then writing timestamps before 1970

["Kevin Peterson (JIRA)" <ji...@apache.org>]

Kevin Peterson created BEAM-2969:
------------------------------------

             Summary: BigQueryIO fails when reading then writing timestamps before 1970
                 Key: BEAM-2969
                 URL: https://issues.apache.org/jira/browse/BEAM-2969
             Project: Beam
          Issue Type: Bug
          Components: sdk-java-gcp
            Reporter: Kevin Peterson
            Assignee: Chamikara Jayalath


I have a batch pipeline which reads from BigQuery (via standard sql query), does a small transform, and writes the data back to BigQuery.

This fails if any timestamps are present in the BQ data from before 1970:
{{"message" : "JSON parsing error in row starting at position 0: Couldn't convert value to timestamp: Could not parse '1969-12-28 02:52:54.-484 UTC' as a timestamp. Required format is YYYY-MM-DD HH:MM[:SS[.SSSSSS]] Field: observed_timestamp; Value: 1969-12-28 02:52:54.-484 UTC",}}

It appears the TableRow coder doesn't handle negative timestamps properly, using a negative number for the fractions of a second, which BQ considers invalid.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)