[
https://issues.apache.org/jira/browse/NIFI-14495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18017527#comment-18017527
]
Pierre Villard edited comment on NIFI-14495 at 9/1/25 8:11 PM:
---------------------------------------------------------------
You have trailing whitespace in what you copy/pasted in that property.
In any case, I made some tests on my side and we don't properly handle the case
where DATETIME is used for the destination column. I'll try to find time to add
support for it. The easiest way right now would be to use TIMESTAMP for the
column type instead.
Please see NIFI-14928 for further discussions on this specific problem.
was (Author: pvillard):
You have trailing whitespace in what you copy/pasted in that property.
In any case, I made some tests on my side and we don't properly handle the case
where DATETIME is used for the destination column. I'll try to find time to add
support for it. The easiest way right now would be to use TIMESTAMP for the
column type instead.
> 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: Screenshot at 17-15-21.png,
> 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,
> image-2025-09-01-18-06-21-028.png, screenshot-1.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)
