Skip to main content
BillyG
Bronze III
September 8, 2023
Solved

ExecuteSQL Processor with Parquet record writer

I am working in NiFi 1.16 and trying to use ExecuteSQL processor to write out a Parquet file.  My challenge is the decimal format is being changed to "LogicalType(STRING: StringType())".

The data is coming from an MS SQL server.  We have tried to set the precision and scale, but still continues to come out in a string instead of a decimal.

 

 


Annotation 2023-09-08 131126.png
cotopaul
cotopaulAnswer
Platinum ⭐️
September 11, 2023

@BillyG, set the property "Use Avro Logical Types" to true if you would like to use anything else besides STRINGS :).

1 reply

cotopaul
cotopaulAnswer
Platinum ⭐️
September 11, 2023

@BillyG, set the property "Use Avro Logical Types" to true if you would like to use anything else besides STRINGS :).

Translate