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: