Re: Regarding query in HiveResultSet

2015-07-31 Thread Renuka Be
Hi Nitin, I am using hive query. Regards, Renuka N. On Fri, Jul 31, 2015 at 2:42 AM, Nitin Pawar nitinpawar...@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 renunalin...@gmail.com wrote: Hi Folks, I

Re: Regarding query in HiveResultSet

2015-07-31 Thread Nitin Pawar
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 renunalin...@gmail.com wrote: Hi Nitin, I am using hive query. Regards, Renuka N. On Fri, Jul 31, 2015 at 2:42 AM, Nitin Pawar

Re: Regarding query in HiveResultSet

2015-07-31 Thread Nitin Pawar
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 renunalin...@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

Re: Regarding query in HiveResultSet

2015-07-31 Thread Nitin Pawar
why don't you get those as result of query results instead of iterating through all on c# side? your query can directly provide min and max is there is a specific thing which is blocking you from getting from hive and do it on application side? On Fri, Jul 31, 2015 at 4:14 PM, Renuka Be

Regarding query in HiveResultSet

2015-07-30 Thread Renuka Be
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