--- On Mon, 5/6/13, Peter Chu <pete....@outlook.com> 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
