Support Questions

Find answers, ask questions, and share your expertise
Celebrating as our community reaches 100,000 members! Thank you!

Error when running NiFi ExecuteSQL processor


Hi, everyone. I'm learning about some NiFi processors.


I want to obtain all the data of several tables automatically.


So I used a ListDatabaseTable processor with the aim of getting the tables names that are in a specific catalog. 


After that, I used other processors to generate the queries like GenerateTableFetch and

 RemplaceText. Everything works perfectly since here.


Finally, ExecuteSQL processor plays a role, and here and error is displayed. It says that a datetime column can not be converted to Avro format.


The problem is that there are several tables so specify those columns would be complicated to cast them.


Is a possible solution to fix the error?


The connection is with Microsoft SQL Server.