Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Join with OR condition in hive


Copy link to this message
-
Re: Join with OR condition in hive
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 <[EMAIL PROTECTED]>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
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB