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 hive.groupby.orderby.position.alias is set to true (the default is false).
...