[ 
https://issues.apache.org/jira/browse/HIVE-9828?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Prasad Mujumdar updated HIVE-9828:
----------------------------------
    Attachment: HIVE-9828.1-npf.patch

> 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
>         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)

Reply via email to