Hive QL Except clause -

how do except clause (like sql) in hive ql

i have 2 tables, , each table column of unique ids, want find list of ids in table 1 not in table 2

table 1 apple orange pear

table 2 apple orange

in sql can except clause (http://en.wikipedia.org/wiki/set_operations_%28sql%29) can't in hive ql

i don't think there's built-in way left outer join should trick.

this selects ids table1 not exist in table2:

select t1.id table1 t1 left outer join table2 t2 on (t1.id=t2.id) t2.id null;

Funaction