[
https://issues.apache.org/jira/browse/HIVE-18236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16280349#comment-16280349
]
Matt McCline commented on HIVE-18236:
-------------------------------------
[~hengyu.dai] Can you please add the small data file and DDL to create the
file. Thanks.
> 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)
