[HIVE-15231] query on view with CTE and alias fails with table not found error

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.0
• Fix Version/s: 2.3.0
• Component/s: Query Planning
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 17/Nov/16 17:40
• Updated: 21/Jul/17 18:26
• Resolved: 18/Nov/16 14:09

Description

HIVE-10698 fixed one issue of the query on view with CTE, but it seems to break another case if a alias is given for the CTE.

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 a;
use castest;
explain select * from bugtest.testv1;
hive> explain select * from bugtest.testv1;

FAILED: SemanticException Line 2:21 Table not found 'subtb' in definition of VIEW testv1 [
with subtb as (select `basetb`.`id`, `basetb`.`name` from `bugtest`.`basetb`)
select `a`.`id` from `bugtest`.`subtb` `a`
] used as testv1 at Line 1:14

Issue Links

• relates to: HIVE-10698 query on view results fails with table not found error if view is created with subquery alias (CTE).