[
https://issues.apache.org/jira/browse/HIVE-655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12778439#action_12778439
]
Ning Zhang commented on HIVE-655:
---------------------------------
+1 the plan.
@Zheng, lateral view is typically used to write a view in SQL (usually not
UDTF) that can be embedded in the FROM clause and reference other tables in the
same FROM clause. Oracle and DB2 (maybe MS SQLServer as well) all have their
own table function definitions that are similar to our UDTF. Internally their
table function implementations may use lateral views if possible.
Let's have a detailed design discussion about how to implement lateral views
when you are back, as Rugu mentioned lateral views is quite expressive.
> 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.
