You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Xuefu Zhang (JIRA)" <ji...@apache.org> on 2015/09/17 01:32:45 UTC
[jira] [Comment Edited] (HIVE-11839) Vectorization wrong results
with filter of (CAST AS CHAR)
[ https://issues.apache.org/jira/browse/HIVE-11839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14791300#comment-14791300 ]
Xuefu Zhang edited comment on HIVE-11839 at 9/16/15 11:32 PM:
--------------------------------------------------------------
Could we update the fix versions please? Also, affected versions.
was (Author: xuefuz):
Could we update the fix versions please?
> Vectorization wrong results with filter of (CAST AS CHAR)
> ---------------------------------------------------------
>
> Key: HIVE-11839
> URL: https://issues.apache.org/jira/browse/HIVE-11839
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Reporter: Matt McCline
> Assignee: Matt McCline
> Priority: Critical
> Attachments: HIVE-11839.01.patch
>
>
> PROBLEM:
> For query such as
> select count(1) from table where CAST (id as CHAR(4))='1000';
> gives wrong results 0 than expected results.
> STEPS TO REPRODUCE:
> create table s1(id smallint) stored as orc;
> insert into table s1 values (1000),(1001),(1002),(1003),(1000);
> set hive.vectorized.execution.enabled=true;
> select count(1) from s1 where cast(id as char(4))='1000';
> – this gives 0
> set hive.vectorized.execution.enabled=false;
> select count(1) from s1 where cast(id as char(4))='1000';
> – this gives 2
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)