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.MoveTask
But 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
