[ https://issues.apache.org/jira/browse/HIVE-19481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16521774#comment-16521774 ]
Hive QA commented on HIVE-19481: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12928908/HIVE-19481.2.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 14 failed/errored test(s), 14604 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[smb_mapjoin_11] (batchId=258) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[archive_excludeHadoop20] (batchId=68) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_5] (batchId=30) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample10_mm] (batchId=58) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample6] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample7] (batchId=69) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample9] (batchId=44) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[smb_mapjoin_11] (batchId=2) org.apache.hadoop.hive.cli.TestMiniDruidKafkaCliDriver.testCliDriver[druidkafkamini_basic] (batchId=258) org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[infer_bucket_sort_bucketed_table] (batchId=187) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[sample2] (batchId=110) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[sample4] (batchId=114) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[sample6] (batchId=137) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[sample7] (batchId=137) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/12066/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/12066/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-12066/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 14 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12928908 - PreCommit-HIVE-Build > sample10.q returns wrong results > --------------------------------- > > Key: HIVE-19481 > URL: https://issues.apache.org/jira/browse/HIVE-19481 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 3.0.0 > Reporter: Steve Yeom > Assignee: Deepak Jaiswal > Priority: Major > Fix For: 3.1.0, 4.0.0 > > Attachments: HIVE-19481.1.patch, HIVE-19481.2.patch > > > Ran "mvn test -Dtest=TestMiniLlapLocalCliDriver -Dqfile=sample10.q " after > changing the table to be > insert-only transactional. > The following queries returns couple of rows whereis no row results returns > for non-ACID table. > query: select ds, count(1) from srcpartbucket tablesample (bucket 2 out of 4 > on key) where ds is not null group by ds ORDER BY ds ASC > 2008-04-08 14 > 2008-04-09 14 > .. > query: select ds, count(1) from srcpartbucket tablesample (bucket 1 out of 2 > on key) where ds is not null group by ds ORDER BY ds ASC > 2008-04-08 4 > 2008-04-09 4 -- This message was sent by Atlassian JIRA (v7.6.3#76005)