...
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 when configured as follows:
- Set For Hive 0.11.0 through 2.1.x, set hive.groupby.orderby.position.alias to true (the default is false) for .
- For Hive 02.112.0 through 2.1.x.Set and later, 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:
...