hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bejoy KS" <bejoy...@yahoo.com>
Subject Re: Both Left and Right Aliases Encountered in Join
Date Fri, 20 Jul 2012 22:49:49 GMT
Hi

AFAIK hive supports only equi joins. Can you check whether changing that <= to = , removes
the semantic error?

You can give conditions other than equality in a where clause post join.

Regards
Bejoy KS

Sent from handheld, please excuse typos.

-----Original Message-----
From: Techy Teck <comptechgeeky@gmail.com>
Date: Fri, 20 Jul 2012 15:44:36 
To: <user@hive.apache.org>
Reply-To: user@hive.apache.org
Subject: Both Left and Right Aliases Encountered in Join

I have a join query on which I am joining like this below. And it is
working fine

ON (table1.item = prod.product *AND* table1.buyer = prod.user *AND*
UNIX_TIMESTAMP(table1.tt_time)
= prod.timestamps)

But when I tried to modify the above same thing.
The thing that is in red color will work or not If I specify like this? As
when I was running my query having joining like this below.

ON (table1.item = prod.product *AND* table1.buyer = prod.user *AND*
*((UNIX_TIMESTAMP(table1.tt_time)
- (prod.timestamps)) / 60* 1000 <= 15)*)


I am getting error like this-

*FAILED: Error in semantic analysis: Both Left and Right Aliases
Encountered in Join 15*
*
*
*
*
So I guess there is some problem with number 15 at the end? Or we need to
cast something?

Mime
View raw message