hadoop - Compare two tables in Hive without apply JOINS -

hadoop - Compare two tables in Hive without apply JOINS -

i have 2 tables, tablea , tableb. both having same set of columns c1, c2. need compare both table having same info or not. how do without utilize join. tried minus operator ie., select * tablea minus select * tableb not supported in hive. may impala has set operator?

please suggest how without joins. thanks.

you can seek with

select * t1 not exists (select * t2 t1.x = t2.y)

where t1.x = t2.y "key"

hadoop