[ 
https://issues.apache.org/jira/browse/NIFI-14495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17947335#comment-17947335
 ] 

Andriy commented on NIFI-14495:
-------------------------------

Thank you for looking into this further.

As we have different JSON structures with different timestamp formats, and we 
don't know where and when each will appear, it will be very difficult to fix 
the data and have a single pattern

Additionally, I reviewed the ConvertRecord processor, and it appears there is 
no option similar to the Proto Writer.

> 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)

Reply via email to