hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sonia gehlot <sonia.geh...@gmail.com>
Subject Join with OR condition in hive
Date Wed, 29 Aug 2012 21:44:06 GMT
Hi All,

I am joining 2 tables in hive, with or condition. for example:

select blah
from table a
Join table b
*on (a.col1 = b.col2 or a.col2 = 0)*
*
*
but this is giving me error that OR not supported in hive currently.

Any suggestion how I can handle this in hive query.

Thanks,
Sonia

Mime
View raw message