I wrote this query but everytime I get the below error.
select * from (select t2.buyer_id, t2.item_id, t2.created_time as
created_time, subq.user_id, subq.product_id, subq.timestamps as timestamps
from
(select user_id, prod_and_ts.product_id as product_id,
prod_and_ts.timestamps as timestamps from testingtable2 lateral view
explode(purchased_item) exploded_table as prod_and_ts) subq INNER JOIN
testingtable1 t2 on t2.buyer_id = subq.user_id
AND subq.timestamps = unix_timestamp(t2.created_time)
WHERE (subq.product_id <> t2.item_id)
union all
select t2.buyer_id, t2.item_id as item_id, t2.created_time,
subq.user_id, subq.product_id as product_id, subq.timestamps
from
(select user_id, prod_and_ts.product_id as product_id,
prod_and_ts.timestamps as timestamps from testingtable2 lateral view
explode(purchased_item) exploded_table as prod_and_ts) subq INNER JOIN
testingtable1 t2 on t2.buyer_id = subq.user_id
and subq.product_id = t2.item_id
WHERE (subq.timestamps <> unix_timestamp(t2.created_time)))
unionall;
But I always get error as -
`*FAILED: Parse Error: line 3:184 mismatched input 'INNER' expecting ) in
subquery source`*
*Raihan Jamal*
