You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Pierre Villard (Jira)" <ji...@apache.org> on 2025/09/01 20:12:00 UTC
[jira] [Comment Edited] (NIFI-14495) The PutBigQuery processor fails to handle timestamp fields provided in string format
[ 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)