changes.mady.by.user Mark Grover
Saved on Nov 20, 2012
changes.mady.by.user Lefty Leverenz
Saved on Jun 03, 2013
...
Note that for versions of Hive which don't include HIVE-287, you'll need to use COUNT(1) in place of COUNT.
See Enhanced Aggregation, Cube, Grouping and Rollup.