[
https://issues.apache.org/jira/browse/BEAM-7999?focusedWorklogId=296782&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-296782
]
ASF GitHub Bot logged work on BEAM-7999:
----------------------------------------
Author: ASF GitHub Bot
Created on: 17/Aug/19 14:00
Start Date: 17/Aug/19 14:00
Worklog Time Spent: 10m
Work Description: alexvanboxel commented on issue #9368: [BEAM-7999] Fix
BigQuery timestamp handling for Schema Aware PCollection
URL: https://github.com/apache/beam/pull/9368#issuecomment-522239762
Abandoning... as rebase seems to be incorrect
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 296782)
Time Spent: 10m
Remaining Estimate: 0h
> BigQueryIO.readTableRowsWithSchema() doesn't handle timestamp correctly
> -----------------------------------------------------------------------
>
> Key: BEAM-7999
> URL: https://issues.apache.org/jira/browse/BEAM-7999
> Project: Beam
> Issue Type: Bug
> Components: io-java-gcp
> Affects Versions: 2.14.0, 2.15.0
> Reporter: Alex Van Boxel
> Assignee: Alex Van Boxel
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Using the new readTableRowsWithSchema to make a copy of a table (simple
> operation), parsing the timestamp in the table doesn't work as it assumes a
> Double value. BigQuery outputs a string like "2019-08-16 00:12:00.123456
> UTC". This isn't handled.
> *Reproducable:*
> with this table
> {code:java}
> INSERT `research.alex.in1` (row_id, f_int64, f_timestamp)
> VALUES
> (1, 1, '2019-08-16 00:12:00 UTC'),
> (2, 2, '2019-08-16 00:12:00.123 UTC'),
> (3, 3, '2019-08-16 00:12:00.123456 UTC')
> {code}
> do a copy operation:
> {code:java}
> pipeline
> .apply(
> BigQueryIO.readTableRowsWithSchema()
> .from("research:alex.in1")
> //.withMethod(BigQueryIO.TypedRead.Method.DIRECT_READ)
> )
> .apply(ParDo.of(new Inspect()))
> .apply(
> BigQueryIO.writeTableRows()
>
> .withCreateDisposition(BigQueryIO.Write.CreateDisposition.CREATE_IF_NEEDED)
> .withMethod(BigQueryIO.Write.Method.FILE_LOADS)
> .useBeamSchema()
> .to("research:alex.out4"));
> {code}
>
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
