Re: Both Left and Right Aliases Encountered in Join

2012-07-20 Thread Navis류승우
se typos. >> -- >> *From: * Techy Teck >> *Date: *Fri, 20 Jul 2012 15:44:36 -0700 >> *To: * >> *ReplyTo: * user@hive.apache.org >> *Subject: *Both Left and Right Aliases Encountered in Join >> >> I have a joi

Re: Both Left and Right Aliases Encountered in Join

2012-07-20 Thread Techy Teck
t from handheld, please excuse typos. > -- > *From: * Techy Teck > *Date: *Fri, 20 Jul 2012 15:44:36 -0700 > *To: * > *ReplyTo: * user@hive.apache.org > *Subject: *Both Left and Right Aliases Encountered in Join > > I have a join query on which I

Re: Both Left and Right Aliases Encountered in Join

2012-07-20 Thread Bejoy KS
eck Date: Fri, 20 Jul 2012 15:44:36 To: 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(tab

Both Left and Right Aliases Encountered in Join

2012-07-20 Thread Techy Teck
sis: 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?