Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Re: Hive Group By Limitations


Copy link to this message
-
Re: Hive Group By Limitations

--- On Mon, 5/6/13, Peter Chu <[EMAIL PROTECTED]> wrote:

> In Hive, I cannot perform a SELECT GROUP BY on fields not in the GROUP BY
> clause.

Although MySQL allows it, it is not ANSI SQL.

http://stackoverflow.com/questions/1225144/why-does-mysql-allow-group-by-queries-without-aggregate-functions
+
Peter Chu 2013-05-06, 18:07
+
Nitin Pawar 2013-05-06, 18:12
+
Peter Chu 2013-05-06, 18:27
+
Nitin Pawar 2013-05-06, 18:31
+
John Meagher 2013-05-06, 18:34