hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ryu Kobayashi (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11235) If the real table name and the CTE is the same, we can not see the CTE
Date Wed, 15 Jul 2015 09:53:04 GMT

    [ https://issues.apache.org/jira/browse/HIVE-11235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14627822#comment-14627822
] 

Ryu Kobayashi commented on HIVE-11235:
--------------------------------------

[~ychena] Thank you for confirm. Certainly it was no problem in the master branch. Do you
know this fix ticket?

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

Mime
View raw message