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 >
