hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zheng Shao (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-655) Add support for user defined table generating functions
Date Fri, 13 Nov 2009 15:33:39 GMT

    [ 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.


Mime
View raw message