hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Trivial Update of "Hive/HiveQL/GroupBy" by ZhengShao
Date Wed, 21 Jan 2009 23:18:47 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.

The following page has been changed by ZhengShao:
http://wiki.apache.org/hadoop/Hive/HiveQL/GroupBy

------------------------------------------------------------------------------
+ [[TableOfContents]]
  
  == Group By Syntax ==
  {{{
+ groupByClause: GROUP BY groupByExpression (, groupByExpression)*
  
+ groupByExpression: expression
+ 
+ groupByQuery: SELECT expression (, expression)* FROM src groupByClause?
  }}}
  
- == Simple Examples ==
+ === Simple Examples ===
+ In order to count the number of rows in a table:
+ {{{
+   SELECT COUNT(1) FROM table2;
+ }}}
+ 
  In order to count the number of distinct users by gender one could write the following query:
  {{{
    INSERT OVERWRITE TABLE pv_gender_sum

Mime
View raw message