Support Questions

Find answers, ask questions, and share your expertise

Error when running NiFi ExecuteSQL processor

avatar
Explorer

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.

0 REPLIES 0