THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
In groupByExpression
columns are specified by name, not by position number. However in in Hive 0.11.0 and and later, columns can be specified by position if when configured as follows:
- For Hive 0.11.0 through 2.1.x, set hive.groupby.orderby.position.alias
...
- to true (the default is false).
- For Hive 2.2.0 and later, set hive.groupby.position.alias to true (the default is false).
Simple Examples
In order to count the number of rows in a table:
...