hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raihan Jamal <jamalrai...@gmail.com>
Subject Anything wrong with this query?
Date Fri, 13 Jul 2012 16:06:31 GMT
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*

Mime
View raw message