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

------------------------------------------------------------------------------
  === Group By's ===
  HiveQL/GroupBy
  
- === Cluster By/Distribute By/Sort By ===
- HiveQL/ClusterBy
- 
  === Multi-table Insert Statement ===
  {{{
  FROM from_list
@@ -184, +181 @@

  }}}
  
  === Custom Map Reduce Scripts ===
+ [HiveQL/Transform] including ''Cluster By'' / ''Distribute By'' / ''Sort By''.
+ 
- {{{
- FROM src (
-   TRANSFORM (col_list) AS (new_col_list) USING 'mapper_script'
-   CLUSTER BY (new_cols) -- new_cols is a subset of new_col_list
- ) map_alias
- [insert_clause]
- SELECT TRANSFORM(new_col_list) AS (result_col_list) USING 'reducer_script'
- }}}
  
  = Hive Utility Statements =
  == Describe table ==

Reply via email to