Support Questions

Find answers, ask questions, and share your expertise

ExecuteSQL Processor with Parquet record writer

avatar
Explorer

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
1 ACCEPTED SOLUTION

avatar

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

View solution in original post

1 REPLY 1

avatar

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