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] Update of "Hive/HiveQL" by RaghothamMurthy
Date Mon, 06 Oct 2008 06:52:57 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 RaghothamMurthy:
http://wiki.apache.org/hadoop/Hive/HiveQL

------------------------------------------------------------------------------
  {{{
  CAST (expression AS primitive_type)
  }}}
+ 
+ 
  === Joins ===
  {{{
  from_list: from_source [LEFT OUTER|RIGHT OUTER|FULL OUTER] JOIN ON (equality_expression,
equality_expression, ...)
@@ -167, +169 @@

  select_statement UNION ALL select_statement
  }}}
  
+ === Custom Map Reduce Scripts ===
+ {{{
+ 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 ==
  {{{

Mime
View raw message