[
https://issues.apache.org/jira/browse/HIVE-18236?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hengyu Dai updated HIVE-18236:
------------------------------
Description:
vectorized execution returned weird result in a simple query.
the following table foo has id column unique and not null, the query should
return 0 for bar, but now it returns the size of foo
{code:sql}
-- 1. result : 20171205 199107
set hive.vectorized.execution.enabled=true;
select
dt,
sum(case when id ='' or id is null then 1 else 0 end) as bar
from foo
where dt=20171205
group by dt
;
-- 2. result : 20171205 0
set hive.vectorized.execution.enabled=false;
select
dt,
sum(case when id ='' or id is null then 1 else 0 end) as bar
from foo
where dt=20171205
group by dt
;
{code}
was:
vectorized execution returned weird result in a simple query.
the following table foo has id column unique and not null, the query should
return 0 for bar, but now it returns the size of foo
{code:sql}
-- 1. result : 20171205 199107
set hive.vectorized.execution.enabled=true;
select
dt,
sum(case when id ='' or id is null then 1 else 0 end) as bar
from foo
where dt=20171205
group by dt
;
-- 2. result : 20171205 0
set hive.vectorized.execution.enabled=tfalse;
select
dt,
sum(case when id ='' or id is null then 1 else 0 end) as bar
from foo
where dt=20171205
group by dt
;
{code}
> Hive vectorized execution returned wrong result
> -----------------------------------------------
>
> Key: HIVE-18236
> URL: https://issues.apache.org/jira/browse/HIVE-18236
> Project: Hive
> Issue Type: Bug
> Components: Hive, Physical Optimizer
> Affects Versions: 2.1.1
> Reporter: Hengyu Dai
>
> vectorized execution returned weird result in a simple query.
> the following table foo has id column unique and not null, the query should
> return 0 for bar, but now it returns the size of foo
> {code:sql}
> -- 1. result : 20171205 199107
> set hive.vectorized.execution.enabled=true;
> select
> dt,
> sum(case when id ='' or id is null then 1 else 0 end) as bar
> from foo
> where dt=20171205
> group by dt
> ;
> -- 2. result : 20171205 0
> set hive.vectorized.execution.enabled=false;
> select
> dt,
> sum(case when id ='' or id is null then 1 else 0 end) as bar
> from foo
> where dt=20171205
> group by dt
> ;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
