question Failed with exception MetaException(message:Invalid partition key & values; keys [feed_date, ], values []) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask in Support Questions

question Failed with exception MetaException(message:Invalid partition key & values; keys [feed_date, ], values []) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask in Support Questions https://community.cloudera.com/t5/Support-Questions/Failed-with-exception-MetaException-message-Invalid/m-p/114129#M76927 Hello frndz,Can you please help me to understand below error.Actually when I am doing union all join with two tables and creating one table with the help of this join then I am getting below error on tez execution engine. Failed with exception MetaException(message:Invalid partition key & values; keys [feed_date, ], values []) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTaskBut when I am running it on mr then it is running fine. I am using hdp2.3. SQL:hive> INSERT OVERWRITE TABLE clickstream_kpis.cs_android_event_lookup_tbl PARTITION (feed_date) > SELECT a.* > FROM > (SELECT hitid_high, > hitid_low, > event_number, > feed_date > FROM clickstream_db.clickstream_android LATERAL VIEW explode(SPLIT (post_event_list,','))expld AS event_number > WHERE feed_date BETWEEN '2016-01-01' AND '2016-01-31' > AND post_event_list IS NOT NULL > UNION ALL SELECT hitid_high, > hitid_low, > post_event_list AS event_number, > feed_date > FROM clickstream_db.clickstream_android > WHERE feed_date BETWEEN '2016-01-01' AND '2016-01-31' > AND post_event_list IS NULL)a;Query ID = hdpbatch_20160304145048_5262fb30-6ed6-4a7c-ad5d-ca30a1bc57d6 Fri, 16 Sep 2022 10:07:36 GMT SK1 2022-09-16T10:07:36Z