hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pengcheng Xiong (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-10698) query on view results fails with table not found error if view is created with subquery alias (CTE).
Date Wed, 13 May 2015 18:25:01 GMT
Pengcheng Xiong created HIVE-10698:
--------------------------------------

             Summary: query on view results fails with table not found error if view is created
with subquery alias (CTE).
                 Key: HIVE-10698
                 URL: https://issues.apache.org/jira/browse/HIVE-10698
             Project: Hive
          Issue Type: Bug
            Reporter: Pengcheng Xiong


To reproduce it, 

{code}
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`
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message