Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of edlinuxguru@gmail.com
 designates 209.85.160.48 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAOT3TWomyyLDasZfVpejrmtVkG8LXqEA_hM=Em5qF16Vypd2jA@mail.gmail.com>
References: 
 <CAOT3TWpbxL-Pcx7g0zcot=-4oJajENmGp+dfYM_Zym62h2tDew@mail.gmail.com>
	<CAOT3TWomyyLDasZfVpejrmtVkG8LXqEA_hM=Em5qF16Vypd2jA@mail.gmail.com>
Date: Thu, 24 May 2012 17:19:05 -0400
Message-ID: 
 <CAENxBwxUci=RjmFh9WMsrUY=Z_Zb=-ED+ohJRwK-BVp1D30LiA@mail.gmail.com>
Subject: Re: SQL help
From: Edward Capriolo <edlinuxguru@gmail.com>
To: user@hive.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hive is not SQL 92 compliant or whatever.

https://cwiki.apache.org/Hive/languagemanual.html

in particular you can not do subselects inside the in or the where
clause. Hive usually have other formulations like left semi join that
makes things 'like in' and 'not in' possible.

Edward
On Thu, May 24, 2012 at 5:13 PM, Mohit Anchlia <mohitanchlia@gmail.com> wro=
te:
> I am now trying to do it this way but doesn't work in hive. I think I am
> missing something here, can someone please help?
>
> select a_id from web_data t1 where a_id =3D (select min(a_id) from web_da=
ta t2
> where t2.t_timestamp =3D t1.t_timestamp)
>
> I get:
>
>
> FAILED: Parse Error: line 1:69 cannot recognize input near 'select' 'min'
> '(' in expression specification
>
>
>
> On Thu, May 24, 2012 at 1:02 PM, Mohit Anchlia <mohitanchlia@gmail.com>
> wrote:
>>
>> I am new to Hive. I have several SQL from RDBMS database that I need to
>> convert to hive. What's the best reference for HIVEQL? For now I am tryi=
ng
>> to figure out how to do this in hive:
>>
>> Select=A0 distinct A_ID, First_Value(path IGNORE NULLS) over(PARTITION B=
Y
>> A_ID ORDER BY t_timestamp) From WEB_DATA
>>
>> Any help would be appreciated.
>
>
>