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.

View raw message