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:

Reply via email to