Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
2.1.1
-
None
-
None
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
-- 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 ;