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 18:39:00 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

------------------------------------------------------------------------------
  {{{
  [insert_clause] 
  SELECT [ALL|DISTINCT] select_list
- FROM from_list 
+ FROM [table_source|join_source]
  [WHERE where_condition] 
  [GROUP BY col_list] 
  [ORDER BY col_list] 
  [CLUSTER BY col_list]
  
  select_list: expression, expression, ...
+ 
+ table_source
+   : table_name [PARTITION (partition_col = partition_col_value, partition_col = partiton_col_value,
...)] [alias]
+   | ( select_statement ) alias
  }}}
  
  === Expressions ===
@@ -129, +133 @@

  
  === Joins ===
  {{{
+ join_source: table_source join_clause table_source join_clause table_source ...
+ 
- from_list: from_source [LEFT OUTER|RIGHT OUTER|FULL OUTER] JOIN ON (equality_expression,
equality_expression, ...)
+ join_clause: [LEFT OUTER|RIGHT OUTER|FULL OUTER] JOIN ON (equality_expression, equality_expression,
...)
  
  equality_expression: expression = expression
+ 
  }}}
  
  === Multi-table Insert Statement ===

Mime
View raw message