[
https://issues.apache.org/jira/browse/HIVE-935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12786661#action_12786661
]
Namit Jain commented on HIVE-935:
---------------------------------
I thought about it more and also checked documentation for other databases for
similar functionality.
Having a hard-coded column name does not seem like a good idea.
I would propose the following syntax:
select ... as T LATERAL VIEW UDTF() <table_alias> as <column_names>
or
select ... as T LATERAL VIEW UDTF() <table_alias> as <column_schema>
In the second case, we should do appropriate type conversions.
Oracle, LucidDB let the user define the schema. We should also let the user
define that.
@Paul, hopefully, this will not require many changes to the patch. But, we
should finalize the
syntax first before you continue on coding. Both <table_alias> and
<column_names>/<column_schema>
are mandatory. We can split this, and support <column_schema> later if that
makes it easier.
Any suggestions.
> support LATERAL VIEW
> --------------------
>
> Key: HIVE-935
> URL: https://issues.apache.org/jira/browse/HIVE-935
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Paul Yang
> Attachments: HIVE-935.1.patch, HIVE-935.2.patch, HIVE-935.3.patch,
> HIVE-935.4.patch, HIVE-935.5.patch
>
>
> For table functions, the following syntax should be supported
> select ... from T LATERAL VIEW explode(adid_list) as adid,...
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
