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 ===
