[jira] [Created] (NIFI-12399) how to add parameter decimal_target_types on process PutBigQueryBatch

["SYAZ (Jira)" <ji...@apache.org>]

SYAZ created NIFI-12399:
---------------------------

             Summary: how to add parameter decimal_target_types on process PutBigQueryBatch
                 Key: NIFI-12399
                 URL: https://issues.apache.org/jira/browse/NIFI-12399
             Project: Apache NiFi
          Issue Type: Bug
          Components: Configuration
            Reporter: SYAZ


Hi,

i do an extract from hive with select3Hive3Ql in avro mode and then i use PutBigQueryBatch with the file generated par Hive3QL. 

for my hive table a type decimal become string in bigquery

i want to change this. it's possible to user the option decimal_target_types to change decimal to NUMERIC or BIGNUMERIC

how to add this parameter to PutBigQueryBatch on nifi processor ? 

https://cloud.google.com/bigquery/docs/reference/bq-cli-reference?hl=en#--decimal_target_types

*{{--decimal_target_types=DECIMAL_TYPE}}*

Determines how to convert a {{Decimal}} logical type. Equivalent to [{{JobConfigurationLoad.decimalTargetTypes}}|https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationLoad.FIELDS.decimal_target_types]. Repeat this flag to specify multiple target types.

thanks 

Best regards

Sylvain AZNAR



--
This message was sent by Atlassian Jira
(v8.20.10#820010)