googleapis / googleapis/google-cloud-java

[java-bigquerystorage] JsonStreamWriter Support ISO TIMESTAMP String

Open
#11,976 8 comments 0 reactions 0 assignees View on GitHub
api: bigquerystorage priority: p2 type: feature request
Dominant language
Java
Stars
2.1k
Forks
1.2k
Avg merge
1d 23h
Merged PRs (30d)
154

Description

What the problem is:

currently uploading ISO formatted Timestamp values fails with `JSONObject does not have a int64 field at root.c_timestamptz.'.`

currently its only accepting [int values](https://cloud.google.com/bigquery/docs/write-api#data_type_conversions)

is it possible to add support?

What you want to happen.
able to upload ISO formatted Timestamp values to TIMESTAMP field.

```
2022-08-28 12:56:50,656 INFO [io.deb.ser.ConnectorLifecycle] (pool-11-thread-1) Connector completed: success = 'false', message = 'Stopping connector after error in the application's handler method: JSONObject does not have a int64 field at root.c_timestamptz.', error = '{}': java.lang.IllegalArgumentException: JSONObject does not have a int64 field at root.c_timestamptz.
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:147)
at com.google.cloud.bigquery.storage.v1.JsonStreamWriter.append(JsonStreamWriter.java:106)
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.