hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-13733) CTE + "IS NULL" predicate + column aliasing as existing column leads to wrong results
Date Wed, 11 May 2016 19:53:12 GMT

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

Jesus Camacho Rodriguez updated HIVE-13733:
-------------------------------------------
    Assignee: Pengcheng Xiong  (was: Jesus Camacho Rodriguez)

> CTE + "IS NULL" predicate + column aliasing as existing column leads to wrong results

> --------------------------------------------------------------------------------------
>
>                 Key: HIVE-13733
>                 URL: https://issues.apache.org/jira/browse/HIVE-13733
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 1.1.0
>            Reporter: Dudu Markovitz
>            Assignee: Pengcheng Xiong
>
> hive> create table t (i int,a string,b string);
> hive> insert into t values (1,'hello','world'),(2,'bye',null);
> hive> select * from t where t.b is null;
> 2	bye	NULL
> This is wrong, all 3 columns should return the same value - t.a.
> hive> with cte as (select t.a as a,t.a as b,t.a as c from t where t.b is null) select
* from cte;
> bye	NULL	bye
> However, these are right:
> hive> select t.a as a,t.a as b,t.a as c from t where t.b is null;
> bye	bye	bye
> hive> with cte as (select t.a as a,t.a as b,t.a as c from t where t.b is not null)
select * from cte;OK
> hello	hello	hello



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

Mime
View raw message