[
https://issues.apache.org/jira/browse/NIFI-14495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17947068#comment-17947068
]
Andriy edited comment on NIFI-14495 at 4/24/25 3:05 PM:
--------------------------------------------------------
What is the type of the column you're sending data to?
TIMESTAMP -
[https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#timestamp_type*]
Is your data without timezone, or with timezone, or both?
*both*
was (Author: JIRAUSER309496):
What is the type of the column you're sending data to?
*TIMESTAMP -
https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#timestamp_type*
Is your data without timezone, or with timezone, or both?
*both*
> The PutBigQuery processor fails to handle timestamp fields provided in string
> format
> ------------------------------------------------------------------------------------
>
> Key: NIFI-14495
> URL: https://issues.apache.org/jira/browse/NIFI-14495
> Project: Apache NiFi
> Issue Type: Bug
> Affects Versions: 2.3.0
> Reporter: Andriy
> Priority: Major
> Attachments: image-2025-04-24-13-42-00-184.png,
> image-2025-04-24-13-43-14-598.png, image-2025-04-24-13-48-09-144.png,
> image-2025-04-24-14-11-06-239.png
>
>
> The PutBigQuery processor fails to handle timestamp fields provided in string
> format. This functionality worked correctly in the processors
> PutBigQueryBatch and PutBigQueryStream.
> *Error Message:*
> {{Wrong object type used with protocol message reflection. Field number: 11,
> field java type: LONG, value type: java.lang.String}}
> *Example of Input:*
> {
> "timestamp": "2025-04-03T03:44:01.234Z"
> },
> {
> "timestamp": "2025-04-11 10:07:31.072000"
> }
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
