How do you join two tables that aren't represented in both sides of the =? Can you describe a bit more of what you are trying to get out of the data? I am having a hard time wrapping my head around this...
On Wed, Aug 29, 2012 at 4: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 >
