hadoop-hive-dev mailing list archives

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

    [ https://issues.apache.org/jira/browse/HIVE-655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12777748#action_12777748
] 

Raghu Murthy commented on HIVE-655:
-----------------------------------

There was an alternate syntax to TRANSFORM.

FROM (
MAP columnlist USING mapscript AS newcolumnlist
FROM tablename ) a
REDUCE a.newcolumnlist USING reducescript

IIRC we later decided to just use TRANSORM for both map and reduce.  
The lateral view syntax is more expressive. But I think it makes it  
simpler to specify udtf in select clause if it's the only thing  
specified, similar to transform.




> 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