[ https://issues.apache.org/jira/browse/HIVE-15919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15870995#comment-15870995 ]
Hive QA commented on HIVE-15919: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12853154/HIVE-15919.3.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), 10245 tests executed *Failed tests:* {noformat} TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=235) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_rp_auto_join1] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join31] (batchId=81) org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_join_with_different_encryption_keys] (batchId=159) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[multiMapJoin2] (batchId=152) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query23] (batchId=223) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join31] (batchId=133) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3611/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3611/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3611/ 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: 12853154 - PreCommit-HIVE-Build > Row count mismatch for count * query > ------------------------------------ > > Key: HIVE-15919 > URL: https://issues.apache.org/jira/browse/HIVE-15919 > Project: Hive > Issue Type: Bug > Components: HiveServer2 > Reporter: Aswathy Chellammal Sreekumar > Assignee: Jason Dere > Attachments: HIVE-15919.1.patch, HIVE-15919.2.patch, > HIVE-15919.3.patch, table_14.q, table_6.q > > > The following query is returning different output when run against hive and > postgres. > Query: > SELECT COUNT (*) > FROM > (SELECT LAG(COALESCE(t2.int_col_14, t1.int_col_80),22) OVER (ORDER BY > t1.tinyint_col_52 DESC) AS int_col > FROM table_6 t1 > INNER JOIN table_14 t2 ON ((t2.decimal0101_col_55) = (t1.decimal0101_col_9))) > AS FOO; > From hive: 0 > From postgres: 66903279 > Attaching ddl files for the tables. -- This message was sent by Atlassian JIRA (v6.3.15#6346)