[
https://issues.apache.org/jira/browse/HIVE-9828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14356118#comment-14356118
]
Prasad Mujumdar commented on HIVE-9828:
---------------------------------------
[~Yibing] This particular issue is specific to union all since the view aliases
are mangled which breaks the normal alias lookup logic. Are you hitting the
problem specifically for any other type of queries ?
> Semantic analyzer does not capture view parent entity for tables referred in
> view with union all
> -------------------------------------------------------------------------------------------------
>
> Key: HIVE-9828
> URL: https://issues.apache.org/jira/browse/HIVE-9828
> Project: Hive
> Issue Type: Bug
> Components: Parser
> Affects Versions: 1.1.0
> Reporter: Prasad Mujumdar
> Fix For: 1.2.0
>
> Attachments: HIVE-9828.1-npf.patch
>
>
> Hive compiler adds tables used in a view definition in the input entity list,
> with the view as parent entity for the table.
> In case of a view with union all query, this is not being done property. For
> example,
> {noformat}
> create view view1 as select t.id from (select tab1.id from db.tab1 union all
> select tab2.id from db.tab2 ) t;
> {noformat}
> This query will capture tab1 and tab2 as read entity without view1 as parent.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
