Versions Compared

Old Version 8

changes.mady.by.user Lefty Leverenz

Saved on

compared with

New Version 9

changes.mady.by.user Lefty Leverenz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: add information about hive.groupby.orderby.position.alias (HIVE-581)

...

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

Simple Examples

In order to count the number of rows in a table:

...