I want to run a simple Hive Insert SQL statement in Nifi periodically for example:
insert overwrite Table1 select * from Table2;
All SQL values are fixed hardcoded and don't need to be changed dynamically in the flow. As a newbie I was thinking I could write the flow as:
GenerateFlowFile -> success -> PutHiveQL
GenerateFlowFile Custom Text: insert overwrite Table1 select * from Table2;
The alternative your mentioned of using GenerateFlow file is the way to go here.
View solution in original post