ah, thanks Erek. I can easily handle this in where clause.
Thanks much. Sonia On Wed, Aug 29, 2012 at 2:52 PM, Erek Dyskant <e...@dyskant.net> wrote: > select blah > from table a > Left Join table b *on (a.col1 = b.col2)* > *where b.col2 is not null or a.col1 = 0* > > > On Wed, Aug 29, 2012 at 5:44 PM, sonia gehlot <sonia.geh...@gmail.com>wrote: > >> 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 >> > >
