You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2009/11/13 01:24:39 UTC
[jira] Commented: (HIVE-655) Add support for user defined table
generating functions
[ 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.