hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: Regarding query in HiveResultSet
Date Fri, 31 Jul 2015 07:29:06 GMT
then why not just use max function?

select max(a) from (select sum(a) as a, b from t group by b)n

On Fri, Jul 31, 2015 at 12:48 PM, Renuka Be <renunalinibe@gmail.com> wrote:

> Hi Nitin,
>
> I am using hive query.
>
> Regards,
> Renuka N.
>
> On Fri, Jul 31, 2015 at 2:42 AM, Nitin Pawar <nitinpawar432@gmail.com>
> wrote:
>
>> are you writing your java code using hive or you are writing hive query?
>>
>> On Fri, Jul 31, 2015 at 11:13 AM, Renuka Be <renunalinibe@gmail.com>
>> wrote:
>>
>>> Hi Folks,
>>>
>>> I want to find Max value from the HiveResult. There is option listed in
>>> HiveResultSet properties "HiveResultSet.Max()". When i use this
>>> 'HiveResultSet.Max()' it throws exception.
>>>
>>> Error : At least one object must implement IComparable.
>>>
>>> Is there any way to find Min, Max from the HiveResultSet?
>>>
>>> Thanks,
>>> Renuka N.
>>>
>>
>>
>>
>> --
>> Nitin Pawar
>>
>
>


-- 
Nitin Pawar

Mime
View raw message