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

["Ryu Kobayashi (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-11235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ryu Kobayashi resolved HIVE-11235.
----------------------------------
    Resolution: Won't Fix

> 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)