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

Inserting data into exiting partitioned Hive table using Pig Scripts

Highlighted

Inserting data into exiting partitioned Hive table using Pig Scripts

Contributor

Hi all,

I am trying to insert data in the Partitioned hive table. As I have already load data in Hive table using Pig script once and Hive created dynamic partitioned under HDFS Directory. I have another file that has different data (but there is data on which I want to partition and that partition already exists) but I want to save those data into the same partitioned table. But Pig is giving me an error that says

 

Partition already present with given partition key values : Data already exists in hdfs://sandbox-hdp.hortonworks.com:8020/<hive-table-location>/<hive-partition>, duplicate publish not possible.

 

How could I Insert into the existing partitioned table? Is it possible to insert it? Please kindly help me for the same.

 

Regards,

Jay.

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