[
https://issues.apache.org/jira/browse/HIVE-20804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16663440#comment-16663440
]
Hive QA commented on HIVE-20804:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12945510/HIVE-20804.1.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 138 failed/errored test(s), 15507 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_10] (batchId=46)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[position_alias_test_1]
(batchId=46)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[quotedid_basic]
(batchId=65)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[quotedid_partition]
(batchId=21)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[acid_vectorization_original]
(batchId=179)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[selectDistinctStar]
(batchId=178)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[sysdb]
(batchId=168)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[acid_vectorization_original_tez]
(batchId=109)
org.apache.hadoop.hive.metastore.client.TestListPartitions.getNumPartitionsByFilterBogusCatalog[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.listPartitionNamesBogusCatalog[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.listPartitionNamesPartialValsBogusCatalog[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.listPartitionSpecsByFilterBogusCatalog[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.listPartitionValuesBogusCatalog[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.listPartitionsBogusCatalog[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.listPartitionsByFilterBogusCatalog[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.listPartitionsSpecsBogusCatalog[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.listPartitionsWithPartialValuesBogusCatalog[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.otherCatalog[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testGetNumPartitionsByFilterInvalidFilter[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testGetNumPartitionsByFilterNoDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testGetNumPartitionsByFilterNoDb[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testGetNumPartitionsByFilterNoTable[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testGetNumPartitionsByFilterNoTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testGetNumPartitionsByFilterNullDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testGetNumPartitionsByFilterNullFilter[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testGetNumPartitionsByFilterNullTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testGetNumPartitionsByFilter[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesByValuesMaxPartCountUnlimited[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesByValuesNoDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesByValuesNoDb[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesByValuesNoPartVals[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesByValuesNoTable[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesByValuesNoTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesByValuesNullDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesByValuesNullTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesByValuesNullValues[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesByValuesTooManyVals[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesByValues[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesNoDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesNoDb[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesNoTable[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesNoTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesNullDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNamesNullTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionNames[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsByFilterEmptyFilter[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsByFilterHighMaxParts[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsByFilterInvalidFilter[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsByFilterNoDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsByFilterNoDb[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsByFilterNoTable[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsByFilterNoTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsByFilterNullDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsByFilterNullFilter[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsByFilterNullTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsHighMaxParts[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsNoDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsNoDb[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsNoTable[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsNoTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsNullDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecsNullTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionSpecs[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionValuesEmptySchema[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionValuesNoDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionValuesNoDb[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionValuesNoTable[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionValuesNoTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionValuesNullDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionValuesNullRequest[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionValuesNullSchema[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionValuesNullTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionValues[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsAllHighMaxParts[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsAllNoDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsAllNoDb[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsAllNoParts[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsAllNoTable[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsAllNoTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsAllNullDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsAllNullTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsAll[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilterCaseInsensitive[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilterCaseSensitive[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilterEmptyFilter[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilterHighMaxParts[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilterInvalidFilter[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilterNoDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilterNoDb[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilterNoTable[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilterNoTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilterNullDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilterNullFilter[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilterNullTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByFilter[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByValuesNoDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByValuesNoDb[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByValuesNoTable[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByValuesNoTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByValuesNoVals[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByValuesNullDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByValuesNullTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByValuesNullValues[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByValuesTooManyVals[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsByValues[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsSpecsByFilter[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesHighMaxParts[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesNoDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesNoDb[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesNoPrivilegesSet[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesNoTable[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesNoTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesNoVals[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesNullDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesNullGroup[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesNullTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesNullUser[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesNullValues[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesTooManyValsHighMaxParts[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValuesTooManyVals[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthByValues[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthHighMaxParts[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthNoDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthNoDb[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthNoPrivilegesSet[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthNoTable[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthNoTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthNullDbName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthNullGroup[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthNullTblName[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuthNullUser[Remote]
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestListPartitions.testListPartitionsWithAuth[Remote]
(batchId=221)
org.apache.hive.jdbc.TestJdbcWithMiniLlapArrow.testComplexQuery (batchId=257)
org.apache.hive.jdbc.TestJdbcWithMiniLlapArrow.testDataTypes (batchId=257)
org.apache.hive.jdbc.TestJdbcWithMiniLlapArrow.testEscapedStrings (batchId=257)
org.apache.hive.jdbc.TestJdbcWithMiniLlapArrow.testKillQuery (batchId=257)
org.apache.hive.jdbc.TestJdbcWithMiniLlapArrow.testLlapInputFormatEndToEnd
(batchId=257)
org.apache.hive.jdbc.TestJdbcWithMiniLlapArrow.testNonAsciiStrings (batchId=257)
{noformat}
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/14637/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14637/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14637/
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: 138 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12945510 - PreCommit-HIVE-Build
> Further improvements to group by optimization with constraints
> --------------------------------------------------------------
>
> Key: HIVE-20804
> URL: https://issues.apache.org/jira/browse/HIVE-20804
> Project: Hive
> Issue Type: Improvement
> Components: Query Planning
> Reporter: Vineet Garg
> Assignee: Vineet Garg
> Priority: Major
> Attachments: HIVE-20804.1.patch
>
>
> Continuation of HIVE-17043
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
