You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Jitendra Nath Pandey (JIRA)" <ji...@apache.org> on 2013/06/07 23:58:20 UTC

[jira] [Commented] (HIVE-4678) second clause of AND filter not applied for vectorized execution

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

Jitendra Nath Pandey commented on HIVE-4678:
--------------------------------------------

This issue is same as HIVE-4680, will fix it in the same jira.
                
> second clause of AND filter not applied for vectorized execution
> ----------------------------------------------------------------
>
>                 Key: HIVE-4678
>                 URL: https://issues.apache.org/jira/browse/HIVE-4678
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Query Processor
>    Affects Versions: vectorization-branch
>            Reporter: Eric Hanson
>            Assignee: Jitendra Nath Pandey
>
> Query
> select ddate, dnumbertables23008 from factsqlengineam_vec_orc where ddate = "2013-01-08 00:00:00" and dnumbertables23008 = 1052436;
> returns rows where dnumbertables23008 != 1052436.
> Actual results:
> 636087 rows 
> Sample:
> ...
> 2013-01-08 00:00:00     0
> 2013-01-08 00:00:00     0
> 2013-01-08 00:00:00     108
> 2013-01-08 00:00:00     0
> 2013-01-08 00:00:00     0
> 2013-01-08 00:00:00     1625
> 2013-01-08 00:00:00     210
> 2013-01-08 00:00:00     0
> 2013-01-08 00:00:00     209
> 2013-01-08 00:00:00     0
> ...
> Expected results:
> Either no rows returned, or all rows have 1052436 in second column.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira