[ https://issues.apache.org/jira/browse/HIVE-15782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15849002#comment-15849002 ]
Hive QA commented on HIVE-15782: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12850463/HIVE-15782.1.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 8 failed/errored test(s), 11023 tests executed *Failed tests:* {noformat} TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=235) org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_join_with_different_encryption_keys] (batchId=159) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_char_simple] (batchId=147) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_varchar_simple] (batchId=153) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query23] (batchId=223) org.apache.hadoop.hive.ql.io.parquet.TestParquetRecordReaderWrapper.testBuilderComplexTypes (batchId=253) org.apache.hadoop.hive.ql.io.parquet.TestParquetRecordReaderWrapper.testBuilderComplexTypes2 (batchId=253) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3309/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3309/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3309/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase 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: 8 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12850463 - PreCommit-HIVE-Build > query on parquet table returns incorrect result when > hive.optimize.index.filter is set to true > ----------------------------------------------------------------------------------------------- > > Key: HIVE-15782 > URL: https://issues.apache.org/jira/browse/HIVE-15782 > Project: Hive > Issue Type: Bug > Components: File Formats > Affects Versions: 2.2.0 > Reporter: Aihua Xu > Assignee: Aihua Xu > Attachments: HIVE-15782.1.patch > > > When hive.optimize.index.filter is set to true, the parquet table is filtered > using the parquet column index. > {noformat} > set hive.optimize.index.filter=true; > CREATE TABLE t1 ( > name string, > dec decimal(5,0) > ) stored as parquet; > insert into table t1 values('Jim', 3); > insert into table t1 values('Tom', 5); > select * from t1 where (name = 'Jim' or dec = 5); > {noformat} > Only one row {{Jim, 3}} is returned, but both should be returned. -- This message was sent by Atlassian JIRA (v6.3.15#6346)