[
https://issues.apache.org/jira/browse/HIVE-20976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16701459#comment-16701459
]
Hive QA commented on HIVE-20976:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12949775/HIVE-20976.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 78 failed/errored test(s), 15636 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testAlterPartition
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testAlterTable
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testAlterTableCascade
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testAlterViewParititon
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testColumnStatistics
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testComplexTable
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testComplexTypeApi
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testConcurrentMetastores
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testCreateAndGetTableWithDriver
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testCreateTableSettingId
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testDBLocationChange
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testDBOwner
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testDBOwnerChange
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testDatabase
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testDatabaseLocation
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testDatabaseLocationWithPermissionProblems
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testDropDatabaseCascadeMVMultiDB
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testDropTable
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testFilterLastPartition
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testFilterSinglePartition
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testFunctionWithResources
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testGetConfigValue
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testGetMetastoreUuid
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testGetPartitionsWithSpec
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testGetSchemaWithNoClassDefFoundError
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testGetTableObjects
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testGetUUIDInParallel
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testJDOPersistanceManagerCleanup
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testListPartitionNames
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testListPartitions
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testListPartitionsWihtLimitEnabled
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testNameMethods
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testPartition
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testPartitionFilter
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testRenamePartition
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testRetriableClientWithConnLifetime
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testSimpleFunction
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testSimpleTable
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testSimpleTypeApi
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testStatsFastTrivial
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testSynchronized
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testTableDatabase
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testTableFilter
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testUpdatePartitionStat_doesNotUpdateStats
(batchId=230)
org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStoreZK.testValidateTableCols
(batchId=230)
org.apache.hadoop.hive.metastore.client.TestDatabases.createDatabaseInNonExistentCatalog[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.databasesInCatalogs[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.dropDatabaseInNonExistentCatalog[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.fetchDatabaseInNonExistentCatalog[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testAlterDatabaseCaseInsensitive[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testAlterDatabaseNoSuchDatabase[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testAlterDatabaseNotNullableFields[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testAlterDatabase[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testCreateDatabaseAlreadyExists[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testCreateDatabaseDefaultValues[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testCreateDatabaseEmptyName[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testCreateDatabaseInvalidName[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testCreateDatabaseNullName[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testCreateGetDeleteDatabase[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testDefaultDatabaseData[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testDropDatabaseCaseInsensitive[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testDropDatabaseDefaultDatabase[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testDropDatabaseDeleteData[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testDropDatabaseIgnoreUnknownFalse[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testDropDatabaseIgnoreUnknownTrue[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testDropDatabaseNoSuchDatabase[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testDropDatabaseNullName[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testDropDatabaseWithFunctionCascade[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testDropDatabaseWithFunction[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testDropDatabaseWithTableCascade[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testDropDatabaseWithTable[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testGetAllDatabases[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testGetDatabaseCaseInsensitive[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testGetDatabaseNoSuchDatabase[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testGetDatabaseNullName[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testGetDatabasesCaseInsensitive[Remote]
(batchId=224)
org.apache.hadoop.hive.metastore.client.TestDatabases.testGetDatabases[Remote]
(batchId=224)
org.apache.hive.jdbc.TestJdbcGenericUDTFGetSplits.testGenericUDTFOrderBySplitCount1
(batchId=257)
{noformat}
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/15089/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15089/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15089/
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: 78 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12949775 - PreCommit-HIVE-Build
> JDBC queries containing joins gives wrong results
> -------------------------------------------------
>
> Key: HIVE-20976
> URL: https://issues.apache.org/jira/browse/HIVE-20976
> Project: Hive
> Issue Type: Bug
> Components: JDBC, StorageHandler
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Priority: Major
> Attachments: HIVE-20976.patch
>
>
> JDBC queries that have joins against self table gives wrong results.
> e.g.
> {code}
> SELECT
> username AS `username`,
> SUM(double1) AS `sum_double1`
> FROM
> jdbc_table_with_nulls `tbl1`
> JOIN (
> SELECT
> username AS `username`,
> SUM(double1) AS `sum_double2`
> FROM jdbc_table_with_nulls
> GROUP BY `username`
> ORDER BY `sum_double2`
> DESC LIMIT 10
> )
> `tbl2`
> ON (`tbl1`.`username` = `tbl2`.`username`)
> GROUP BY `tbl1`.`username`;
> {code}
> Similar to HIVE-19762.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
