[
https://issues.apache.org/jira/browse/HIVE-13733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dudu Markovitz updated HIVE-13733:
--
Description:
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 NULLbye
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
was:
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 NULLbye
However, this 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
> 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
>
> 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 NULLbye
> 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)
