Created on 02-09-2022 08:57 AM - edited 02-09-2022 07:52 PM
Hello Experts,
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:
ReplaceText->success->PutHiveQL
GenerateFlowFile -> success -> PutHiveQL
GenerateFlowFile Custom Text: insert overwrite Table1 select * from Table2;
Created 02-09-2022 07:49 PM
The alternative your mentioned of using GenerateFlow file is the way to go here.
Created 02-09-2022 07:49 PM
The alternative your mentioned of using GenerateFlow file is the way to go here.