Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

run multiple queries in NiFi

run multiple queries in NiFi

New Contributor

Using Apache NiFi 1.3, running a ReplaceText-->spliteText--> PutHiveQL. I have a ReplaceText with Replacement Value running multiple querieswith semicolon at the end. Example:

LOAD DATA INPATH '/dataload/Depts/ISD/ProjectNova/CSVConvert_Success/SH_Plants.csv' OVERWRITE INTO TABLE projectnova.sh_plants_base;
LOAD DATA INPATH '/dataload/Depts/ISD/ProjectNova/CSVConvert_Success/SH_Weights.csv' OVERWRITE INTO TABLE projectnova.SH_Weights_base;

When it get to PutHiveQL process, it returns an error, "No Files Matching Path". It seems only pick up the one statement and then delete both files from HDFS. Therefore, cannot file the first file (sh_plants). See attached images of flow and error message. Please advise!

Don't have an account?
Coming from Hortonworks? Activate your account here