r.java:156)
>>
>> Regards
>> Yogesh Kumar
>>
>> --
>> Subject: Re: ERROR: Hive subquery showing
>> To: user@hive.apache.org
>> From: bejoy...@yahoo.com
>> Date: Thu, 27 Sep 2012 19:48:25 +
>>
>> Hi yogesh
>>
&
hodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
>
> Regards
> Yogesh Kumar
>
> --
> Subject: Re: ERROR: H
java.lang.reflect.Method.invoke(Method.java:601)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
Regards
Yogesh Kumar
Subject: Re: ERROR: Hive subquery showing
To: user@hive.apache.org
From: bejoy...@yahoo.com
Date: Thu, 27 Sep 2012 19:48:25 +
Hi yogesh
What about a query like this
select name
output: 8
which can be obtained by simple : select MAX(grp) from ABC ( I think here outer
query is not performing)
Please Suggest
Regards
Yogesh Kumar
Date: Thu, 27 Sep 2012 15:33:11 -0400
Subject: Re: ERROR: Hive subquery showing
From: chen.song...@gmail.com
To: user@hive.apache.org
Can you try
Hi yogesh
What about a query like this
select name from ABC WHERE grp=MAX(grp);
Regards
Bejoy KS
Sent from handheld, please excuse typos.
-Original Message-
From: Chen Song
Date: Thu, 27 Sep 2012 15:33:11
To:
Reply-To: user@hive.apache.org
Subject: Re: ERROR: Hive subquery showing
Can you try this?
*
*
*select name from ( select MAX(grp) as name from ABC ) gy ;*
On Thu, Sep 27, 2012 at 3:29 PM, yogesh dhari wrote:
> Hi all,
>
> I have a table called ABC, like
>
> namegrp
> A 1
> B 2
> C 4
> D 8
>
> I want the output lik
Hi all,
I have a table called ABC, like
namegrp
A 1
B 2
C 4
D 8
I want the output like the name having greatest grp i.e D;
I wrote a query:
select name from ( select MAX(grp) from ABC ) gy ;
but it gives error
FAILED: Error in semantic ana
