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:
|