[jira] [Created] (HIVE-11235) If the real table name and the CTE is the same, we can not see the CTE

[Ryu Kobayashi (JIRA)]

Ryu Kobayashi created HIVE-11235:
------------------------------------

             Summary: If the real table name and the CTE is the same, we can 
not see the CTE
                 Key: HIVE-11235
                 URL: https://issues.apache.org/jira/browse/HIVE-11235
             Project: Hive
          Issue Type: Bug
            Reporter: Ryu Kobayashi


If the real table name and the CTE is the same, we can not see the CTE.
{code}
create table foo(id int);

insert into foo values(1);

hive> with foo as (
    > select 10 as id)
    > select id from foo;
OK
1
{code}

In the case of PostgreSQL, 10 is returned.



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