hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brenden Cobb <>
Subject Query difference between 2 tables
Date Tue, 22 Jul 2014 18:01:51 GMT

I'm stuck on Hive .10 right now and I'm trying to figure out how to accomplish the equivalent
of a not exists or minus statement:

Select x from t1 where x not in ( select x from t2)

I know this kind of subquery is available in .13 but would like to find a workaround.

Appreciate any suggestions.

View raw message