Join with OR condition in hive

[sonia gehlot]

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