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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.0
• Fix Version/s: 1.2.1
• Component/s: Parser
• Assignee: Prasad Suresh Mujumdar
• Reporter: Prasad Suresh Mujumdar
• Created: 02/Mar/15 19:50
• Updated: 01/Jun/15 15:39
• Resolved: 09/May/15 09:34

Description

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,

create view view1 as select t.id from (select tab1.id from db.tab1 union all select tab2.id from db.tab2 ) t;

This query will capture tab1 and tab2 as read entity without view1 as parent.

Issue Links

• links to: Review #31882
• mentioned in: Wiki Page Loading...