[
https://issues.apache.org/jira/browse/HIVE-5737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16345348#comment-16345348
]
Shawn Weeks commented on HIVE-5737:
-----------------------------------
Was this ever fully implemented? I can't find any examples of anyone using this
and Hive gives me a semantic error when I try to include column names in a call
to a custom udtf that I'm writing. I've verified that this patch is included in
the release I'm working with.
select xml_explode('<xml></xml>','blah' as col1,'blah' as col2)
SQL Error [40000] [42000]: Error while compiling statement: FAILED:
ParseException line 1:40 missing ) at 'as' near '<EOF>'
line 1:62 extraneous input ')' expecting EOF near '<EOF>'
Error while compiling statement: FAILED: ParseException line 1:40 missing )
at 'as' near '<EOF>'
line 1:62 extraneous input ')' expecting EOF near '<EOF>'
Error while compiling statement: FAILED: ParseException line 1:40 missing )
at 'as' near '<EOF>'
line 1:62 extraneous input ')' expecting EOF near '<EOF>'
org.apache.hadoop.hive.ql.parse.ParseException:line 1:40 missing ) at
'as' near '<EOF>'
line 1:62 extraneous input ')' expecting EOF near '<EOF>'
org.apache.hadoop.hive.ql.parse.ParseException:line 1:40 missing ) at
'as' near '<EOF>'
line 1:62 extraneous input ')' expecting EOF near '<EOF>'
> Provide StructObjectInspector for UDTFs rather than ObjectInspect[]
> -------------------------------------------------------------------
>
> Key: HIVE-5737
> URL: https://issues.apache.org/jira/browse/HIVE-5737
> Project: Hive
> Issue Type: Improvement
> Components: UDF
> Reporter: Navis
> Assignee: Navis
> Priority: Trivial
> Fix For: 0.13.0
>
> Attachments: HIVE-5737.1.patch.txt
>
>
> In UDTF, column names can be useful sometimes. For example, complex function
> with many optional parameters something like,
> xml_explode('\t' as field, '\n' as line, '=' as mapkey, ':' as items, input)
> Without column name, it's not easy to discern each parameter is for what.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
