[
https://issues.apache.org/jira/browse/NIFI-14495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18017497#comment-18017497
]
vmangiacapra commented on NIFI-14495:
-------------------------------------
[~pvillard] thank you for your answer.
Here the details:
-{*}configuration of the processor{*}
!Screenshot at 17-15-21.png!
-{*}configuration of the record reader{*}
!screenshot-1.png!
-{*}scheme of the destination table{*}
{code:java}
[{
"column_name": "id_subscription",
"data_type": "INT64"
}, {
"column_name": "id_ordine",
"data_type": "INT64"
}, {
"column_name": "data",
"data_type": "DATETIME"
}, {
"column_name": "importo",
"data_type": "FLOAT64"
}, {
"column_name": "recurring_type",
"data_type": "STRING(1)"
}, {
"column_name": "is_gift",
"data_type": "BOOL"
}, {
"column_name": "is_renewal",
"data_type": "BOOL"
}, {
"column_name": "anon_transaction",
"data_type": "BOOL"
}, {
"column_name": "paymode",
"data_type": "STRING"
}, {
"column_name": "user_agent",
"data_type": "STRING"
}]
{code}
-*json example in input to PutBigQuery processor:
{code:java}
{
"id_ordine" : 11,
"data" : "2025-08-31 04:09:31",
"importo" : 60.0,
"recurring_type" : "y",
"is_gift" : false,
"paymode" : "test",
"user_agent" : "test",
"anon_transaction" : true,
"id_subscription" : 1111,
"is_renewal" : false
}
{code}
As you can see, I have not configured in the JSON reader date format, time
format and timestamp format. In what way can I solve this?
Thank you so much!
> 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,
> 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)
