I am able to bring CSV files from local to hdfs and then created Hive External Table on top of the files/ folder.
Now want to load data in Hive Partitioned tables.
Processor: PutHiveStreaming is giving error show in the attached snapshot.
Looking forwards for a quick help.
To what output format have you set the 'SelectHiveQL' processor? It supportst csv and Avro, and you must set it to Avro, as the 'PutHiveStreaming' processor expects the input to be in Avro format.
Thanks for participating.
Let me share the screen shot of both processors as well.
Also changed Auto-Create Partitions to true as well for testing but still the same error.
1) One VM for HDP as single node cluster
2) One VM for Separate instance for NiFi
Everything is working fine, just not the thrift, unable to write in Hive partition table. I read somewhere that Hive jar files from HDP need to be copied into NiFi instance. Can anyone guide in this direction as well?