How to create table from executeQuery in NiFi

[#1]

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 {...}`

[#2]

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.