Support Questions

Find answers, ask questions, and share your expertise

Error when running NiFi ExecuteSQL processor

New Contributor

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.