[jira] [Commented] (HIVE-9828) Semantic analyzer does not capture view parent entity for tables referred in view with union all

["Thejas M Nair (JIRA)" <ji...@apache.org>]

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

Thejas M Nair commented on HIVE-9828:
-------------------------------------

[~sushanth]
This is an important bug fix for authorization. I have included this in the 1.2.1 bug list in wiki.


> 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
>            Assignee: Prasad Mujumdar
>             Fix For: 1.3.0
>
>         Attachments: HIVE-9828.1-npf.patch, HIVE-9828.1-npf.patch, HIVE-9828.2.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)