This is an automated email from the ASF dual-hosted git repository.
eldenmoon pushed a commit to branch variant-sparse
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 83cfe3111e780c2eab7a371b1a43c88655ab96f8
Author: eldenmoon <lihan...@selectdb.com>
AuthorDate: Wed Mar 5 15:18:12 2025 +0800
refine p2 cases
---
.../load.out | Bin 28410 -> 28455 bytes
regression-test/data/variant_p2/load.out | Bin 116 -> 116 bytes
.../variant_p2/sql/authorsWithTheMostPushes.out | Bin 1094 -> 1094 bytes
.../data/variant_p2/sql/countingStar1.out | Bin 125 -> 125 bytes
.../data/variant_p2/sql/countingStar2.out | Bin 133 -> 133 bytes
.../data/variant_p2/sql/countingStar3.out | Bin 122 -> 122 bytes
.../sql/distributionOfRepositoriesByStarCount.out | Bin 177 -> 185 bytes
...heListOfTopRepositoriesChangedOverTheYears1.out | Bin 1423 -> 1421 bytes
...heListOfTopRepositoriesChangedOverTheYears2.out | Bin 1423 -> 1421 bytes
...heListOfTopRepositoriesChangedOverTheYears3.out | Bin 1423 -> 1421 bytes
...heListOfTopRepositoriesChangedOverTheYears4.out | Bin 1423 -> 1421 bytes
...heListOfTopRepositoriesChangedOverTheYears5.out | Bin 1423 -> 1421 bytes
...heListOfTopRepositoriesChangedOverTheYears6.out | Bin 1423 -> 1421 bytes
.../howHasTheTotalNumberOfStarsChangedOverTime.out | Bin 159 -> 159 bytes
.../variant_p2/sql/issuesWithTheMostComments1.out | Bin 138 -> 138 bytes
.../variant_p2/sql/issuesWithTheMostComments2.out | Bin 1263 -> 1263 bytes
.../variant_p2/sql/issuesWithTheMostComments3.out | Bin 1601 -> 1601 bytes
.../variant_p2/sql/issuesWithTheMostComments4.out | Bin 1468 -> 1474 bytes
.../variant_p2/sql/issuesWithTheMostComments5.out | Bin 1440 -> 1440 bytes
.../variant_p2/sql/issuesWithTheMostComments6.out | Bin 1630 -> 1634 bytes
.../variant_p2/sql/issuesWithTheMostComments7.out | Bin 1446 -> 1451 bytes
.../data/variant_p2/sql/mostForkedRepositories.out | Bin 1427 -> 1420 bytes
.../sql/organizationsByTheNumberOfRepositories.out | Bin 743 -> 743 bytes
.../sql/organizationsByTheNumberOfStars.out | Bin 799 -> 799 bytes
.../sql/organizationsByTheSizeOfCommunity.out | Bin 302 -> 302 bytes
.../sql/proportionsBetweenStarsAndForks1.out | Bin 1751 -> 1745 bytes
.../sql/proportionsBetweenStarsAndForks2.out | Bin 1601 -> 1604 bytes
.../sql/proportionsBetweenStarsAndForks3.out | Bin 1513 -> 1514 bytes
.../sql/proportionsBetweenStarsAndForks4.out | Bin 157 -> 157 bytes
.../sql/proportionsBetweenStarsAndForks5.out | Bin 156 -> 156 bytes
...epositoriesWithClickhouse_related_comments2.out | Bin 1392 -> 1393 bytes
.../repositoriesWithTheMaximumAmountOfIssues1.out | Bin 1490 -> 1491 bytes
.../repositoriesWithTheMaximumAmountOfIssues2.out | Bin 1628 -> 1629 bytes
.../repositoriesWithTheMaximumAmountOfIssues3.out | Bin 1626 -> 1627 bytes
.../repositoriesWithTheMaximumAmountOfIssues4.out | Bin 1626 -> 1627 bytes
...sitoriesWithTheMaximumAmountOfPullRequests2.out | Bin 1547 -> 1533 bytes
...esWithTheMaximumNumberOfAcceptedInvitations.out | Bin 1650 -> 1639 bytes
...sitoriesWithTheMostPeopleWhoHavePushAccess1.out | Bin 1389 -> 1395 bytes
...sitoriesWithTheMostPeopleWhoHavePushAccess2.out | Bin 1396 -> 1396 bytes
...sitoriesWithTheMostPeopleWhoHavePushAccess3.out | Bin 1405 -> 1396 bytes
.../repositoriesWithTheMostStarsOverOneDay1.out | Bin 1412 -> 1410 bytes
.../repositoriesWithTheMostStarsOverOneDay2.out | Bin 1412 -> 1410 bytes
.../repositoriesWithTheMostStarsOverOneDay3.out | Bin 1412 -> 1410 bytes
.../repositoriesWithTheWorstStagnation_order.out | Bin 1558 -> 1558 bytes
.../variant_p2/sql/repositoryAffinityList2.out | Bin 1693 -> 1732 bytes
regression-test/data/variant_p2/sql/sql02.out | Bin 118 -> 118 bytes
regression-test/data/variant_p2/sql/sql03.out | Bin 118 -> 118 bytes
regression-test/data/variant_p2/sql/sql06.out | Bin 117 -> 117 bytes
.../variant_p2/sql/theLongestRepositoryNames2.out | Bin 563 -> 563 bytes
.../variant_p2/sql/theMostToughCodeReviews.out | Bin 2386 -> 2386 bytes
.../sql/theTotalNumberOfRepositoriesOnGithub.out | Bin 148 -> 148 bytes
.../sql/theTotalNumberOfUsersOnGithub1.out | Bin 142 -> 142 bytes
.../sql/theTotalNumberOfUsersOnGithub2.out | Bin 141 -> 141 bytes
.../sql/theTotalNumberOfUsersOnGithub3.out | Bin 141 -> 141 bytes
.../sql/theTotalNumberOfUsersOnGithub4.out | Bin 141 -> 141 bytes
.../data/variant_p2/sql/topRepositoriesByStars.out | Bin 1395 -> 1393 bytes
.../sql/whatIsTheBestDayOfTheWeekToCatchAStar.out | Bin 204 -> 204 bytes
.../sql/whoAreAllThosePeopleGivingStars1.out | Bin 839 -> 841 bytes
.../load.groovy | 5 +++--
regression-test/suites/variant_p2/load.groovy | 25 ++++++++++++++-------
60 files changed, 20 insertions(+), 10 deletions(-)
diff --git
a/regression-test/data/variant_github_events_nonConcurrent_p2/load.out
b/regression-test/data/variant_github_events_nonConcurrent_p2/load.out
index d3ea4ea4159..0e35a32adf7 100644
Binary files
a/regression-test/data/variant_github_events_nonConcurrent_p2/load.out and
b/regression-test/data/variant_github_events_nonConcurrent_p2/load.out differ
diff --git a/regression-test/data/variant_p2/load.out
b/regression-test/data/variant_p2/load.out
index f3dbb78d8dd..86df6f121ec 100644
Binary files a/regression-test/data/variant_p2/load.out and
b/regression-test/data/variant_p2/load.out differ
diff --git a/regression-test/data/variant_p2/sql/authorsWithTheMostPushes.out
b/regression-test/data/variant_p2/sql/authorsWithTheMostPushes.out
index 2b2c2c39f58..569a84d202f 100644
Binary files a/regression-test/data/variant_p2/sql/authorsWithTheMostPushes.out
and b/regression-test/data/variant_p2/sql/authorsWithTheMostPushes.out differ
diff --git a/regression-test/data/variant_p2/sql/countingStar1.out
b/regression-test/data/variant_p2/sql/countingStar1.out
index d91ef32da45..f60d8e64831 100644
Binary files a/regression-test/data/variant_p2/sql/countingStar1.out and
b/regression-test/data/variant_p2/sql/countingStar1.out differ
diff --git a/regression-test/data/variant_p2/sql/countingStar2.out
b/regression-test/data/variant_p2/sql/countingStar2.out
index 0048ffe86bc..8c140a93000 100644
Binary files a/regression-test/data/variant_p2/sql/countingStar2.out and
b/regression-test/data/variant_p2/sql/countingStar2.out differ
diff --git a/regression-test/data/variant_p2/sql/countingStar3.out
b/regression-test/data/variant_p2/sql/countingStar3.out
index b83ab1c4645..d447b2edd8a 100644
Binary files a/regression-test/data/variant_p2/sql/countingStar3.out and
b/regression-test/data/variant_p2/sql/countingStar3.out differ
diff --git
a/regression-test/data/variant_p2/sql/distributionOfRepositoriesByStarCount.out
b/regression-test/data/variant_p2/sql/distributionOfRepositoriesByStarCount.out
index 8dfc672cdca..6a067f9a3a4 100644
Binary files
a/regression-test/data/variant_p2/sql/distributionOfRepositoriesByStarCount.out
and
b/regression-test/data/variant_p2/sql/distributionOfRepositoriesByStarCount.out
differ
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
index 62b9d1fcdcc..b6b264b11ff 100644
Binary files
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
and
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
differ
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
index e7668cb8b0b..1f82eb03fa8 100644
Binary files
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
and
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
differ
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
index 997a79a8af1..8b3156f98fa 100644
Binary files
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
and
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
differ
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
index 404522cce02..496e681f6d6 100644
Binary files
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
and
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
differ
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
index 0bee030e8d2..13116d3cc76 100644
Binary files
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
and
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
differ
diff --git
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
index a6a75ac7a81..16eb965b642 100644
Binary files
a/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
and
b/regression-test/data/variant_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
differ
diff --git
a/regression-test/data/variant_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
b/regression-test/data/variant_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
index c15936f42ff..e089d1fb789 100644
Binary files
a/regression-test/data/variant_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
and
b/regression-test/data/variant_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
differ
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments1.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments1.out
index c39fbabafed..65a9891bf19 100644
Binary files
a/regression-test/data/variant_p2/sql/issuesWithTheMostComments1.out and
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments1.out differ
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments2.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments2.out
index ecc05fa4161..fe95c99e167 100644
Binary files
a/regression-test/data/variant_p2/sql/issuesWithTheMostComments2.out and
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments2.out differ
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments3.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments3.out
index 04bc174d9df..a9b5b17ca0f 100644
Binary files
a/regression-test/data/variant_p2/sql/issuesWithTheMostComments3.out and
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments3.out differ
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments4.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments4.out
index 83fa3ec22dd..c4406b23099 100644
Binary files
a/regression-test/data/variant_p2/sql/issuesWithTheMostComments4.out and
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments4.out differ
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments5.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments5.out
index 072559a6739..9b00c81679c 100644
Binary files
a/regression-test/data/variant_p2/sql/issuesWithTheMostComments5.out and
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments5.out differ
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments6.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments6.out
index 529c7958e83..c354bb906d5 100644
Binary files
a/regression-test/data/variant_p2/sql/issuesWithTheMostComments6.out and
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments6.out differ
diff --git a/regression-test/data/variant_p2/sql/issuesWithTheMostComments7.out
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments7.out
index e5ab2c8e53f..747ff0ff0f5 100644
Binary files
a/regression-test/data/variant_p2/sql/issuesWithTheMostComments7.out and
b/regression-test/data/variant_p2/sql/issuesWithTheMostComments7.out differ
diff --git a/regression-test/data/variant_p2/sql/mostForkedRepositories.out
b/regression-test/data/variant_p2/sql/mostForkedRepositories.out
index c9189f8c067..be96dadb402 100644
Binary files a/regression-test/data/variant_p2/sql/mostForkedRepositories.out
and b/regression-test/data/variant_p2/sql/mostForkedRepositories.out differ
diff --git
a/regression-test/data/variant_p2/sql/organizationsByTheNumberOfRepositories.out
b/regression-test/data/variant_p2/sql/organizationsByTheNumberOfRepositories.out
index dc65be783d9..41e4d206ec9 100644
Binary files
a/regression-test/data/variant_p2/sql/organizationsByTheNumberOfRepositories.out
and
b/regression-test/data/variant_p2/sql/organizationsByTheNumberOfRepositories.out
differ
diff --git
a/regression-test/data/variant_p2/sql/organizationsByTheNumberOfStars.out
b/regression-test/data/variant_p2/sql/organizationsByTheNumberOfStars.out
index 1db47c36e72..cf8094bb77c 100644
Binary files
a/regression-test/data/variant_p2/sql/organizationsByTheNumberOfStars.out and
b/regression-test/data/variant_p2/sql/organizationsByTheNumberOfStars.out differ
diff --git
a/regression-test/data/variant_p2/sql/organizationsByTheSizeOfCommunity.out
b/regression-test/data/variant_p2/sql/organizationsByTheSizeOfCommunity.out
index a364ae96e76..667b28838bc 100644
Binary files
a/regression-test/data/variant_p2/sql/organizationsByTheSizeOfCommunity.out and
b/regression-test/data/variant_p2/sql/organizationsByTheSizeOfCommunity.out
differ
diff --git
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks1.out
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks1.out
index e30b60ddb63..026d4c8e797 100644
Binary files
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks1.out and
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks1.out
differ
diff --git
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks2.out
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks2.out
index 7803bd83cd2..8997ec079fe 100644
Binary files
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks2.out and
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks2.out
differ
diff --git
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks3.out
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks3.out
index 9eed6501830..15f702a471d 100644
Binary files
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks3.out and
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks3.out
differ
diff --git
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks4.out
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks4.out
index 78e58cbdf99..78eef66a208 100644
Binary files
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks4.out and
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks4.out
differ
diff --git
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks5.out
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks5.out
index 98d6d6a6fa7..55770e05612 100644
Binary files
a/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks5.out and
b/regression-test/data/variant_p2/sql/proportionsBetweenStarsAndForks5.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithClickhouse_related_comments2.out
b/regression-test/data/variant_p2/sql/repositoriesWithClickhouse_related_comments2.out
index f8f891f023d..21d9cf83d44 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithClickhouse_related_comments2.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithClickhouse_related_comments2.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
index 30b6c01feb5..90778d85dc0 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
index 4857cc1206e..4f8281d36dc 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
index 4bd081661ad..8ee41ec721b 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
index e09031d428f..623c4971ecf 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
index b2b26bdea51..82e5a50926e 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
index 107fe7ec137..37e8e052dec 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
index 2ba973dfe0f..aebd7fe84f1 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.out
index ec92b757114..55b1335c1e7 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.out
index a1baa1b42ea..9dd30f4455e 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay1.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay1.out
index 08b56dec73b..ca26ff418af 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay1.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay1.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay2.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay2.out
index 9cd8ef1b807..a4be8b85f18 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay2.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay2.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay3.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay3.out
index dca7d6be0cc..c97893738c6 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay3.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheMostStarsOverOneDay3.out
differ
diff --git
a/regression-test/data/variant_p2/sql/repositoriesWithTheWorstStagnation_order.out
b/regression-test/data/variant_p2/sql/repositoriesWithTheWorstStagnation_order.out
index d30506eefd4..9dce31a0abd 100644
Binary files
a/regression-test/data/variant_p2/sql/repositoriesWithTheWorstStagnation_order.out
and
b/regression-test/data/variant_p2/sql/repositoriesWithTheWorstStagnation_order.out
differ
diff --git a/regression-test/data/variant_p2/sql/repositoryAffinityList2.out
b/regression-test/data/variant_p2/sql/repositoryAffinityList2.out
index ac0f99a2300..8087663833e 100644
Binary files a/regression-test/data/variant_p2/sql/repositoryAffinityList2.out
and b/regression-test/data/variant_p2/sql/repositoryAffinityList2.out differ
diff --git a/regression-test/data/variant_p2/sql/sql02.out
b/regression-test/data/variant_p2/sql/sql02.out
index 828dc276fa3..8cbf5e8227a 100644
Binary files a/regression-test/data/variant_p2/sql/sql02.out and
b/regression-test/data/variant_p2/sql/sql02.out differ
diff --git a/regression-test/data/variant_p2/sql/sql03.out
b/regression-test/data/variant_p2/sql/sql03.out
index 4aca237047e..d033b827579 100644
Binary files a/regression-test/data/variant_p2/sql/sql03.out and
b/regression-test/data/variant_p2/sql/sql03.out differ
diff --git a/regression-test/data/variant_p2/sql/sql06.out
b/regression-test/data/variant_p2/sql/sql06.out
index 512dd4030dc..247a88c06ee 100644
Binary files a/regression-test/data/variant_p2/sql/sql06.out and
b/regression-test/data/variant_p2/sql/sql06.out differ
diff --git a/regression-test/data/variant_p2/sql/theLongestRepositoryNames2.out
b/regression-test/data/variant_p2/sql/theLongestRepositoryNames2.out
index 9ee8d2bfdf5..ae941f8e12f 100644
Binary files
a/regression-test/data/variant_p2/sql/theLongestRepositoryNames2.out and
b/regression-test/data/variant_p2/sql/theLongestRepositoryNames2.out differ
diff --git a/regression-test/data/variant_p2/sql/theMostToughCodeReviews.out
b/regression-test/data/variant_p2/sql/theMostToughCodeReviews.out
index de6c205b545..e4111f443f2 100644
Binary files a/regression-test/data/variant_p2/sql/theMostToughCodeReviews.out
and b/regression-test/data/variant_p2/sql/theMostToughCodeReviews.out differ
diff --git
a/regression-test/data/variant_p2/sql/theTotalNumberOfRepositoriesOnGithub.out
b/regression-test/data/variant_p2/sql/theTotalNumberOfRepositoriesOnGithub.out
index cbbafb3d903..40fcc46bc87 100644
Binary files
a/regression-test/data/variant_p2/sql/theTotalNumberOfRepositoriesOnGithub.out
and
b/regression-test/data/variant_p2/sql/theTotalNumberOfRepositoriesOnGithub.out
differ
diff --git
a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub1.out
b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub1.out
index 1fccf4779dd..fe0d72e9622 100644
Binary files
a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub1.out and
b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub1.out differ
diff --git
a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub2.out
b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub2.out
index 8f0e3865a09..717e8e95154 100644
Binary files
a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub2.out and
b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub2.out differ
diff --git
a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub3.out
b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub3.out
index 6ce5676198a..093f92f9766 100644
Binary files
a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub3.out and
b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub3.out differ
diff --git
a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub4.out
b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub4.out
index 97cc8344cd0..3b00e391e11 100644
Binary files
a/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub4.out and
b/regression-test/data/variant_p2/sql/theTotalNumberOfUsersOnGithub4.out differ
diff --git a/regression-test/data/variant_p2/sql/topRepositoriesByStars.out
b/regression-test/data/variant_p2/sql/topRepositoriesByStars.out
index 150e1f5bec6..1221a8714c0 100644
Binary files a/regression-test/data/variant_p2/sql/topRepositoriesByStars.out
and b/regression-test/data/variant_p2/sql/topRepositoriesByStars.out differ
diff --git
a/regression-test/data/variant_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
b/regression-test/data/variant_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
index d78de9a3877..03d42c917e0 100644
Binary files
a/regression-test/data/variant_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
and
b/regression-test/data/variant_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
differ
diff --git
a/regression-test/data/variant_p2/sql/whoAreAllThosePeopleGivingStars1.out
b/regression-test/data/variant_p2/sql/whoAreAllThosePeopleGivingStars1.out
index 15e27f904c0..e34c40c6ca6 100644
Binary files
a/regression-test/data/variant_p2/sql/whoAreAllThosePeopleGivingStars1.out and
b/regression-test/data/variant_p2/sql/whoAreAllThosePeopleGivingStars1.out
differ
diff --git
a/regression-test/suites/variant_github_events_nonConcurrent_p2/load.groovy
b/regression-test/suites/variant_github_events_nonConcurrent_p2/load.groovy
index 59b76c749a8..3641264953c 100644
--- a/regression-test/suites/variant_github_events_nonConcurrent_p2/load.groovy
+++ b/regression-test/suites/variant_github_events_nonConcurrent_p2/load.groovy
@@ -150,8 +150,8 @@ suite("regression_test_variant_github_events_p2",
"nonConcurrent,p2"){
def table_name = "github_events"
sql """DROP TABLE IF EXISTS ${table_name}"""
table_name = "github_events"
- int rand_subcolumns_count = Math.floor(Math.random() * (611 - 511 + 1)) +
511
- // int rand_subcolumns_count = 0;
+ // int rand_subcolumns_count = Math.floor(Math.random() * (611 - 511 + 1))
+ 511
+ int rand_subcolumns_count = 10;
sql """
CREATE TABLE IF NOT EXISTS ${table_name} (
k bigint,
@@ -199,6 +199,7 @@ suite("regression_test_variant_github_events_p2",
"nonConcurrent,p2"){
qt_sql """select cast(v["payload"]["pull_request"]["additions"] as int)
from github_events where cast(v["repo"]["name"] as string) =
'xpressengine/xe-core' order by 1;"""
qt_sql """select * from github_events where cast(v["repo"]["name"] as
string) = 'xpressengine/xe-core' order by 1 limit 10"""
sql """select * from github_events order by k limit 10"""
+ sql "DROP TABLE IF EXISTS github_events2"
sql """
CREATE TABLE IF NOT EXISTS github_events2 (
k bigint,
diff --git a/regression-test/suites/variant_p2/load.groovy
b/regression-test/suites/variant_p2/load.groovy
index b193b63e927..0b9b6784c8d 100644
--- a/regression-test/suites/variant_p2/load.groovy
+++ b/regression-test/suites/variant_p2/load.groovy
@@ -18,7 +18,7 @@ import java.util.concurrent.Executors
import java.util.concurrent.TimeUnit
suite("load_p2", "variant_type,p2"){
-
+ boolean use_stream_load = true
def load_json_data = {table_name, file_name ->
// load the json data
streamLoad {
@@ -65,7 +65,7 @@ suite("load_p2", "variant_type,p2"){
)
DUPLICATE KEY(`id`)
DISTRIBUTED BY HASH(id) BUCKETS ${buckets}
- properties("replication_num" = "1", "disable_auto_compaction" =
"false", "variant_max_subcolumns_count" = "500");
+ properties("replication_num" = "1", "disable_auto_compaction" =
"false", "variant_max_subcolumns_count" = "9");
"""
}
@@ -79,7 +79,7 @@ suite("load_p2", "variant_type,p2"){
logger.info("update config: code=" + code + ", out=" + out + ",
err=" + err)
}
}
- set_be_config.call("string_type_length_soft_limit_bytes", "104857600")
+ set_be_config.call("string_type_length_soft_limit_bytes", "10485760")
// Configuration for the number of threads
@@ -154,11 +154,20 @@ suite("load_p2", "variant_type,p2"){
log.info("current hour: ${hour}")
def fileName = year + "-" + month + "-" + day + "-" + hour
+ ".json"
log.info("cuurent fileName: ${fileName}")
- // Submitting tasks to the executor service
- executorService.submit({
- log.info("Loading file: ${fileName}")
- s3load_paral_wait.call(table_name, "JSON",
"regression/github_events_dataset/${fileName}", 3)
- } as Runnable)
+ if (use_stream_load) {
+ def fileUrl = """${getS3Url() +
'/regression/github_events_dataset/' + fileName}"""
+ // Submitting tasks to the executor service
+ executorService.submit({
+ log.info("Loading file: ${fileName}")
+ load_json_data.call(table_name, fileUrl)
+ } as Runnable)
+ } else {
+ // Submitting tasks to the executor service
+ executorService.submit({
+ log.info("Loading file: ${fileName}")
+ s3load_paral_wait.call(table_name, "JSON",
"regression/github_events_dataset/${fileName}", 3)
+ } as Runnable)
+ }
}
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
