hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Renuka Be <renunalin...@gmail.com>
Subject Re: Regarding query in HiveResultSet
Date Fri, 31 Jul 2015 10:44:54 GMT
I have used hive query to get column values that returns HiveResultSet. I
need to find Min and Max value in HiveResultSet in code level.
Is there any possibility. I am using c#.

-Renuka N


On Fri, Jul 31, 2015 at 3:29 AM, Nitin Pawar <nitinpawar432@gmail.com>
wrote:

> 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