[ 
https://issues.apache.org/jira/browse/BEAM-12532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Kenneth Knowles updated BEAM-12532:
-----------------------------------
    Status: Open  (was: Triage Needed)

> BigQueryUtils fromBeamField omits ":00" from times with 0 seconds
> -----------------------------------------------------------------
>
>                 Key: BEAM-12532
>                 URL: https://issues.apache.org/jira/browse/BEAM-12532
>             Project: Beam
>          Issue Type: Bug
>          Components: io-java-gcp
>    Affects Versions: 2.30.0
>            Reporter: Matthew Ouyang
>            Assignee: Matthew Ouyang
>            Priority: P2
>
> If a value in a Beam Row is of the SqlTypes.TIME data type, BigQueryUtils 
> uses `toString()` to print out the time value [1].  `toString()` tries to 
> optimize the string length by omitting nanoseconds if it is zero, and seconds 
> if it is also zero [2].  However the BigQuery time type requires seconds to 
> always be there even if it's zero [3].
> [1] 
> https://github.com/apache/beam/blob/58e2ea9c40fd08e24f23183852970f566b17d6cd/sdks/java/io/google-cloud-platform/src/main/java/org/apache/beam/sdk/io/gcp/bigquery/BigQueryUtils.java#L551
> [2] 
> https://docs.oracle.com/javase/8/docs/api/java/time/LocalTime.html#toString--
> [3] 
> https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#time_type



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to