[
https://issues.apache.org/jira/browse/HIVE-18236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16280062#comment-16280062
]
Hengyu Dai commented on HIVE-18236:
-----------------------------------
[~mmccline] Could you please check this issue.
> 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)
