This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.0 by this push:
new 4b6aa72772e branch-3.0: [chore](regression-test) remove
`variant_ratio_of_defaults_as_sparse_column` in test cases #52413 (#52580)
4b6aa72772e is described below
commit 4b6aa72772eba0de341e9c5996cf93bd8f31c5f5
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Jul 2 10:36:13 2025 +0800
branch-3.0: [chore](regression-test) remove
`variant_ratio_of_defaults_as_sparse_column` in test cases #52413 (#52580)
Cherry-picked from #52413
Co-authored-by: lihangyu <[email protected]>
---
.../load.out | Bin
.../sql/affinityByIssuesAndPRs1.out | Bin
.../sql/affinityByIssuesAndPRs2.out | Bin
.../sql/authorsWithTheMostPushes.out | Bin
.../sql/countingStar1.out | Bin
.../sql/countingStar2.out | Bin
.../sql/countingStar3.out | Bin
.../sql/distributionOfRepositoriesByStarCount.out | Bin
.../sql/githubRoulette.out | Bin
...heListOfTopRepositoriesChangedOverTheYears1.out | Bin
...heListOfTopRepositoriesChangedOverTheYears2.out | Bin
...heListOfTopRepositoriesChangedOverTheYears3.out | Bin
...heListOfTopRepositoriesChangedOverTheYears4.out | Bin
...heListOfTopRepositoriesChangedOverTheYears5.out | Bin
...heListOfTopRepositoriesChangedOverTheYears6.out | Bin
.../howHasTheTotalNumberOfStarsChangedOverTime.out | Bin
.../sql/issuesWithTheMostComments1.out | Bin
.../sql/issuesWithTheMostComments2.out | Bin
.../sql/issuesWithTheMostComments3.out | Bin
.../sql/issuesWithTheMostComments4.out | Bin
.../sql/issuesWithTheMostComments5.out | Bin
.../sql/issuesWithTheMostComments6.out | Bin
.../sql/issuesWithTheMostComments7.out | Bin
.../sql/mostForkedRepositories.out | Bin
.../sql/mostPopularCommentsOnGithub.out | Bin
.../sql/organizationsByTheNumberOfRepositories.out | Bin
.../sql/organizationsByTheNumberOfStars.out | Bin
.../sql/proportionsBetweenStarsAndForks1.out | Bin
.../sql/proportionsBetweenStarsAndForks2.out | Bin
.../sql/proportionsBetweenStarsAndForks3.out | Bin
.../sql/proportionsBetweenStarsAndForks4.out | Bin
.../sql/proportionsBetweenStarsAndForks5.out | Bin
.../sql/repositoriesByAmountOfModifiedCode.out | Bin
.../sql/repositoriesByTheNumberOfPushes.out | Bin
...epositoriesWithClickhouse_related_comments1.out | Bin
...epositoriesWithClickhouse_related_comments2.out | Bin
.../repositoriesWithDoris_related_comments1.out | Bin
.../repositoriesWithDoris_related_comments2.out | Bin
.../sql/repositoriesWithTheHighestGrowthYoY.out | Bin
.../repositoriesWithTheMaximumAmountOfIssues1.out | Bin
.../repositoriesWithTheMaximumAmountOfIssues2.out | Bin
.../repositoriesWithTheMaximumAmountOfIssues3.out | Bin
.../repositoriesWithTheMaximumAmountOfIssues4.out | Bin
...sitoriesWithTheMaximumAmountOfPullRequests1.out | Bin
...sitoriesWithTheMaximumAmountOfPullRequests2.out | Bin
...esWithTheMaximumNumberOfAcceptedInvitations.out | Bin
...sitoriesWithTheMostPeopleWhoHavePushAccess1.out | Bin
.../repositoriesWithTheMostStarsOverOneDay1.out | Bin
...repositoriesWithTheMostSteadyGrowthOverTime.out | Bin
.../repositoriesWithTheWorstStagnation_order.out | Bin
.../sql/repositoryAffinityList1.out | Bin
.../sql/repositoryAffinityList2.out | Bin
.../sql/starsFromHeavyGithubUsers1.out | Bin
.../sql/starsFromHeavyGithubUsers2.out | Bin
.../sql/test_distinct_streaming_agg.out | Bin
.../sql/theLongestRepositoryNames1.out | Bin
.../sql/theLongestRepositoryNames2.out | Bin
.../sql/theMostToughCodeReviews.out | Bin
.../sql/theTotalNumberOfRepositoriesOnGithub.out | Bin
.../sql/theTotalNumberOfUsersOnGithub1.out | Bin
.../sql/theTotalNumberOfUsersOnGithub2.out | Bin
.../sql/theTotalNumberOfUsersOnGithub3.out | Bin
.../sql/theTotalNumberOfUsersOnGithub4.out | Bin
.../sql/topRepositoriesByStars.out | Bin
.../sql/whatIsTheBestDayOfTheWeekToCatchAStar.out | Bin
.../sql/whoAreAllThosePeopleGivingStars1.out | Bin
.../sql/whoAreAllThosePeopleGivingStars2.out | Bin
.../sql/whoAreAllThosePeopleGivingStars3.out | Bin
regression-test/data/variant_p0/desc.out | Bin 5397 -> 5887 bytes
.../compaction/test_compaction_extract_root.out | Bin 268 -> 291 bytes
...sted_index_file_http_action_with_variant.groovy | 1 -
.../load.groovy | 12 +-----
.../load.groovy | 1 -
.../suites/variant_log_data_p2/load.groovy | 4 --
regression-test/suites/variant_p0/desc.groovy | 6 +--
.../suites/variant_p0/with_index/load.groovy | 16 +------
.../with_index/test_array_index_write.groovy | 4 +-
.../compaction/compaction_sparse_column.groovy | 46 +--------------------
.../compaction/test_compaction_extract_root.groovy | 44 +-------------------
regression-test/suites/variant_p2/load.groovy | 13 ------
80 files changed, 7 insertions(+), 140 deletions(-)
diff --git a/regression-test/data/variant_github_events_new_p2/load.out
b/regression-test/data/variant_github_events_new_p0/load.out
similarity index 100%
rename from regression-test/data/variant_github_events_new_p2/load.out
rename to regression-test/data/variant_github_events_new_p0/load.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/affinityByIssuesAndPRs1.out
b/regression-test/data/variant_github_events_new_p0/sql/affinityByIssuesAndPRs1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/affinityByIssuesAndPRs1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/affinityByIssuesAndPRs1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/affinityByIssuesAndPRs2.out
b/regression-test/data/variant_github_events_new_p0/sql/affinityByIssuesAndPRs2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/affinityByIssuesAndPRs2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/affinityByIssuesAndPRs2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/authorsWithTheMostPushes.out
b/regression-test/data/variant_github_events_new_p0/sql/authorsWithTheMostPushes.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/authorsWithTheMostPushes.out
rename to
regression-test/data/variant_github_events_new_p0/sql/authorsWithTheMostPushes.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/countingStar1.out
b/regression-test/data/variant_github_events_new_p0/sql/countingStar1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/countingStar1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/countingStar1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/countingStar2.out
b/regression-test/data/variant_github_events_new_p0/sql/countingStar2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/countingStar2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/countingStar2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/countingStar3.out
b/regression-test/data/variant_github_events_new_p0/sql/countingStar3.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/countingStar3.out
rename to
regression-test/data/variant_github_events_new_p0/sql/countingStar3.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/distributionOfRepositoriesByStarCount.out
b/regression-test/data/variant_github_events_new_p0/sql/distributionOfRepositoriesByStarCount.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/distributionOfRepositoriesByStarCount.out
rename to
regression-test/data/variant_github_events_new_p0/sql/distributionOfRepositoriesByStarCount.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/githubRoulette.out
b/regression-test/data/variant_github_events_new_p0/sql/githubRoulette.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/githubRoulette.out
rename to
regression-test/data/variant_github_events_new_p0/sql/githubRoulette.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
b/regression-test/data/variant_github_events_new_p0/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
b/regression-test/data/variant_github_events_new_p0/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
b/regression-test/data/variant_github_events_new_p0/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
rename to
regression-test/data/variant_github_events_new_p0/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
b/regression-test/data/variant_github_events_new_p0/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
rename to
regression-test/data/variant_github_events_new_p0/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
b/regression-test/data/variant_github_events_new_p0/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
rename to
regression-test/data/variant_github_events_new_p0/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
b/regression-test/data/variant_github_events_new_p0/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
rename to
regression-test/data/variant_github_events_new_p0/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
b/regression-test/data/variant_github_events_new_p0/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
rename to
regression-test/data/variant_github_events_new_p0/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments1.out
b/regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments2.out
b/regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments3.out
b/regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments3.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments3.out
rename to
regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments3.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments4.out
b/regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments4.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments4.out
rename to
regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments4.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments5.out
b/regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments5.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments5.out
rename to
regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments5.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments6.out
b/regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments6.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments6.out
rename to
regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments6.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments7.out
b/regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments7.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/issuesWithTheMostComments7.out
rename to
regression-test/data/variant_github_events_new_p0/sql/issuesWithTheMostComments7.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/mostForkedRepositories.out
b/regression-test/data/variant_github_events_new_p0/sql/mostForkedRepositories.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/mostForkedRepositories.out
rename to
regression-test/data/variant_github_events_new_p0/sql/mostForkedRepositories.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/mostPopularCommentsOnGithub.out
b/regression-test/data/variant_github_events_new_p0/sql/mostPopularCommentsOnGithub.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/mostPopularCommentsOnGithub.out
rename to
regression-test/data/variant_github_events_new_p0/sql/mostPopularCommentsOnGithub.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/organizationsByTheNumberOfRepositories.out
b/regression-test/data/variant_github_events_new_p0/sql/organizationsByTheNumberOfRepositories.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/organizationsByTheNumberOfRepositories.out
rename to
regression-test/data/variant_github_events_new_p0/sql/organizationsByTheNumberOfRepositories.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/organizationsByTheNumberOfStars.out
b/regression-test/data/variant_github_events_new_p0/sql/organizationsByTheNumberOfStars.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/organizationsByTheNumberOfStars.out
rename to
regression-test/data/variant_github_events_new_p0/sql/organizationsByTheNumberOfStars.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks1.out
b/regression-test/data/variant_github_events_new_p0/sql/proportionsBetweenStarsAndForks1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/proportionsBetweenStarsAndForks1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks2.out
b/regression-test/data/variant_github_events_new_p0/sql/proportionsBetweenStarsAndForks2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/proportionsBetweenStarsAndForks2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks3.out
b/regression-test/data/variant_github_events_new_p0/sql/proportionsBetweenStarsAndForks3.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks3.out
rename to
regression-test/data/variant_github_events_new_p0/sql/proportionsBetweenStarsAndForks3.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks4.out
b/regression-test/data/variant_github_events_new_p0/sql/proportionsBetweenStarsAndForks4.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks4.out
rename to
regression-test/data/variant_github_events_new_p0/sql/proportionsBetweenStarsAndForks4.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks5.out
b/regression-test/data/variant_github_events_new_p0/sql/proportionsBetweenStarsAndForks5.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks5.out
rename to
regression-test/data/variant_github_events_new_p0/sql/proportionsBetweenStarsAndForks5.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesByAmountOfModifiedCode.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesByAmountOfModifiedCode.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesByAmountOfModifiedCode.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesByAmountOfModifiedCode.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesByTheNumberOfPushes.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesByTheNumberOfPushes.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesByTheNumberOfPushes.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesByTheNumberOfPushes.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithClickhouse_related_comments1.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithClickhouse_related_comments1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithClickhouse_related_comments1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithClickhouse_related_comments1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithClickhouse_related_comments2.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithClickhouse_related_comments2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithClickhouse_related_comments2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithClickhouse_related_comments2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithDoris_related_comments1.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithDoris_related_comments1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithDoris_related_comments1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithDoris_related_comments1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithDoris_related_comments2.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithDoris_related_comments2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithDoris_related_comments2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithDoris_related_comments2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheHighestGrowthYoY.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheHighestGrowthYoY.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheHighestGrowthYoY.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheHighestGrowthYoY.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumAmountOfIssues1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumAmountOfIssues1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumAmountOfIssues2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumAmountOfIssues2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumAmountOfIssues3.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumAmountOfIssues3.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumAmountOfIssues4.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumAmountOfIssues4.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumAmountOfPullRequests1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumAmountOfPullRequests1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMostStarsOverOneDay1.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMostStarsOverOneDay1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMostStarsOverOneDay1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMostStarsOverOneDay1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMostSteadyGrowthOverTime.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMostSteadyGrowthOverTime.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheMostSteadyGrowthOverTime.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheMostSteadyGrowthOverTime.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheWorstStagnation_order.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheWorstStagnation_order.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoriesWithTheWorstStagnation_order.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoriesWithTheWorstStagnation_order.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoryAffinityList1.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoryAffinityList1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoryAffinityList1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoryAffinityList1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/repositoryAffinityList2.out
b/regression-test/data/variant_github_events_new_p0/sql/repositoryAffinityList2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/repositoryAffinityList2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/repositoryAffinityList2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/starsFromHeavyGithubUsers1.out
b/regression-test/data/variant_github_events_new_p0/sql/starsFromHeavyGithubUsers1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/starsFromHeavyGithubUsers1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/starsFromHeavyGithubUsers1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/starsFromHeavyGithubUsers2.out
b/regression-test/data/variant_github_events_new_p0/sql/starsFromHeavyGithubUsers2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/starsFromHeavyGithubUsers2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/starsFromHeavyGithubUsers2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/test_distinct_streaming_agg.out
b/regression-test/data/variant_github_events_new_p0/sql/test_distinct_streaming_agg.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/test_distinct_streaming_agg.out
rename to
regression-test/data/variant_github_events_new_p0/sql/test_distinct_streaming_agg.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/theLongestRepositoryNames1.out
b/regression-test/data/variant_github_events_new_p0/sql/theLongestRepositoryNames1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/theLongestRepositoryNames1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/theLongestRepositoryNames1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/theLongestRepositoryNames2.out
b/regression-test/data/variant_github_events_new_p0/sql/theLongestRepositoryNames2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/theLongestRepositoryNames2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/theLongestRepositoryNames2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/theMostToughCodeReviews.out
b/regression-test/data/variant_github_events_new_p0/sql/theMostToughCodeReviews.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/theMostToughCodeReviews.out
rename to
regression-test/data/variant_github_events_new_p0/sql/theMostToughCodeReviews.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/theTotalNumberOfRepositoriesOnGithub.out
b/regression-test/data/variant_github_events_new_p0/sql/theTotalNumberOfRepositoriesOnGithub.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/theTotalNumberOfRepositoriesOnGithub.out
rename to
regression-test/data/variant_github_events_new_p0/sql/theTotalNumberOfRepositoriesOnGithub.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub1.out
b/regression-test/data/variant_github_events_new_p0/sql/theTotalNumberOfUsersOnGithub1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/theTotalNumberOfUsersOnGithub1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub2.out
b/regression-test/data/variant_github_events_new_p0/sql/theTotalNumberOfUsersOnGithub2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/theTotalNumberOfUsersOnGithub2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub3.out
b/regression-test/data/variant_github_events_new_p0/sql/theTotalNumberOfUsersOnGithub3.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub3.out
rename to
regression-test/data/variant_github_events_new_p0/sql/theTotalNumberOfUsersOnGithub3.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub4.out
b/regression-test/data/variant_github_events_new_p0/sql/theTotalNumberOfUsersOnGithub4.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub4.out
rename to
regression-test/data/variant_github_events_new_p0/sql/theTotalNumberOfUsersOnGithub4.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/topRepositoriesByStars.out
b/regression-test/data/variant_github_events_new_p0/sql/topRepositoriesByStars.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/topRepositoriesByStars.out
rename to
regression-test/data/variant_github_events_new_p0/sql/topRepositoriesByStars.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
b/regression-test/data/variant_github_events_new_p0/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
rename to
regression-test/data/variant_github_events_new_p0/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars1.out
b/regression-test/data/variant_github_events_new_p0/sql/whoAreAllThosePeopleGivingStars1.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars1.out
rename to
regression-test/data/variant_github_events_new_p0/sql/whoAreAllThosePeopleGivingStars1.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars2.out
b/regression-test/data/variant_github_events_new_p0/sql/whoAreAllThosePeopleGivingStars2.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars2.out
rename to
regression-test/data/variant_github_events_new_p0/sql/whoAreAllThosePeopleGivingStars2.out
diff --git
a/regression-test/data/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars3.out
b/regression-test/data/variant_github_events_new_p0/sql/whoAreAllThosePeopleGivingStars3.out
similarity index 100%
rename from
regression-test/data/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars3.out
rename to
regression-test/data/variant_github_events_new_p0/sql/whoAreAllThosePeopleGivingStars3.out
diff --git a/regression-test/data/variant_p0/desc.out
b/regression-test/data/variant_p0/desc.out
index ffd87b9d05b..1eff52e4484 100644
Binary files a/regression-test/data/variant_p0/desc.out and
b/regression-test/data/variant_p0/desc.out differ
diff --git
a/regression-test/data/variant_p1/compaction/test_compaction_extract_root.out
b/regression-test/data/variant_p1/compaction/test_compaction_extract_root.out
index c8a0cf24017..5d16b15d26a 100644
Binary files
a/regression-test/data/variant_p1/compaction/test_compaction_extract_root.out
and
b/regression-test/data/variant_p1/compaction/test_compaction_extract_root.out
differ
diff --git
a/regression-test/suites/inverted_index_p0/test_show_nested_index_file_http_action_with_variant.groovy
b/regression-test/suites/inverted_index_p0/test_show_nested_index_file_http_action_with_variant.groovy
index e242f858872..f86223b7069 100644
---
a/regression-test/suites/inverted_index_p0/test_show_nested_index_file_http_action_with_variant.groovy
+++
b/regression-test/suites/inverted_index_p0/test_show_nested_index_file_http_action_with_variant.groovy
@@ -59,7 +59,6 @@ suite("test_show_nested_index_file_http_action_with_variant",
"nonConcurrent,p0"
}
set_be_config.call("memory_limitation_per_thread_for_schema_change_bytes",
"6294967296")
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1")
def run_test = { format ->
def tableName =
"test_show_nested_index_file_http_action_with_variant_" + format
diff --git a/regression-test/suites/variant_github_events_new_p2/load.groovy
b/regression-test/suites/variant_github_events_new_p0/load.groovy
similarity index 93%
rename from regression-test/suites/variant_github_events_new_p2/load.groovy
rename to regression-test/suites/variant_github_events_new_p0/load.groovy
index 5721a0eb10a..582f3bec565 100644
--- a/regression-test/suites/variant_github_events_new_p2/load.groovy
+++ b/regression-test/suites/variant_github_events_new_p0/load.groovy
@@ -15,16 +15,7 @@
// specific language governing permissions and limitations
// under the License.
-suite("regression_test_variant_github_events_p2", "nonConcurrent,p2"){
- def backendId_to_backendIP = [:]
- def backendId_to_backendHttpPort = [:]
- getBackendIpHttpPort(backendId_to_backendIP, backendId_to_backendHttpPort);
- def set_be_config = { key, value ->
- for (String backend_id: backendId_to_backendIP.keySet()) {
- def (code, out, err) =
update_be_config(backendId_to_backendIP.get(backend_id),
backendId_to_backendHttpPort.get(backend_id), key, value)
- logger.info("update config: code=" + code + ", out=" + out + ",
err=" + err)
- }
- }
+suite("regression_test_variant_github_events_p0", "p0"){
def load_json_data = {table_name, file_name ->
// load the json data
streamLoad {
@@ -53,7 +44,6 @@ suite("regression_test_variant_github_events_p2",
"nonConcurrent,p2"){
}
}
}
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1")
def table_name = "github_events"
sql """DROP TABLE IF EXISTS ${table_name}"""
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 e7252d35ad5..316ebabbb55 100644
--- a/regression-test/suites/variant_github_events_nonConcurrent_p2/load.groovy
+++ b/regression-test/suites/variant_github_events_nonConcurrent_p2/load.groovy
@@ -160,7 +160,6 @@ suite("regression_test_variant_github_events_p2",
"nonConcurrent,p2"){
DISTRIBUTED BY HASH(k) BUCKETS 4
properties("replication_num" = "1", "disable_auto_compaction" =
"true", "bloom_filter_columns" = "v", "variant_enable_flatten_nested" = "true",
"inverted_index_storage_format"= "v2");
"""
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1")
// 2015
load_json_data.call(table_name, """${getS3Url() +
'/regression/gharchive.m/2015-01-01-0.json'}""")
load_json_data.call(table_name, """${getS3Url() +
'/regression/gharchive.m/2015-01-01-1.json'}""")
diff --git a/regression-test/suites/variant_log_data_p2/load.groovy
b/regression-test/suites/variant_log_data_p2/load.groovy
index 8e6d15e172d..f1fa6caf17b 100644
--- a/regression-test/suites/variant_log_data_p2/load.groovy
+++ b/regression-test/suites/variant_log_data_p2/load.groovy
@@ -72,21 +72,18 @@ suite("regression_test_variant_logdata",
"nonConcurrent,p2"){
create_table.call(table_name, "DUPLICATE", "4")
// sql "set enable_two_phase_read_opt = false;"
// no sparse columns
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1")
load_json_data.call(table_name, """${getS3Url() +
'/regression/load/logdata.json'}""")
qt_sql_32 """ select json_extract(v, "\$.json.parseFailed") from logdata
where json_extract(v, "\$.json.parseFailed") != 'null' order by k limit 1;"""
qt_sql_32_1 """select cast(v['json']['parseFailed'] as string) from
logdata where cast(v['json']['parseFailed'] as string) is not null and k = 162
limit 1;"""
sql "truncate table ${table_name}"
// 0.95 default ratio
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1")
load_json_data.call(table_name, """${getS3Url() +
'/regression/load/logdata.json'}""")
qt_sql_33 """ select json_extract(v,"\$.json.parseFailed") from logdata
where json_extract(v,"\$.json.parseFailed") != 'null' order by k limit 1;"""
qt_sql_33_1 """select cast(v['json']['parseFailed'] as string) from
logdata where cast(v['json']['parseFailed'] as string) is not null and k = 162
limit 1;"""
sql "truncate table ${table_name}"
// always sparse column
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1")
load_json_data.call(table_name, """${getS3Url() +
'/regression/load/logdata.json'}""")
qt_sql_34 """ select json_extract(v, "\$.json.parseFailed") from logdata
where json_extract(v,"\$.json.parseFailed") != 'null' order by k limit 1;"""
sql "truncate table ${table_name}"
@@ -94,5 +91,4 @@ suite("regression_test_variant_logdata", "nonConcurrent,p2"){
qt_sql_35_1 """select cast(v['json']['parseFailed'] as string) from
logdata where cast(v['json']['parseFailed'] as string) is not null and k = 162
limit 1;"""
// TODO add test case that some certain columns are materialized in some
file while others are not materilized(sparse)
// unique table
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1")
}
\ No newline at end of file
diff --git a/regression-test/suites/variant_p0/desc.groovy
b/regression-test/suites/variant_p0/desc.groovy
index 868a3e1307f..59d0cd261da 100644
--- a/regression-test/suites/variant_p0/desc.groovy
+++ b/regression-test/suites/variant_p0/desc.groovy
@@ -15,7 +15,7 @@
// specific language governing permissions and limitations
// under the License.
-suite("regression_test_variant_desc", "nonConcurrent"){
+suite("regression_test_variant_desc", "p0"){
// if (isCloudMode()) {
// return
// }
@@ -97,7 +97,6 @@ suite("regression_test_variant_desc", "nonConcurrent"){
// sparse columns
def table_name = "sparse_columns"
create_table table_name
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column",
"0.95")
sql """set describe_extend_variant_column = true"""
sql """insert into sparse_columns select 0, '{"a": 11245, "b" : [123,
{"xx" : 1}], "c" : {"c" : 456, "d" : null, "e" : 7.111}}' as json_str
union all select 0, '{"a": 1123}' as json_str union all select 0,
'{"a" : 1234, "xxxx" : "kaana"}' as json_str from numbers("number" = "4096")
limit 4096 ;"""
@@ -115,7 +114,6 @@ suite("regression_test_variant_desc", "nonConcurrent"){
table_name = "no_sparse_columns"
create_table.call(table_name, "4")
sql "set enable_two_phase_read_opt = false;"
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1.0")
sql """insert into ${table_name} select 0, '{"a": 11245, "b" : [123,
{"xx" : 1}], "c" : {"c" : 456, "d" : null, "e" : 7.111}}' as json_str
union all select 0, '{"a": 1123}' as json_str union all select 0,
'{"a" : 1234, "xxxx" : "kaana"}' as json_str from numbers("number" = "4096")
limit 4096 ;"""
sql "select * from no_sparse_columns limit 1"
@@ -126,7 +124,6 @@ suite("regression_test_variant_desc", "nonConcurrent"){
table_name = "partition_data"
create_table_partition.call(table_name, "4")
sql "set enable_two_phase_read_opt = false;"
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column",
"0.95")
sql """insert into ${table_name} select 2500, '{"a": 1123, "b" :
[123, {"xx" : 1}], "c" : {"c" : 456, "d" : null, "e" : 7.111}, "zzz" : null,
"oooo" : {"akakaka" : null, "xxxx" : {"xxx" : 123}}}' as json_str
union all select 2500, '{"a" : 1234, "xxxx" : "kaana", "ddd" :
{"aaa" : 123, "mxmxm" : [456, "789"]}}' as json_str from numbers("number" =
"4096") limit 4096 ;"""
sql """insert into ${table_name} select 45000, '{"a": 11245, "b" :
[123, {"xx" : 1}], "c" : {"c" : 456, "d" : null, "e" : 7.111}}' as json_str
@@ -274,6 +271,5 @@ suite("regression_test_variant_desc", "nonConcurrent"){
sql "desc large_tablets"
} finally {
// reset flags
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1")
}
}
diff --git a/regression-test/suites/variant_p0/with_index/load.groovy
b/regression-test/suites/variant_p0/with_index/load.groovy
index 4eeff1bfacb..dcfdc7ebccc 100644
--- a/regression-test/suites/variant_p0/with_index/load.groovy
+++ b/regression-test/suites/variant_p0/with_index/load.groovy
@@ -15,18 +15,7 @@
// specific language governing permissions and limitations
// under the License.
-suite("regression_test_variant_with_index", "nonConcurrent"){
- def set_be_config = { key, value ->
- String backend_id;
- def backendId_to_backendIP = [:]
- def backendId_to_backendHttpPort = [:]
- getBackendIpHttpPort(backendId_to_backendIP,
backendId_to_backendHttpPort);
-
- backend_id = backendId_to_backendIP.keySet()[0]
- def (code, out, err) =
update_be_config(backendId_to_backendIP.get(backend_id),
backendId_to_backendHttpPort.get(backend_id), key, value)
- logger.info("update config: code=" + code + ", out=" + out + ", err="
+ err)
- }
-
+suite("regression_test_variant_with_index", "p0"){
def timeout = 60000
def delta_time = 1000
def alter_res = "null"
@@ -45,8 +34,6 @@ suite("regression_test_variant_with_index", "nonConcurrent"){
}
assertTrue(useTime <= OpTimeout, "wait_for_latest_op_on_table_finish
timeout")
}
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1.0")
- set_be_config.call("variant_threshold_rows_to_estimate_sparse_column", "0")
def table_name = "var_with_index"
sql "DROP TABLE IF EXISTS var_with_index"
sql """
@@ -68,7 +55,6 @@ suite("regression_test_variant_with_index", "nonConcurrent"){
qt_sql_inv_3 """select * from var_with_index where inv match 'hello' and
cast(v["a"] as int) > 0 order by k"""
sql "truncate table var_with_index"
// set back configs
- set_be_config.call("variant_threshold_rows_to_estimate_sparse_column",
"2048")
// sql "truncate table ${table_name}"
sql """insert into var_with_index values(1, '{"a1" : 0, "b1": 3}', 'hello
world'), (2, '{"a2" : 123}', 'world'),(3, '{"a3" : 123}', 'hello world')"""
sql """insert into var_with_index values(4, '{"b1" : 0, "b2": 3}', 'hello
world'), (5, '{"b2" : 123}', 'world'),(6, '{"b3" : 123}', 'hello world')"""
diff --git
a/regression-test/suites/variant_p0/with_index/test_array_index_write.groovy
b/regression-test/suites/variant_p0/with_index/test_array_index_write.groovy
index 306a9860616..a5f5d9e97ea 100644
--- a/regression-test/suites/variant_p0/with_index/test_array_index_write.groovy
+++ b/regression-test/suites/variant_p0/with_index/test_array_index_write.groovy
@@ -28,8 +28,8 @@ suite("test_array_index_write", "nonConcurrent"){
stmt += strTmp
stmt = stmt.substring(0, stmt.length()-2)
def storageFormat = new Random().nextBoolean() ? "V1" : "V2"
- if (storageFormat == "V1" && isCloudMode()) {
- return;
+ if (isCloudMode()) {
+ storageFormat = "V2";
}
stmt += ") \nENGINE=OLAP\n" +
"DUPLICATE KEY(`k1`)\n" +
diff --git
a/regression-test/suites/variant_p1/compaction/compaction_sparse_column.groovy
b/regression-test/suites/variant_p1/compaction/compaction_sparse_column.groovy
index 13ef63e9fe6..ebe2aac8642 100644
---
a/regression-test/suites/variant_p1/compaction/compaction_sparse_column.groovy
+++
b/regression-test/suites/variant_p1/compaction/compaction_sparse_column.groovy
@@ -18,38 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
import org.awaitility.Awaitility
-suite("test_compaction_sparse_column", "p1,nonConcurrent") {
+suite("test_compaction_sparse_column", "p1") {
def tableName = "test_compaction"
try {
- String backend_id;
- def backendId_to_backendIP = [:]
- def backendId_to_backendHttpPort = [:]
- getBackendIpHttpPort(backendId_to_backendIP,
backendId_to_backendHttpPort);
-
- backend_id = backendId_to_backendIP.keySet()[0]
- def (code, out, err) =
show_be_config(backendId_to_backendIP.get(backend_id),
backendId_to_backendHttpPort.get(backend_id))
- logger.info("Show config: code=" + code + ", out=" + out + ", err=" +
err)
- assertEquals(code, 0)
- def configList = parseJson(out.trim())
- assert configList instanceof List
-
- boolean disableAutoCompaction = true
- for (Object ele in (List) configList) {
- assert ele instanceof List<String>
- if (((List<String>) ele)[0] == "disable_auto_compaction") {
- disableAutoCompaction = Boolean.parseBoolean(((List<String>)
ele)[2])
- }
- }
-
- def set_be_config = { key, value ->
- (code, out, err) =
update_be_config(backendId_to_backendIP.get(backend_id),
backendId_to_backendHttpPort.get(backend_id), key, value)
- logger.info("update config: code=" + code + ", out=" + out + ",
err=" + err)
- }
-
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column",
"0.95")
- set_be_config.call("write_buffer_size", "10240")
-
sql """ DROP TABLE IF EXISTS ${tableName} """
sql """
CREATE TABLE ${tableName} (
@@ -110,19 +82,6 @@ suite("test_compaction_sparse_column", "p1,nonConcurrent") {
// trigger compactions for all tablets in ${tableName}
trigger_and_wait_compaction(tableName, "cumulative")
- int rowCount = 0
- for (def tablet in tablets) {
- String tablet_id = tablet.TabletId
- (code, out, err) = curl("GET", tablet.CompactionStatus)
- logger.info("Show tablets status: code=" + code + ", out=" + out +
", err=" + err)
- assertEquals(code, 0)
- def tabletJson = parseJson(out.trim())
- assert tabletJson.rowsets instanceof List
- for (String rowset in (List<String>) tabletJson.rowsets) {
- rowCount += Integer.parseInt(rowset.split(" ")[1])
- }
- }
- assert (rowCount <= 8)
qt_select_b """ SELECT count(cast(v['b'] as int)) FROM ${tableName};"""
qt_select_xxxx """ SELECT count(cast(v['xxxx'] as string)) FROM
${tableName};"""
qt_select_point """ SELECT count(cast(v['point'] as bigint)) FROM
${tableName};"""
@@ -140,8 +99,5 @@ suite("test_compaction_sparse_column", "p1,nonConcurrent") {
qt_select_6_1 """ SELECT count(cast(v['b'] as int)) FROM ${tableName}
where cast(v['b'] as int) = 42005;"""
qt_select_all """SELECT k, v['a'], v['b'], v['xxxx'], v['point'],
v['ddddd'] from ${tableName} where (cast(v['point'] as int) = 1);"""
} finally {
- // try_sql("DROP TABLE IF EXISTS ${tableName}")
- set_be_config.call("write_buffer_size", "209715200")
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1")
}
}
diff --git
a/regression-test/suites/variant_p1/compaction/test_compaction_extract_root.groovy
b/regression-test/suites/variant_p1/compaction/test_compaction_extract_root.groovy
index 015ab9baa1d..d1b4e8e93da 100644
---
a/regression-test/suites/variant_p1/compaction/test_compaction_extract_root.groovy
+++
b/regression-test/suites/variant_p1/compaction/test_compaction_extract_root.groovy
@@ -17,34 +17,8 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
-suite("test_compaction_extract_root", "p1,nonConcurrent") {
+suite("test_compaction_extract_root", "p1") {
def tableName = "test_t"
-
- def backendId_to_backendIP = [:]
- def backendId_to_backendHttpPort = [:]
- getBackendIpHttpPort(backendId_to_backendIP, backendId_to_backendHttpPort);
- def set_be_config = { key, value ->
- for (String backend_id: backendId_to_backendIP.keySet()) {
- def (code, out, err) =
update_be_config(backendId_to_backendIP.get(backend_id),
backendId_to_backendHttpPort.get(backend_id), key, value)
- logger.info("update config: code=" + code + ", out=" + out + ",
err=" + err)
- }
- }
- String backend_id;
- backend_id = backendId_to_backendIP.keySet()[0]
- def (code, out, err) =
show_be_config(backendId_to_backendIP.get(backend_id),
backendId_to_backendHttpPort.get(backend_id))
- logger.info("Show config: code=" + code + ", out=" + out + ", err=" + err)
- assertEquals(code, 0)
- def configList = parseJson(out.trim())
- assert configList instanceof List
-
- boolean disableAutoCompaction = true
- for (Object ele in (List) configList) {
- assert ele instanceof List<String>
- if (((List<String>) ele)[0] == "disable_auto_compaction") {
- disableAutoCompaction = Boolean.parseBoolean(((List<String>)
ele)[2])
- }
- }
-
sql """ DROP TABLE IF EXISTS ${tableName} """
sql """
CREATE TABLE ${tableName} (
@@ -59,8 +33,6 @@ suite("test_compaction_extract_root", "p1,nonConcurrent") {
);
"""
- set_be_config.call("enable_vertical_segment_writer", "true")
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "0.95")
sql """insert into ${tableName} select 0, '{"a": 11245, "b" : {"state" :
"open", "code" : 2}}' as json_str
union all select 8, '{"a": 1123}' as json_str union all select 0,
'{"a" : 1234, "xxxx" : "aaaaa"}' as json_str from numbers("number" = "4096")
limit 4096 ;"""
@@ -98,19 +70,6 @@ suite("test_compaction_extract_root", "p1,nonConcurrent") {
// trigger compactions for all tablets in ${tableName}
trigger_and_wait_compaction(tableName, "cumulative")
- int rowCount = 0
- for (def tablet in tablets) {
- String tablet_id = tablet.TabletId
- (code, out, err) = curl("GET", tablet.CompactionStatus)
- logger.info("Show tablets status: code=" + code + ", out=" + out + ",
err=" + err)
- assertEquals(code, 0)
- def tabletJson = parseJson(out.trim())
- assert tabletJson.rowsets instanceof List
- for (String rowset in (List<String>) tabletJson.rowsets) {
- rowCount += Integer.parseInt(rowset.split(" ")[1])
- }
- }
- assert (rowCount <= 8)
// fix cast to string tobe {}
qt_select_b_3 """ SELECT count(cast(v['b'] as string)) FROM test_t"""
qt_select_b_4 """ SELECT count(cast(v['b'] as int)) FROM test_t"""
@@ -118,5 +77,4 @@ suite("test_compaction_extract_root", "p1,nonConcurrent") {
// qt_select_b_5 """ select v['b'] from test_t where cast(v['b'] as
string) != '42005' and cast(v['b'] as string) != '42004' and cast(v['b'] as
string) != '42003' order by cast(v['b'] as string); """
qt_select_1 """select v['b'] from test_t where k = 0 and cast(v['a'] as
int) = 11245;"""
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1")
}
diff --git a/regression-test/suites/variant_p2/load.groovy
b/regression-test/suites/variant_p2/load.groovy
index 7bc05663e6b..056bb666e34 100644
--- a/regression-test/suites/variant_p2/load.groovy
+++ b/regression-test/suites/variant_p2/load.groovy
@@ -69,17 +69,6 @@ suite("load_p2", "variant_type,p2"){
"""
}
- def set_be_config = { key, value ->
- String backend_id;
- def backendId_to_backendIP = [:]
- def backendId_to_backendHttpPort = [:]
- getBackendIpHttpPort(backendId_to_backendIP,
backendId_to_backendHttpPort);
-
- backend_id = backendId_to_backendIP.keySet()[0]
- def (code, out, err) =
update_be_config(backendId_to_backendIP.get(backend_id),
backendId_to_backendHttpPort.get(backend_id), key, value)
- logger.info("update config: code=" + code + ", out=" + out + ", err="
+ err)
- }
-
// Configuration for the number of threads
def numberOfThreads = 10 // Set this to your desired number of threads
@@ -88,7 +77,6 @@ suite("load_p2", "variant_type,p2"){
try {
def table_name = "github_events"
- set_be_config.call("variant_ratio_of_defaults_as_sparse_column", "1.0")
def s3load_paral_wait = {tbl, fmt, path, paral ->
String ak = getS3AK()
String sk = getS3SK()
@@ -167,6 +155,5 @@ suite("load_p2", "variant_type,p2"){
qt_sql("select count() from github_events")
} finally {
// reset flags
- // set_be_config.call("variant_ratio_of_defaults_as_sparse_column",
"0.95")
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
