[ 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