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 >> Re: Regarding the error in Hive query


Copy link to this message
-
Re: Regarding the error in Hive query
(moving to user@hive, bcc'ing dev@hive)

Hi Bhavesh -

Hive only supports equality conditions for joins.  See

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins

cheers,
-James

On Tue, Jan 3, 2012 at 10:16 PM, Bhavesh Shah <[EMAIL PROTECTED]>wrote:

> Hello,
> I am trying to implement join query in HIve but I am getting error.
>
> My query is:
> insert overwrite table t1 select subset.* from subset s JOIN testencounter
> t on (t.patient_mrn =s.patient_mrn and t.encounter_date<=s.encounter_date)
> where s.cad=0;
> I am getting error as:
> FAILED: Error in semantic analysis: Line 1:114 Both left and right aliases
> encountered in JOIN Encounter_Date
>
> What is this error I am not getting it? Pls suggest me some solution.
>
>
> --
> Thanks and Regards,
> Bhavesh Shah
>
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