Support Questions
Find answers, ask questions, and share your expertise

DataType is changing in Avro file with ExecuteSQL processor in NiFi

Highlighted

DataType is changing in Avro file with ExecuteSQL processor in NiFi

New Contributor

Hi All,

I am trying to generate Avro file from SQL Server using ExecuteSQL processor. Generated Avro file is converting date, datetime, varchar datatypes to string datatype.Sample : {"name":"Date","type":["null","string"]},{"name":"WeekBegin","type":["null","string"]}. Could anyone please suggest  some solution to this.

The executeSQL processor configuration is as follow:

ExecuteSQL.PNG

 

2 REPLIES 2
Highlighted

Re: DataType is changing in Avro file with ExecuteSQL processor in NiFi

Explorer

In my case it is working, maybe in your database, those date type columns are not exactly date type, maybe it is nvarchar. Please check once your columns datatype.

Highlighted

Re: DataType is changing in Avro file with ExecuteSQL processor in NiFi

New Contributor

This is my DDL :  CREATE TABLE dev.test_table ( date DATE, weekbegin DATETIME );