-
Notifications
You must be signed in to change notification settings - Fork 88
Labels
api: bigquerystorageIssues related to the googleapis/java-bigquerystorage API.Issues related to the googleapis/java-bigquerystorage API.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.‘Nice-to-have’ improvement, new feature or different behavior or design.
Description
Environment details
- BigQuery StorageWrite
- OS type and version: MacOS 11.6.3
- Java version: 11
- version(s): 2.8.4
Steps to reproduce
- Create a bigquery table with only one field of type TIMESTAMP and with name "d"
- Use JsonStreamWriter with this JSON Array
[{"d":"2022-02-06 07:24:47.84"}] - run
Stack trace
java.lang.IllegalArgumentException: JSONObject does not have a int64 field at root.d.
at com.google.cloud.bigquery.storage.v1.JsonToProtoMessage.fillField(JsonToProtoMessage.java:351)
at com.google.cloud.bigquery.storage.v1.JsonToProtoMessage.convertJsonToProtoMessageImpl(JsonToProtoMessage.java:176)
at com.google.cloud.bigquery.storage.v1.JsonToProtoMessage.convertJsonToProtoMessage(JsonToProtoMessage.java:115)
at com.google.cloud.bigquery.storage.v1.JsonStreamWriter.append(JsonStreamWriter.java:140)
at com.google.cloud.bigquery.storage.v1.JsonStreamWriter.append(JsonStreamWriter.java:99)
at persistence.BigqueryStreamingClient.streamJsonArray(BigqueryStreamingClient.java:72)
External references such as API reference guides
- ?
Any additional information below
This is pretty similar to #1330 / #1345, but happens with TIMESTAMP columns. I was wondering if the same fix could be applied? If a string is provided for a TIMESTAMP column, can you convert it? The legacy BQ insert api did and would just make it easer to migrate. Thanks!
michaelbannister and juancalvof
Metadata
Metadata
Assignees
Labels
api: bigquerystorageIssues related to the googleapis/java-bigquerystorage API.Issues related to the googleapis/java-bigquerystorage API.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.‘Nice-to-have’ improvement, new feature or different behavior or design.