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