[HIVE-10698] query on view results fails with table not found error if view is created with subquery alias (CTE).

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0, 2.0.0
• Component/s: Query Planning
• Assignee: Pengcheng Xiong
• Reporter: Pengcheng Xiong
• Created: 13/May/15 18:24
• Updated: 17/Nov/16 17:41
• Resolved: 31/May/15 07:53

Description

To reproduce it,

use bugtest;
create table basetb(id int, name string);
create view testv1 as
with subtb as (select id, name from bugtest.basetb)
select id from subtb;
use castest;
explain select * from bugtest.testv1;
hive> explain select * from bugtest.testv1;
FAILED: SemanticException Line 2:15 Table not found 'subtb' in definition of VIEW testv1 [
with subtb as (select id, name from bugtest.basetb)
select id from `bugtest`.`subtb`
] used as testv1 at Line 1:22
Note that there is a database prefix `bugtest`.`subtb`

Issue Links

• is related to: HIVE-15231 query on view with CTE and alias fails with table not found error
• is related to: HIVE-9897 Issue a warning when using an existing table/view name as an alias in a with statement.
• relates to: HIVE-11728 WITH clause uses regular table instead of intermidiate relation when regular table exits with same name as of intermidiate relation.
• relates to: HIVE-9897 Issue a warning when using an existing table/view name as an alias in a with statement.