[
https://issues.apache.org/jira/browse/HIVE-655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12777527#action_12777527
]
Zheng Shao commented on HIVE-655:
---------------------------------
I think we should support:
SELECT pageid, explode(adid_list)...
This will probably be the most popular query that people will write. Otherwise
I don't know how many people will actually use UDTF ...
I don't think we have to follow Oracle's syntax here. Oracle's UDTF may not
support the "explode" feature as described above.
This syntax looks much cleaner. Transform is actually a UDTF in Oracle's sense,
but we didn't follow Oracle's syntax.
We can give it a different name if calling this UDTF causes confusion. The real
use case above (and the single "explode" function) will probably dominate what
users will write.
> Add support for user defined table generating functions
> -------------------------------------------------------
>
> Key: HIVE-655
> URL: https://issues.apache.org/jira/browse/HIVE-655
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Raghotham Murthy
> Assignee: Paul Yang
> Attachments: HIVE-655.1.patch, HIVE-655.2.patch
>
>
> Provide a way for users to add a table generating function, i.e., functions
> that generate multiple rows from a single input row. Currently, the only way
> to do it is via the TRANSFORM clause which requires streaming the data.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
