[
https://issues.apache.org/jira/browse/HIVE-655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12777294#action_12777294
]
Namit Jain commented on HIVE-655:
---------------------------------
Since it is a table function, I think we should limit its usage, i.e only 1
item can be present in the select clause.
SELECT explode(list1), EXPLODE(list2) FROM mytable;
should throw an error instead of returning (list1, list2) pairs.
We can always do it via a sub-query.
select * from
(SELECT explode(list1) from mytable)sq1 join (select * from EXPLODE(list2)
FROM mytable) sq2;
If need be, we can add it later in a follow-up jira
> 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
>
>
> 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.
