[Hadoop Wiki] Update of "Hive/HiveQL/Transform" by ZhengShao

[Apache Wiki]

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/Transform

New page:
[[TableOfContents]]


== Transform/Map-Reduce Syntax ==

{{{

clusterBy: CLUSTER BY colName (, colName)*
distributeBy: DISTRIBUTE BY colName (, colName)*
sortBy: SORT BY colName (, colName)*

query:
  FROM (
    FROM src
    MAP ( expression (, expression)* )
    USING 'my_map_script'
    ( AS (colName (, colName)* ) )?
    ( clusterBy? | distributeBy? sortBy? )
  )
  REDUCE ( expression (, expression)* )
    USING 'my_reduce_script'
    ( AS (colName (, colName)* ) )?

}}}

== Transform/Map-Reduce Examples ==