Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A51B29C5B for ; Thu, 5 Jan 2012 02:50:16 +0000 (UTC) Received: (qmail 42816 invoked by uid 500); 5 Jan 2012 02:50:16 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 42679 invoked by uid 500); 5 Jan 2012 02:50:15 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 42670 invoked by uid 99); 5 Jan 2012 02:50:14 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Jan 2012 02:50:14 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of jameswarren3@gmail.com designates 209.85.220.176 as permitted sender) Received: from [209.85.220.176] (HELO mail-vx0-f176.google.com) (209.85.220.176) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Jan 2012 02:50:07 +0000 Received: by vcbfl13 with SMTP id fl13so95771vcb.35 for ; Wed, 04 Jan 2012 18:49:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:reply-to:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:content-type; bh=Ul+NplIXGUWrPCM6rPG9SqP6wL5TIc+YWm8nfw18Fc0=; b=QpeWFr5sqgF+ypc7fY9ieb+h34+ucrn2ijYxuB/mXALMID6EtlmHNSGLmQpmRPNvhV Buz8gR35XWtYAV28vlTisOZagyEMsYSJVzDNnAZQMGiSXCZinMRfOqn1jYhME3D3DzLb vzjUb4cSDYvasEXHyVncrvFV+hFqx2FOWRAtM= Received: by 10.221.13.196 with SMTP id pn4mr48532vcb.74.1325731786161; Wed, 04 Jan 2012 18:49:46 -0800 (PST) MIME-Version: 1.0 Reply-To: james.warren@stanfordalumni.org Sender: jameswarren3@gmail.com Received: by 10.52.175.102 with HTTP; Wed, 4 Jan 2012 18:49:05 -0800 (PST) In-Reply-To: References: From: James Warren Date: Wed, 4 Jan 2012 18:49:05 -0800 X-Google-Sender-Auth: nHWgNuYL4MM9-x6YeDWuoHTRxkc Message-ID: Subject: Re: Regarding the error in Hive query To: user@hive.apache.org Content-Type: multipart/alternative; boundary=bcaec54fb9e02e7c5f04b5befcc7 --bcaec54fb9e02e7c5f04b5befcc7 Content-Type: text/plain; charset=ISO-8859-1 (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 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 > --bcaec54fb9e02e7c5f04b5befcc7--