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/LanguageManual/Transform" by HenryLudemann
Date Wed, 26 May 2010 06:33:15 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.

The "Hive/LanguageManual/Transform" page has been changed by HenryLudemann.
The comment on this change is: The row format appears to have to come after the 'AS'. Not
doing so results in a "...cannot recognize input 'as' in record reader specification..." error..
http://wiki.apache.org/hadoop/Hive/LanguageManual/Transform?action=diff&rev1=18&rev2=19

--------------------------------------------------

      MAP expression (',' expression)*
      (inRowFormat)?
      USING 'my_map_script'
+     ( AS colName (',' colName)* )?
      (outRowFormat)? (outRecordReader)?
-     ( AS colName (',' colName)* )?
      ( clusterBy? | distributeBy? sortBy? ) src_alias
    )
    REDUCE expression (',' expression)*
      (inRowFormat)?
      USING 'my_reduce_script'
+     ( AS colName (',' colName)* )?
      (outRowFormat)? (outRecordReader)?
-     ( AS colName (',' colName)* )?
  
    FROM (
      FROM src
      SELECT TRANSFORM '(' expression (',' expression)* ')'
      (inRowFormat)?
      USING 'my_map_script'
+     ( AS colName (',' colName)* )?
      (outRowFormat)? (outRecordReader)?
-     ( AS colName (',' colName)* )?
      ( clusterBy? | distributeBy? sortBy? ) src_alias
    )
    SELECT TRANSFORM '(' expression (',' expression)* ')'
      (inRowFormat)? 
      USING 'my_reduce_script'
+     ( AS colName (',' colName)* )?
      (outRowFormat)? (outRecordReader)?
-     ( AS colName (',' colName)* )?
  }}}
  
  Example #1:

Mime
View raw message