I have been reading a json file and storing in HDFS in normal csv format. I have created my hive table manually from hive currently and i want to do it using nifi . I have read we can do it using Puthiveql processor but i can't find any attribute here in the processor to insert DDl like we get in selectHIVEql processor.
hive.ddl attribute will be added to the flowfile if we use ConvertAvroToORC processor, as you are using json file
1.use ConvertJsonToAvro processor then
2.ConvertAvroToORC processor after this processor you are going to have hive.ddl attribute will be added to the flowfile.
3.Use Replacetext processor to keep the hive.ddl attribute value as flowfile content
4.PutHiveQL processor to execute the hive ddl.
Reference how to use hive.ddl and puthiveql processors.
Reference how to convertJsontoAvro