DataType is changing in Avro file with ExecuteSQL processor in NiFi

[#1]

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:

[#2]

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.

[#3]

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