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.