Hengyu Dai created HIVE-18236:
---------------------------------
Summary: 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}
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)
