Minus query in HIVE -

minus query seems not work in hive.

tried ex:

select x abc  minus  select x bcd ;

am doing wrong or minus query isn't defined hive? if so, there other way result this?

it not appear hql supports minus operator. see relevant, albeit bit old, resource:

what want can done left join or not exists:

select x abc left join bcd on abc.x = bcd.x bcd.x null

edit: per comments below, not exists not supported.

select x  abc not exists (select x bcd)

Th