You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Hengyu Dai (JIRA)" <ji...@apache.org> on 2017/12/06 11:38:00 UTC

[jira] [Created] (HIVE-18236) Hive vectorized execution returned wrong result

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)