hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11839) Vectorization wrong results with filter of (CAST AS CHAR)
Date Wed, 16 Sep 2015 21:41:45 GMT

    [ https://issues.apache.org/jira/browse/HIVE-11839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14791173#comment-14791173
] 

Hive QA commented on HIVE-11839:
--------------------------------



{color:red}Overall{color}: -1 at least one tests failed

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12756187/HIVE-11839.01.patch

{color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 9447 tests executed
*Failed tests:*
{noformat}
org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation
org.apache.hive.hcatalog.streaming.TestStreaming.testEndpointConnection
org.apache.hive.hcatalog.streaming.TestStreaming.testRemainingTransactions
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_Json
{noformat}

Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5303/testReport
Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5303/console
Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-5303/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 4 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12756187 - PreCommit-HIVE-TRUNK-Build

> 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)

Mime
View raw message