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

How to create table from executeQuery in NiFi

How to create table from executeQuery in NiFi

Explorer

Am trying to run a `select` query using `ExecuteSQL` processor and am trying to create a new table from the selected data after that using the resulted data. would this be the best approach ? also am stuck in writing the `creation` statement `create table mytable as select * from {...}`

 

Exor_0-1597240329797.png

 

1 REPLY 1

Re: How to create table from executeQuery in NiFi

Contributor

Assuming that you will create table only once, it is very difficult since you need to parse the columns and data types. The amount of effort is not worth for a one time thing. So, i would suggest you to create the table manually. If you are going to create a table dynamically everytime, i would be interested in how you did this or if you have made some progress i would be happy to help.

 

Hope this helps. If the comment helps you to find a solution or move forward, please accept it as a solution for other community members.