Page History

...

groupByClause: GROUP BY groupByExpression (, groupByExpression)*

groupByExpression: expression

groupByQuery: SELECT expression (, expression)* FROM src groupByClause?

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:

• 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:

...