...
In groupByExpression
columns are specified by name, not by position number. However in Hive 0.11.0 and later, columns can be specified by position if when configured as follows:
...
- to true (the default is false) for Hive 0.11.0 through 2.1.x.
- Set hive.groupby.position.alias to true (the default is false) for Hive 2.2.0 and later.
Simple Examples
In order to count the number of rows in a table:
...