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 >> Anything wrong with this query?


Copy link to this message
-
Re: Anything wrong with this query?
The LEFT and the RIGHT JOIN is invalid, you need  LEFT OUTER JOIN or RIGHT
OUTER JOIN or just JOIN (no INNER JOIN)

On Fri, Jul 13, 2012 at 11:06 AM, Raihan Jamal <[EMAIL PROTECTED]>wrote:

> Whenever I try to run this below query, I always get error as OR is not
> supported in JOIN? Is there any other way of doing this query?
>
>
>    SELECT *
>     FROM   TestingTable1 tt1 LEFT JOIN TestingTable2 tt2
>     ON tt1.buyer_id     = tt2.user_id
>   AND (tt1.item_id      = tt2.product_id
>     OR unix_timestamp(tt1.created_time) = tt2.timestamps)
>
>
> Any suggestions will be appreciated.
>
>
> *Raihan Jamal*
>
>
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