t_timestamp )
>
Awesome that works. I didn't realize I could do it this way. Thanks for
your help and others as well.
>
> -Nicole
>
> From: Roberto Sanabria
> Reply-To:
> Date: Thu, 24 May 2012 15:06:29 -0700
> To:
> Subject: Re: SQL help
>
> "I guess d
ply-To: mailto:user@hive.apache.org>>
Date: Thu, 24 May 2012 15:06:29 -0700
To: mailto:user@hive.apache.org>>
Subject: Re: SQL help
"I guess do some kind of group by and store it in intermediate file and run
another select on it?"
Yes, that is my recommendation.
On Thu, May 24, 20
"I guess do some kind of group by and store it in intermediate file and run
another select on it?"
Yes, that is my recommendation.
On Thu, May 24, 2012 at 2:57 PM, Mohit Anchlia wrote:
>
>
> On Thu, May 24, 2012 at 2:19 PM, Edward Capriolo wrote:
>
>> Hive is not SQL 92 compliant or whatever.
>>
On Thu, May 24, 2012 at 2:19 PM, Edward Capriolo wrote:
> 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
>
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
You can try using where a_id in (subquery). But I don't think hive supports
subqueries in where clauses. You would have to turn this into a join
statement.
On Thu, May 24, 2012 at 2:13 PM, Mohit Anchlia wrote:
> I am now trying to do it this way but doesn't work in hive. I think I am
> missing so
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 = (select min(a_id) from web_data
t2 where t2.t_timestamp = t1.t_timestamp)
I get:
FAILED: Parse Error: line 1:69 cannot recognize in
Hi Mohit,
Hive does not support window functions afaik.
The following link might be useful if you can bring that in...
https://github.com/hbutani/SQLWindowing/wiki
Not sure if this is being brought into trunk at some point...
Ashish
On Thu, May 24, 2012 at 1:02 PM, Mohit Anchlia wrote:
> I a
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 trying
to figure out how to do this in hive:
Select distinct A_ID, First_Value(path IGNORE NULLS) over(PARTITION BY
A_ID ORDER BY t_timestamp) From WEB_DATA
