(doris) branch branch-3.1 updated: [regression-test](variant) refine variant_github_events_index_type_p2 (#54691)

eldenmoon Wed, 13 Aug 2025 05:40:08 -0700

This is an automated email from the ASF dual-hosted git repository.

eldenmoon pushed a commit to branch branch-3.1
in repository https://gitbox.apache.org/repos/asf/doris.git



The following commit(s) were added to refs/heads/branch-3.1 by this push:
     new 821af6a92a6 [regression-test](variant) refine 
variant_github_events_index_type_p2 (#54691)
821af6a92a6 is described below

commit 821af6a92a665094c2c9034056b27072aa27b784
Author: lihangyu <[email protected]>
AuthorDate: Wed Aug 13 20:39:55 2025 +0800

    [regression-test](variant) refine variant_github_events_index_type_p2 
(#54691)
---
 .../sparsed/load.out                               | Bin 85210 -> 0 bytes
 .../sparsed/sql/affinityByIssuesAndPRs1.out        | Bin 322 -> 0 bytes
 .../sparsed/sql/affinityByIssuesAndPRs2.out        | Bin 198 -> 0 bytes
 .../sparsed/sql/authorsWithTheMostPushes.out       | Bin 1002 -> 0 bytes
 .../sparsed/sql/countingStar1.out                  | Bin 122 -> 0 bytes
 .../sparsed/sql/countingStar2.out                  | Bin 130 -> 0 bytes
 .../sparsed/sql/countingStar3.out                  | Bin 120 -> 0 bytes
 .../sql/distributionOfRepositoriesByStarCount.out  | Bin 157 -> 0 bytes
 .../sparsed/sql/githubRoulette.out                 | Bin 1178 -> 0 bytes
 ...heListOfTopRepositoriesChangedOverTheYears1.out | Bin 1227 -> 0 bytes
 ...heListOfTopRepositoriesChangedOverTheYears2.out | Bin 1227 -> 0 bytes
 ...heListOfTopRepositoriesChangedOverTheYears3.out | Bin 1281 -> 0 bytes
 ...heListOfTopRepositoriesChangedOverTheYears4.out | Bin 1227 -> 0 bytes
 ...heListOfTopRepositoriesChangedOverTheYears5.out | Bin 1227 -> 0 bytes
 ...heListOfTopRepositoriesChangedOverTheYears6.out | Bin 1227 -> 0 bytes
 .../howHasTheTotalNumberOfStarsChangedOverTime.out | Bin 166 -> 0 bytes
 .../sparsed/sql/issuesWithTheMostComments1.out     | Bin 135 -> 0 bytes
 .../sparsed/sql/issuesWithTheMostComments2.out     | Bin 1274 -> 0 bytes
 .../sparsed/sql/issuesWithTheMostComments3.out     | Bin 1607 -> 0 bytes
 .../sparsed/sql/issuesWithTheMostComments4.out     | Bin 1441 -> 0 bytes
 .../sparsed/sql/issuesWithTheMostComments5.out     | Bin 1433 -> 0 bytes
 .../sparsed/sql/issuesWithTheMostComments6.out     | Bin 460 -> 0 bytes
 .../sparsed/sql/issuesWithTheMostComments7.out     | Bin 1451 -> 0 bytes
 .../sparsed/sql/mostForkedRepositories.out         | Bin 1417 -> 0 bytes
 .../sparsed/sql/mostPopularCommentsOnGithub.out    | Bin 2712 -> 0 bytes
 .../sql/organizationsByTheNumberOfRepositories.out | Bin 213 -> 0 bytes
 .../sql/organizationsByTheNumberOfStars.out        | Bin 714 -> 0 bytes
 .../sql/proportionsBetweenStarsAndForks1.out       | Bin 1735 -> 0 bytes
 .../sql/proportionsBetweenStarsAndForks2.out       | Bin 136 -> 0 bytes
 .../sql/proportionsBetweenStarsAndForks3.out       | Bin 202 -> 0 bytes
 .../sql/proportionsBetweenStarsAndForks4.out       | Bin 151 -> 0 bytes
 .../sql/proportionsBetweenStarsAndForks5.out       | Bin 149 -> 0 bytes
 .../sql/repositoriesByAmountOfModifiedCode.out     | Bin 1983 -> 0 bytes
 .../sql/repositoriesByTheNumberOfPushes.out        | Bin 1437 -> 0 bytes
 ...epositoriesWithClickhouse_related_comments1.out | Bin 393 -> 0 bytes
 ...epositoriesWithClickhouse_related_comments2.out | Bin 417 -> 0 bytes
 .../repositoriesWithDoris_related_comments1.out    | Bin 254 -> 0 bytes
 .../repositoriesWithDoris_related_comments2.out    | Bin 266 -> 0 bytes
 .../sql/repositoriesWithTheHighestGrowthYoY.out    | Bin 673 -> 0 bytes
 .../repositoriesWithTheMaximumAmountOfIssues1.out  | Bin 1542 -> 0 bytes
 .../repositoriesWithTheMaximumAmountOfIssues2.out  | Bin 1643 -> 0 bytes
 .../repositoriesWithTheMaximumAmountOfIssues3.out  | Bin 319 -> 0 bytes
 .../repositoriesWithTheMaximumAmountOfIssues4.out  | Bin 1447 -> 0 bytes
 ...sitoriesWithTheMaximumAmountOfPullRequests1.out | Bin 1599 -> 0 bytes
 ...sitoriesWithTheMaximumAmountOfPullRequests2.out | Bin 1657 -> 0 bytes
 ...esWithTheMaximumNumberOfAcceptedInvitations.out | Bin 1363 -> 0 bytes
 ...sitoriesWithTheMostPeopleWhoHavePushAccess1.out | Bin 1397 -> 0 bytes
 .../repositoriesWithTheMostStarsOverOneDay1.out    | Bin 1788 -> 0 bytes
 ...repositoriesWithTheMostSteadyGrowthOverTime.out | Bin 1762 -> 0 bytes
 .../repositoriesWithTheWorstStagnation_order.out   | Bin 456 -> 0 bytes
 .../sparsed/sql/repositoryAffinityList1.out        | Bin 1271 -> 0 bytes
 .../sparsed/sql/repositoryAffinityList2.out        | Bin 307 -> 0 bytes
 .../sparsed/sql/starsFromHeavyGithubUsers1.out     | Bin 809 -> 0 bytes
 .../sparsed/sql/starsFromHeavyGithubUsers2.out     | Bin 282 -> 0 bytes
 .../sparsed/sql/theLongestRepositoryNames1.out     | Bin 2917 -> 0 bytes
 .../sparsed/sql/theLongestRepositoryNames2.out     | Bin 713 -> 0 bytes
 .../sparsed/sql/theMostToughCodeReviews.out        | Bin 2470 -> 0 bytes
 .../sql/theTotalNumberOfRepositoriesOnGithub.out   | Bin 146 -> 0 bytes
 .../sparsed/sql/theTotalNumberOfUsersOnGithub1.out | Bin 140 -> 0 bytes
 .../sparsed/sql/theTotalNumberOfUsersOnGithub2.out | Bin 139 -> 0 bytes
 .../sparsed/sql/theTotalNumberOfUsersOnGithub3.out | Bin 140 -> 0 bytes
 .../sparsed/sql/theTotalNumberOfUsersOnGithub4.out | Bin 139 -> 0 bytes
 .../sparsed/sql/topRepositoriesByStars.out         | Bin 1231 -> 0 bytes
 .../sql/whatIsTheBestDayOfTheWeekToCatchAStar.out  | Bin 160 -> 0 bytes
 .../sql/whoAreAllThosePeopleGivingStars1.out       | Bin 733 -> 0 bytes
 .../sql/whoAreAllThosePeopleGivingStars2.out       | Bin 155 -> 0 bytes
 .../sql/whoAreAllThosePeopleGivingStars3.out       | Bin 1230 -> 0 bytes
 .../load.groovy                                    |  23 ++-
 .../sparsed/load.groovy                            | 196 ---------------------
 .../sparsed/sql/affinityByIssuesAndPRs1.sql        |  14 --
 .../sparsed/sql/affinityByIssuesAndPRs2.sql        |  14 --
 .../sparsed/sql/authorsWithTheMostPushes.sql       |   9 -
 .../sparsed/sql/countingStar1.sql                  |   1 -
 .../sparsed/sql/countingStar2.sql                  |   1 -
 .../sparsed/sql/countingStar3.sql                  |   1 -
 .../sql/distributionOfRepositoriesByStarCount.sql  |  14 --
 .../sparsed/sql/githubRoulette.sql                 |   1 -
 ...heListOfTopRepositoriesChangedOverTheYears1.sql |   1 -
 ...heListOfTopRepositoriesChangedOverTheYears2.sql |   1 -
 ...heListOfTopRepositoriesChangedOverTheYears3.sql |   1 -
 ...heListOfTopRepositoriesChangedOverTheYears4.sql |   1 -
 ...heListOfTopRepositoriesChangedOverTheYears5.sql |   1 -
 ...heListOfTopRepositoriesChangedOverTheYears6.sql |   1 -
 ...heListOfTopRepositoriesChangedOverTheYears7.sql |  30 ----
 .../howHasTheTotalNumberOfStarsChangedOverTime.sql |   2 -
 .../sparsed/sql/issuesWithTheMostComments1.sql     |   1 -
 .../sparsed/sql/issuesWithTheMostComments2.sql     |   1 -
 .../sparsed/sql/issuesWithTheMostComments3.sql     |  17 --
 .../sparsed/sql/issuesWithTheMostComments4.sql     |   9 -
 .../sparsed/sql/issuesWithTheMostComments5.sql     |   9 -
 .../sparsed/sql/issuesWithTheMostComments6.sql     |  11 --
 .../sparsed/sql/issuesWithTheMostComments7.sql     |   9 -
 .../sparsed/sql/issuesWithTheMostComments8.sql     |  13 --
 .../sparsed/sql/mostForkedRepositories.sql         |   1 -
 .../sparsed/sql/mostPopularCommentsOnGithub.sql    |   1 -
 .../sql/organizationsByTheNumberOfRepositories.sql |  14 --
 .../sql/organizationsByTheNumberOfStars.sql        |   8 -
 .../sql/organizationsByTheSizeOfCommunity.sql      |  23 ---
 .../sql/proportionsBetweenStarsAndForks1.sql       |  17 --
 .../sql/proportionsBetweenStarsAndForks2.sql       |  18 --
 .../sql/proportionsBetweenStarsAndForks3.sql       |  18 --
 .../sql/proportionsBetweenStarsAndForks4.sql       |  13 --
 .../sql/proportionsBetweenStarsAndForks5.sql       |  21 ---
 .../sql/repositoriesByAmountOfModifiedCode.sql     |  12 --
 .../sql/repositoriesByTheNumberOfPushes.sql        |  17 --
 ...epositoriesWithClickhouse_related_comments1.sql |   1 -
 ...epositoriesWithClickhouse_related_comments2.sql |  17 --
 .../repositoriesWithDoris_related_comments1.sql    |   1 -
 .../repositoriesWithDoris_related_comments2.sql    |  17 --
 .../sql/repositoriesWithTheHighestGrowthYoY.sql    |  20 ---
 .../repositoriesWithTheMaximumAmountOfIssues1.sql  |   1 -
 .../repositoriesWithTheMaximumAmountOfIssues2.sql  |  18 --
 .../repositoriesWithTheMaximumAmountOfIssues3.sql  |  19 --
 .../repositoriesWithTheMaximumAmountOfIssues4.sql  |  18 --
 ...sitoriesWithTheMaximumAmountOfPullRequests1.sql |   1 -
 ...sitoriesWithTheMaximumAmountOfPullRequests2.sql |   1 -
 ...esWithTheMaximumNumberOfAcceptedInvitations.sql |  17 --
 ...sitoriesWithTheMostPeopleWhoHavePushAccess1.sql |  13 --
 ...sitoriesWithTheMostPeopleWhoHavePushAccess2.sql |  13 --
 ...sitoriesWithTheMostPeopleWhoHavePushAccess3.sql |  16 --
 .../repositoriesWithTheMostStarsOverOneDay1.sql    |  25 ---
 .../repositoriesWithTheMostStarsOverOneDay2.sql    |  25 ---
 .../repositoriesWithTheMostStarsOverOneDay3.sql    |   1 -
 ...repositoriesWithTheMostSteadyGrowthOverTime.sql |  20 ---
 .../repositoriesWithTheWorstStagnation_order.sql   |  20 ---
 .../sparsed/sql/repositoryAffinityList1.sql        |  13 --
 .../sparsed/sql/repositoryAffinityList2.sql        |  23 ---
 .../sparsed/sql/starsFromHeavyGithubUsers1.sql     |  13 --
 .../sparsed/sql/starsFromHeavyGithubUsers2.sql     |  15 --
 .../sparsed/sql/theLongestRepositoryNames1.sql     |   1 -
 .../sparsed/sql/theLongestRepositoryNames2.sql     |   1 -
 .../sparsed/sql/theMostToughCodeReviews.sql        |  10 --
 .../sql/theTotalNumberOfRepositoriesOnGithub.sql   |   1 -
 .../sparsed/sql/theTotalNumberOfUsersOnGithub1.sql |   1 -
 .../sparsed/sql/theTotalNumberOfUsersOnGithub2.sql |   1 -
 .../sparsed/sql/theTotalNumberOfUsersOnGithub3.sql |   1 -
 .../sparsed/sql/theTotalNumberOfUsersOnGithub4.sql |   1 -
 .../sparsed/sql/topLabels1.sql                     |   9 -
 .../sparsed/sql/topLabels2.sql                     |   9 -
 .../sparsed/sql/topLabels3.sql                     |  14 --
 .../sparsed/sql/topRepositoriesByStars.sql         |   1 -
 .../sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql  |   1 -
 .../sql/whoAreAllThosePeopleGivingStars1.sql       |   1 -
 .../sql/whoAreAllThosePeopleGivingStars2.sql       |   1 -
 .../sql/whoAreAllThosePeopleGivingStars3.sql       |  13 --
 145 files changed, 19 insertions(+), 920 deletions(-)

diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/load.out 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/load.out
deleted file mode 100644
index bd5ebc300a9..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/load.out and 
/dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/affinityByIssuesAndPRs1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/affinityByIssuesAndPRs1.out
deleted file mode 100644
index 4e3b7ce7d52..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/affinityByIssuesAndPRs1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/affinityByIssuesAndPRs2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/affinityByIssuesAndPRs2.out
deleted file mode 100644
index d825c035567..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/affinityByIssuesAndPRs2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/authorsWithTheMostPushes.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/authorsWithTheMostPushes.out
deleted file mode 100644
index 70f693578ca..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/authorsWithTheMostPushes.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/countingStar1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/countingStar1.out
deleted file mode 100644
index 633dfab5e1f..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/countingStar1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/countingStar2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/countingStar2.out
deleted file mode 100644
index 7658cd6fabe..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/countingStar2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/countingStar3.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/countingStar3.out
deleted file mode 100644
index 516eb9b7347..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/countingStar3.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/distributionOfRepositoriesByStarCount.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/distributionOfRepositoriesByStarCount.out
deleted file mode 100644
index ee8916c3a34..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/distributionOfRepositoriesByStarCount.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/githubRoulette.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/githubRoulette.out
deleted file mode 100644
index 6db73383708..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/githubRoulette.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
deleted file mode 100644
index a75f6cd87d2..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
deleted file mode 100644
index a510ce81ba1..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
deleted file mode 100644
index 8d2c9124159..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
deleted file mode 100644
index c23f409ba50..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
deleted file mode 100644
index 523224a060b..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
deleted file mode 100644
index 3c6e5bbe07f..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
deleted file mode 100644
index 3e777719e33..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments1.out
deleted file mode 100644
index b1db3f8a657..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments2.out
deleted file mode 100644
index c50a162b2d9..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments3.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments3.out
deleted file mode 100644
index f17b6c34936..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments3.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments4.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments4.out
deleted file mode 100644
index 737f2e33a41..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments4.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments5.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments5.out
deleted file mode 100644
index a4a6da943a5..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments5.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments6.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments6.out
deleted file mode 100644
index 57af3521197..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments6.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments7.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments7.out
deleted file mode 100644
index 1a3d9f653de..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments7.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/mostForkedRepositories.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/mostForkedRepositories.out
deleted file mode 100644
index f516dae1250..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/mostForkedRepositories.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/mostPopularCommentsOnGithub.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/mostPopularCommentsOnGithub.out
deleted file mode 100644
index a1a7da60a83..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/mostPopularCommentsOnGithub.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheNumberOfRepositories.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheNumberOfRepositories.out
deleted file mode 100644
index 661a376e030..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheNumberOfRepositories.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheNumberOfStars.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheNumberOfStars.out
deleted file mode 100644
index 1d8c3833bf9..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheNumberOfStars.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks1.out
deleted file mode 100644
index a188bf2ba95..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks2.out
deleted file mode 100644
index 75a95a6165e..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks3.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks3.out
deleted file mode 100644
index 6861250a12a..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks3.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks4.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks4.out
deleted file mode 100644
index 1d45fd3b9d4..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks4.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks5.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks5.out
deleted file mode 100644
index a0d029cf34a..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks5.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesByAmountOfModifiedCode.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesByAmountOfModifiedCode.out
deleted file mode 100644
index 7f81112ac71..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesByAmountOfModifiedCode.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesByTheNumberOfPushes.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesByTheNumberOfPushes.out
deleted file mode 100644
index a574b61a3df..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesByTheNumberOfPushes.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithClickhouse_related_comments1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithClickhouse_related_comments1.out
deleted file mode 100644
index 46e1f359ae2..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithClickhouse_related_comments1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithClickhouse_related_comments2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithClickhouse_related_comments2.out
deleted file mode 100644
index 66e1d07e448..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithClickhouse_related_comments2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithDoris_related_comments1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithDoris_related_comments1.out
deleted file mode 100644
index 7f4dbb909da..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithDoris_related_comments1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithDoris_related_comments2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithDoris_related_comments2.out
deleted file mode 100644
index c248e312e32..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithDoris_related_comments2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheHighestGrowthYoY.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheHighestGrowthYoY.out
deleted file mode 100644
index d436dae02bd..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheHighestGrowthYoY.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues1.out
deleted file mode 100644
index 9d395cfb85f..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues2.out
deleted file mode 100644
index 9bdf6536714..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues3.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues3.out
deleted file mode 100644
index 88c4f295960..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues3.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues4.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues4.out
deleted file mode 100644
index 805d935c55b..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues4.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfPullRequests1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfPullRequests1.out
deleted file mode 100644
index a3eec38c169..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfPullRequests1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
deleted file mode 100644
index 2f9adf408a5..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
deleted file mode 100644
index a2f35081cd9..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
deleted file mode 100644
index cd6c3f13fd9..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostStarsOverOneDay1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostStarsOverOneDay1.out
deleted file mode 100644
index 3f2bdf749f1..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostStarsOverOneDay1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostSteadyGrowthOverTime.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostSteadyGrowthOverTime.out
deleted file mode 100644
index 4afc1de3f9a..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostSteadyGrowthOverTime.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheWorstStagnation_order.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheWorstStagnation_order.out
deleted file mode 100644
index eaa089dd02d..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheWorstStagnation_order.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoryAffinityList1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoryAffinityList1.out
deleted file mode 100644
index bd05ae6ab5c..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoryAffinityList1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoryAffinityList2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoryAffinityList2.out
deleted file mode 100644
index 67482925cf8..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/repositoryAffinityList2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/starsFromHeavyGithubUsers1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/starsFromHeavyGithubUsers1.out
deleted file mode 100644
index bbe5da89e0f..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/starsFromHeavyGithubUsers1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/starsFromHeavyGithubUsers2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/starsFromHeavyGithubUsers2.out
deleted file mode 100644
index ea9bfe01652..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/starsFromHeavyGithubUsers2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theLongestRepositoryNames1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theLongestRepositoryNames1.out
deleted file mode 100644
index 026117bde52..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theLongestRepositoryNames1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theLongestRepositoryNames2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theLongestRepositoryNames2.out
deleted file mode 100644
index 36e3e58aafa..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theLongestRepositoryNames2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theMostToughCodeReviews.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theMostToughCodeReviews.out
deleted file mode 100644
index 6e6f3e7c130..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theMostToughCodeReviews.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfRepositoriesOnGithub.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfRepositoriesOnGithub.out
deleted file mode 100644
index 5b3c27542e4..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfRepositoriesOnGithub.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub1.out
deleted file mode 100644
index 9fc95405027..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub2.out
deleted file mode 100644
index 37b63bc00b8..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub3.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub3.out
deleted file mode 100644
index f3b520f20bf..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub3.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub4.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub4.out
deleted file mode 100644
index 11f9d28e41d..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub4.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/topRepositoriesByStars.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/topRepositoriesByStars.out
deleted file mode 100644
index 47450b19e5a..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/topRepositoriesByStars.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
deleted file mode 100644
index bc6d2c790e8..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars1.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars1.out
deleted file mode 100644
index ceb681760b9..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars1.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars2.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars2.out
deleted file mode 100644
index cf1765406f4..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars2.out
 and /dev/null differ
diff --git 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars3.out
 
b/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars3.out
deleted file mode 100644
index 5c7968ad126..00000000000
Binary files 
a/regression-test/data/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars3.out
 and /dev/null differ
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/load.groovy 
b/regression-test/suites/variant_github_events_index_type_p2/load.groovy
index 87316de2c07..7346ca82a7b 100644
--- a/regression-test/suites/variant_github_events_index_type_p2/load.groovy
+++ b/regression-test/suites/variant_github_events_index_type_p2/load.groovy
@@ -23,8 +23,19 @@ suite("test_variant_index_type_p2", "p2"){
     def delta_time = 1000
     def alter_res = "null"
     def useTime = 0
-    
-    sql """ set global_variant_enable_typed_paths_to_sparse = false """
+
+    def seed = Math.random()
+    def enable_typed_paths_to_sparse = true
+    if (seed < 0.5) {
+        sql """ set default_variant_enable_typed_paths_to_sparse = true """
+        logger.info("enable_typed_paths_to_sparse: true")
+        enable_typed_paths_to_sparse = true
+    } else {
+        sql """ set default_variant_enable_typed_paths_to_sparse = false """
+        logger.info("enable_typed_paths_to_sparse: false")
+        enable_typed_paths_to_sparse = false
+    }
+    sql "set enable_variant_flatten_nested = true"
     def wait_for_latest_op_on_table_finish = { table_name, OpTimeout ->
         for(int t = delta_time; t <= OpTimeout; t += delta_time){
             alter_res = sql """SHOW ALTER TABLE COLUMN WHERE TableName = 
"${table_name}" ORDER BY CreateTime DESC LIMIT 1;"""
@@ -150,7 +161,9 @@ suite("test_variant_index_type_p2", "p2"){
     sql """select v['payload']['commits'] from github_events2 order by k ;"""
     qt_sql """select count() from github_events2"""
     // query with inverted index
-    sql """ set enable_match_without_inverted_index = false """
+    if (!enable_typed_paths_to_sparse) {
+        sql """ set enable_match_without_inverted_index = false """
+    }
     qt_sql """select count()  from github_events2 where v["repo"]["name"] 
match 'xpressengine' """
     qt_sql """select count()  from github_events2 where v["repo"]["name"] 
match 'apache';"""
 
@@ -179,7 +192,9 @@ suite("test_variant_index_type_p2", "p2"){
         """
     sql """insert into github_events3 select * from github_events order by k"""
     // query with inverted index
-    sql """ set enable_match_without_inverted_index = false """
+    if (!enable_typed_paths_to_sparse) {
+        sql """ set enable_match_without_inverted_index = false """
+    }
     qt_sql """select count()  from github_events3 where v["repo"]["name"] 
match 'xpressengine' """
     qt_sql """select count()  from github_events3 where v["repo"]["name"] 
match 'apache';"""
 
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/load.groovy
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/load.groovy
deleted file mode 100644
index 87e40c5dd11..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/load.groovy
+++ /dev/null
@@ -1,196 +0,0 @@
-// Licensed to the Apache Software Foundation (ASF) under one
-// or more contributor license agreements.  See the NOTICE file
-// distributed with this work for additional information
-// regarding copyright ownership.  The ASF licenses this file
-// to you under the Apache License, Version 2.0 (the
-// "License"); you may not use this file except in compliance
-// with the License.  You may obtain a copy of the License at
-//
-//   http://www.apache.org/licenses/LICENSE-2.0
-//
-// Unless required by applicable law or agreed to in writing,
-// software distributed under the License is distributed on an
-// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-// KIND, either express or implied.  See the License for the
-// specific language governing permissions and limitations
-// under the License.
-
-import org.codehaus.groovy.runtime.IOGroovyMethods
-
-suite("typed_to_sparse", "nonConcurrent,p2"){
-    // prepare test table
-    def timeout = 300000
-    def delta_time = 1000
-    def alter_res = "null"
-    def useTime = 0
-    
-    sql """ set global_variant_enable_typed_paths_to_sparse = true """
-    def wait_for_latest_op_on_table_finish = { table_name, OpTimeout ->
-        for(int t = delta_time; t <= OpTimeout; t += delta_time){
-            alter_res = sql """SHOW ALTER TABLE COLUMN WHERE TableName = 
"${table_name}" ORDER BY CreateTime DESC LIMIT 1;"""
-            alter_res = alter_res.toString()
-            if(alter_res.contains("FINISHED")) {
-                sleep(10000) // wait change table state to normal
-                logger.info(table_name + " latest alter job finished, detail: 
" + alter_res)
-                break
-            }
-            useTime = t
-            sleep(delta_time)
-        }
-        assertTrue(useTime <= OpTimeout, "wait_for_latest_op_on_table_finish 
timeout")
-    }
-
-    def load_json_data = {table_name, file_name ->
-        // load the json data
-        streamLoad {
-            table "${table_name}"
-
-            // set http request header params
-            set 'read_json_by_line', 'true'
-            set 'format', 'json'
-            set 'max_filter_ratio', '0.1'
-            set 'memtable_on_sink_node', 'true'
-            file file_name // import json file
-            time 10000 // limit inflight 10s
-
-            // if declared a check callback, the default check condition will 
ignore.
-            // So you must check all condition
-
-            check { result, exception, startTime, endTime ->
-                if (exception != null) {
-                        throw exception
-                }
-                logger.info("Stream load ${file_name} result: 
${result}".toString())
-                def json = parseJson(result)
-                assertEquals("success", json.Status.toLowerCase())
-                // assertEquals(json.NumberTotalRows, json.NumberLoadedRows + 
json.NumberUnselectedRows)
-                assertTrue(json.NumberLoadedRows > 0 && json.LoadBytes > 0)
-            }
-        }
-    }
-
-    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)) + 
400
-    // int rand_subcolumns_count = 0;
-    sql """
-        CREATE TABLE IF NOT EXISTS ${table_name} (
-            k bigint,
-            v variant<
-                MATCH_NAME 'repo.name' : string,
-                MATCH_NAME 'payload.pull_request.additions' : int,
-                MATCH_NAME 'actor.login' : string,
-                MATCH_NAME 'type' : string,
-                MATCH_NAME 'payload.action' : string,
-                MATCH_NAME 'created_at' : datetime,
-                MATCH_NAME 'payload.issue.number' : int,
-                MATCH_NAME 'payload.comment.body' : string,
-                MATCH_NAME 'type.name' : string,
-                properties("variant_max_subcolumns_count" = 
"${rand_subcolumns_count}")
-            > NULL,
-            INDEX idx_var (`v`) USING INVERTED PROPERTIES("parser" = 
"english", "support_phrase" = "true")
-        )
-        DUPLICATE KEY(`k`)
-        DISTRIBUTED BY HASH(k) BUCKETS 4 
-        properties("replication_num" = "1", "disable_auto_compaction" = 
"true", "variant_enable_flatten_nested" = "false");
-    """
-    
-    // 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'}""")
-    load_json_data.call(table_name, """${getS3Url() + 
'/regression/gharchive.m/2015-01-01-2.json'}""")
-    load_json_data.call(table_name, """${getS3Url() + 
'/regression/gharchive.m/2015-01-01-3.json'}""")
-
-    // // // 2022
-    load_json_data.call(table_name, """${getS3Url() + 
'/regression/gharchive.m/2022-11-07-16.json'}""")
-    load_json_data.call(table_name, """${getS3Url() + 
'/regression/gharchive.m/2022-11-07-10.json'}""")
-    load_json_data.call(table_name, """${getS3Url() + 
'/regression/gharchive.m/2022-11-07-22.json'}""")
-    load_json_data.call(table_name, """${getS3Url() + 
'/regression/gharchive.m/2022-11-07-23.json'}""")
-
-    // // // add bloom filter at the end of loading data
-
-    // def tablets = sql_return_maparray """ show tablets from github_events; 
"""
-    // // trigger compactions for all tablets in github_events
-    trigger_and_wait_compaction("github_events", "cumulative")
-
-    sql """set enable_match_without_inverted_index = false"""
-    sql """ set enable_common_expr_pushdown = true """
-    // filter by bloom filter
-    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,
-            v variant<
-                MATCH_NAME 'repo.name' : string,
-                MATCH_NAME 'payload.pull_request.additions' : int,
-                MATCH_NAME 'actor.login' : string,
-                MATCH_NAME 'type' : string,
-                MATCH_NAME 'payload.action' : string,
-                MATCH_NAME 'created_at' : datetime,
-                MATCH_NAME 'payload.issue.number' : int,
-                MATCH_NAME 'payload.comment.body' : string,
-                MATCH_NAME 'type.name' : string,
-                properties("variant_max_subcolumns_count" = 
"${rand_subcolumns_count}")
-            > null,
-            INDEX idx_repo_name(v) USING INVERTED PROPERTIES("parser" = 
"english", "field_pattern" = "repo.name") COMMENT ''
-        )
-        UNIQUE KEY(`k`)
-        DISTRIBUTED BY HASH(k) BUCKETS 4 
-        properties("replication_num" = "1", "disable_auto_compaction" = 
"false", "variant_enable_flatten_nested" = "false", "bloom_filter_columns" = 
"v");
-        """
-    sql """insert into github_events2 select * from github_events order by k"""
-    sql """select v['payload']['commits'] from github_events order by k ;"""
-    sql """select v['payload']['commits'] from github_events2 order by k ;"""
-    qt_sql """select count() from github_events2"""
-
-
-    sql "DROP TABLE IF EXISTS github_events3"
-    sql """
-     CREATE TABLE IF NOT EXISTS github_events3 (
-            k bigint,
-            v variant<
-                MATCH_NAME 'repo.name' : string,
-                MATCH_NAME 'payload.pull_request.additions' : int,
-                MATCH_NAME 'actor.login' : string,
-                MATCH_NAME 'type' : string,
-                MATCH_NAME 'payload.action' : string,
-                MATCH_NAME 'created_at' : datetime,
-                MATCH_NAME 'payload.issue.number' : int,
-                MATCH_NAME 'payload.comment.body' : string,
-                MATCH_NAME 'type.name' : string,
-                properties("variant_max_subcolumns_count" = 
"${rand_subcolumns_count}")
-            > null,
-            INDEX idx_repo_name(v) USING INVERTED PROPERTIES("parser" = 
"english", "field_pattern" = "repo.name") COMMENT ''
-        )
-        DUPLICATE KEY(`k`)
-        DISTRIBUTED BY HASH(k) BUCKETS 4 
-        properties("replication_num" = "1", "disable_auto_compaction" = 
"false", "variant_enable_flatten_nested" = "false", "bloom_filter_columns" = 
"v");
-        """
-    sql """insert into github_events3 select * from github_events order by k"""
-    qt_sql """select * from github_events3 where  cast(v["repo"]["name"] as 
string) = 'xpressengine/xe-core' order by 1 limit 10"""
-
-    sql """ drop table if exists github_events4 """
-    sql """ create table github_events4 like github_events """
-    sql """ insert into github_events4 select * from github_events order by k 
"""
-    sql """ drop table github_events """
-    sql """ alter table github_events4 rename github_events """
-    sql """ alter table github_events set ("bloom_filter_columns" = "v"); """
-    waitForSchemaChangeDone {
-        sql """ SHOW ALTER TABLE COLUMN WHERE TableName='github_events' ORDER 
BY createtime DESC LIMIT 1 """
-        time 600
-    }
-
-    qt_sql """select * from github_events where  cast(v["repo"]["name"] as 
string) = 'xpressengine/xe-core' order by 1 limit 10"""
-
-    // specify schema
-    // sql "alter table github_events2 modify column v 
variant<`payload.comment.id`:int,`payload.commits.url`:text,`payload.forkee.has_pages`:tinyint>"
-    // load_json_data.call("github_events2", """${getS3Url() + 
'/regression/gharchive.m/2022-11-07-23.json'}""")
-    // qt_sql "select * from github_events2 WHERE 1=1  ORDER BY k DESC LIMIT 
10"
-    // qt_sql "select v['payload']['commits'] from github_events2 WHERE 1=1  
ORDER BY k DESC LIMIT 10"
-    // qt_sql "select v['payload']['commits']['url'] from github_events2 WHERE 
1=1  ORDER BY k DESC LIMIT 10"
-}
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/affinityByIssuesAndPRs1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/affinityByIssuesAndPRs1.sql
deleted file mode 100644
index 55c3589753f..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/affinityByIssuesAndPRs1.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-SELECT
-    cast(v["repo"]["name"] as string),
-    count() AS prs,
-    count(distinct cast(v["actor"]["login"] as string)) AS authors
-FROM github_events
-WHERE (cast(v["type"] as string) = 'PullRequestEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened') AND 
(cast(v["actor"]["login"] as string) IN
-(
-    SELECT cast(v["actor"]["login"] as string)
-    FROM github_events
-    WHERE (cast(v["type"] as string) = 'PullRequestEvent') AND 
(cast(v["payload"]["action"] as string)= 'opened') AND (cast(v["repo"]["name"] 
as string) IN ('rspec/rspec-core', 'golden-warning/giraffedraft-server', 
'apache/spark'))
-)) AND (lower(cast(v["repo"]["name"] as string)) NOT LIKE '%clickhouse%')
-GROUP BY cast(v["repo"]["name"] as string)
-ORDER BY authors DESC, prs DESC, cast(v["repo"]["name"] as string) DESC
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/affinityByIssuesAndPRs2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/affinityByIssuesAndPRs2.sql
deleted file mode 100644
index e9158f8246b..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/affinityByIssuesAndPRs2.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-SELECT
-    cast(v["repo"]["name"] as string),
-    count() AS prs,
-    count(distinct cast(v["actor"]["login"] as string)) AS authors
-FROM github_events
-WHERE (cast(v["type"] as string) = 'IssuesEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened') AND 
(cast(v["actor"]["login"] as string) IN
-(
-    SELECT cast(v["actor"]["login"] as string)
-    FROM github_events
-    WHERE (cast(v["type"] as string) = 'IssuesEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened') AND (cast(v["repo"]["name"] 
as string) IN ('No-CQRT/GooGuns', 'ivolunteerph/ivolunteerph', 
'Tribler/tribler'))
-)) AND (lower(cast(v["repo"]["name"] as string)) NOT LIKE '%clickhouse%')
-GROUP BY cast(v["repo"]["name"] as string)
-ORDER BY authors DESC, prs DESC, cast(v["repo"]["name"] as string) ASC
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/authorsWithTheMostPushes.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/authorsWithTheMostPushes.sql
deleted file mode 100644
index 2e8bf320098..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/authorsWithTheMostPushes.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-SELECT
-      cast(v["actor"]["login"] as string),
-      count() AS c,
-      count(distinct cast(v["repo"]["name"] as string)) AS repos
-  FROM github_events
-  WHERE cast(v["type"] as string) = 'PushEvent'
-  GROUP BY cast(v["actor"]["login"] as string)
-  ORDER BY c DESC, 1, 3
-  LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/countingStar1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/countingStar1.sql
deleted file mode 100644
index 8b2d615acd0..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/countingStar1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT count() FROM github_events WHERE cast(v["type"] as string) = 
'WatchEvent'
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/countingStar2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/countingStar2.sql
deleted file mode 100644
index 057a410e0ca..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/countingStar2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["payload"]["action"] as string), count() FROM github_events 
WHERE cast(v["type"] as string) = 'WatchEvent' GROUP BY 
cast(v["payload"]["action"] as string) 
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/countingStar3.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/countingStar3.sql
deleted file mode 100644
index 9b5f4128890..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/countingStar3.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT count() FROM github_events WHERE cast(v["type"] as string) = 
'WatchEvent' AND cast(v["repo"]["name"] as string) IN ('apache/spark', 
'GunZi200/Memory-Colour', 'isohuntto/openbay', 'wasabeef/awesome-android-ui') 
GROUP BY cast(v["payload"]["action"] as string)  
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/distributionOfRepositoriesByStarCount.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/distributionOfRepositoriesByStarCount.sql
deleted file mode 100644
index e2d987afe65..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/distributionOfRepositoriesByStarCount.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-SELECT
-    pow(10, floor(log10(c))) AS stars,
-    count(distinct k)
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as k,
-        count() AS c
-    FROM github_events
-    WHERE cast(v["type"] as string) = 'WatchEvent'
-    GROUP BY cast(v["repo"]["name"] as string)
-) t
-GROUP BY stars
-ORDER BY stars ASC
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/githubRoulette.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/githubRoulette.sql
deleted file mode 100644
index 0b9ea42f77d..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/githubRoulette.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string) FROM github_events WHERE 
cast(v["type"] as string) = 'WatchEvent' ORDER BY cast(v["created_at"] as 
datetime),  cast(v["repo"]["name"] as string) LIMIT 50
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
deleted file mode 100644
index 95389cb9a06..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() AS stars FROM github_events 
WHERE cast(v["type"] as string) = 'WatchEvent' AND year(cast(v["created_at"] as 
datetime)) = '2015' GROUP BY cast(v["repo"]["name"] as string) ORDER BY stars 
DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
deleted file mode 100644
index 95389cb9a06..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() AS stars FROM github_events 
WHERE cast(v["type"] as string) = 'WatchEvent' AND year(cast(v["created_at"] as 
datetime)) = '2015' GROUP BY cast(v["repo"]["name"] as string) ORDER BY stars 
DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
deleted file mode 100644
index 67b5d0d3d18..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() AS stars FROM github_events 
WHERE cast(v["type"] as string) = 'WatchEvent' AND year(cast(v["created_at"] as 
datetime)) = '2015' GROUP BY cast(v["repo"]["name"] as string) ORDER BY stars, 
cast(v["repo"]["name"] as string) DESC LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
deleted file mode 100644
index 95389cb9a06..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() AS stars FROM github_events 
WHERE cast(v["type"] as string) = 'WatchEvent' AND year(cast(v["created_at"] as 
datetime)) = '2015' GROUP BY cast(v["repo"]["name"] as string) ORDER BY stars 
DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
deleted file mode 100644
index 95389cb9a06..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() AS stars FROM github_events 
WHERE cast(v["type"] as string) = 'WatchEvent' AND year(cast(v["created_at"] as 
datetime)) = '2015' GROUP BY cast(v["repo"]["name"] as string) ORDER BY stars 
DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
deleted file mode 100644
index 95389cb9a06..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() AS stars FROM github_events 
WHERE cast(v["type"] as string) = 'WatchEvent' AND year(cast(v["created_at"] as 
datetime)) = '2015' GROUP BY cast(v["repo"]["name"] as string) ORDER BY stars 
DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
deleted file mode 100644
index ee2fbef43b3..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
+++ /dev/null
@@ -1,30 +0,0 @@
--- FIXME: UNSTABLE
--- SELECT
---     repo,
---     year,
---     cnt
--- FROM
--- (
---     SELECT
---         row_number() OVER (PARTITION BY year ORDER BY cnt DESC) AS r,
---         repo,
---         year,
---         cnt
---     FROM
---     (
---         SELECT
---         lower(cast(v["repo"]["name"] as string)) AS repo,
---         year(cast(v["created_at"] as datetime)) AS year,
---         count() AS cnt
---         FROM github_events
---         WHERE (cast(v["type"] as string) = 'WatchEvent') AND 
(year(cast(v["created_at"] as datetime)) >= 2015)
---         GROUP BY
---             repo,
---             year
---     ) t
--- ) t2
--- WHERE r <= 10
--- ORDER BY
---     year ASC,
---     cnt DESC, repo
--- 
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheTotalNumberOfStarsChangedOverTime.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheTotalNumberOfStarsChangedOverTime.sql
deleted file mode 100644
index 5291ab51006..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/howHasTheTotalNumberOfStarsChangedOverTime.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-SELECT year(cast(v["created_at"] as datetime)) AS year, count() AS stars FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' GROUP BY year 
ORDER BY year
-
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments1.sql
deleted file mode 100644
index 0117055d53e..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT count() FROM github_events WHERE cast(v["type"] as string) = 
'IssueCommentEvent'
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments2.sql
deleted file mode 100644
index 25e96fe731e..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() FROM github_events WHERE 
cast(v["type"] as string) = 'IssueCommentEvent' GROUP BY cast(v["repo"]["name"] 
as string) ORDER BY count() DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments3.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments3.sql
deleted file mode 100644
index c32210845e3..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments3.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT
-    repo_name,
-    comments,
-    issues,
-    round(comments / issues, 2) AS ratio
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        count() AS comments,
-        count(distinct cast(v["payload"]["issue"]["number"] as int)) AS issues
-    FROM github_events
-    WHERE cast(v["type"] as string) = 'IssueCommentEvent'
-    GROUP BY cast(v["repo"]["name"] as string)
-) t
-ORDER BY comments DESC, 1, 3, 4
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments4.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments4.sql
deleted file mode 100644
index ad8e5c104cc..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments4.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-SELECT
-    cast(v["repo"]["name"] as string),
-    cast(v["payload"]["issue"]["number"] as int)  as number,
-    count() AS comments
-FROM github_events
-WHERE cast(v["type"] as string) = 'IssueCommentEvent' AND 
(cast(v["payload"]["action"] as string) = 'created')
-GROUP BY cast(v["repo"]["name"] as string), number 
-ORDER BY comments DESC, number ASC, 1
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments5.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments5.sql
deleted file mode 100644
index 0520ed0b8dc..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments5.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-SELECT
-    cast(v["repo"]["name"] as string),
-    cast(v["payload"]["issue"]["number"] as int)  as number,
-    count() AS comments
-FROM github_events
-WHERE cast(v["type"] as string) = 'IssueCommentEvent' AND 
(cast(v["payload"]["action"] as string) = 'created') AND 
(cast(v["payload"]["issue"]["number"] as int)  > 10)
-GROUP BY cast(v["repo"]["name"] as string), number
-ORDER BY comments DESC, cast(v["repo"]["name"] as string), number
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments6.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments6.sql
deleted file mode 100644
index edab4d50e26..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments6.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-SELECT
-    cast(v["repo"]["name"] as string),
-    cast(v["payload"]["issue"]["number"] as int)  as number,
-    count() AS comments,
-    count(distinct cast(v["actor"]["login"] as string)) AS authors
-FROM github_events
-WHERE cast(v["type"] as string) = 'IssueCommentEvent' AND 
(cast(v["payload"]["action"] as string) = 'created') AND 
(cast(v["payload"]["issue"]["number"] as int) > 10)
-GROUP BY cast(v["repo"]["name"] as string), number
-HAVING authors >= 4
-ORDER BY comments DESC, cast(v["repo"]["name"] as string)
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments7.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments7.sql
deleted file mode 100644
index 047f2d7a1d4..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments7.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-SELECT
-    cast(v["repo"]["name"] as string),
-    count() AS comments,
-    count(distinct cast(v["actor"]["login"] as string)) AS authors
-FROM github_events
-WHERE cast(v["type"] as string) = 'CommitCommentEvent'
-GROUP BY cast(v["repo"]["name"] as string)
-ORDER BY count() DESC, 1, 3
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments8.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments8.sql
deleted file mode 100644
index e6890c1e235..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/issuesWithTheMostComments8.sql
+++ /dev/null
@@ -1,13 +0,0 @@
--- SELECT
---     concat('https://github.com/', cast(v["repo"]["name"] as string), 
'/commit/', cast(v["payload"]["commit_id"] as string)) URL,
---     cast(v["payload"]["commit_id"] as string) AS commit_id,
---     count() AS comments,
---     count(distinct cast(v["actor"]["login"] as string)) AS authors
--- FROM github_events
--- WHERE (cast(v["type"] as string) = 'CommitCommentEvent') AND commit_id != ""
--- GROUP BY
---     cast(v["repo"]["name"] as string),
---     commit_id 
--- HAVING authors >= 10
--- ORDER BY count() DESC, URL, authors
--- LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/mostForkedRepositories.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/mostForkedRepositories.sql
deleted file mode 100644
index aab10cb7933..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/mostForkedRepositories.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() AS forks FROM github_events 
WHERE cast(v["type"] as string) = 'ForkEvent' GROUP BY cast(v["repo"]["name"] 
as string) ORDER BY forks DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/mostPopularCommentsOnGithub.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/mostPopularCommentsOnGithub.sql
deleted file mode 100644
index c36efe7561b..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/mostPopularCommentsOnGithub.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["payload"]["comment"]["body"] as string), count() FROM 
github_events WHERE cast(v["payload"]["comment"]["body"] as string) != "" AND 
length(cast(v["payload"]["comment"]["body"] as string)) < 100 GROUP BY 
cast(v["payload"]["comment"]["body"] as string)  ORDER BY count(), 1 DESC LIMIT 
50
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheNumberOfRepositories.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheNumberOfRepositories.sql
deleted file mode 100644
index d943c07de6a..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheNumberOfRepositories.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-SELECT
-    lower(split_part(repo_name, '/', 1)) AS org,
-    count(distinct repo_name) AS repos
-FROM
-(
-    SELECT cast(v["repo"]["name"] as string) as repo_name
-    FROM github_events
-    WHERE cast(v["type"] as string) = 'WatchEvent'
-    GROUP BY cast(v["repo"]["name"] as string)
-    HAVING count() >= 10
-) t
-GROUP BY org
-ORDER BY repos DESC, org ASC
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheNumberOfStars.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheNumberOfStars.sql
deleted file mode 100644
index 22f0a8cbba7..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheNumberOfStars.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-SELECT
-    lower(split_part(cast(v["repo"]["name"] as string), '/', 1)) AS org,
-    count() AS stars
-FROM github_events
-WHERE cast(v["type"] as string) = 'WatchEvent'
-GROUP BY org
-ORDER BY stars DESC, 1
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheSizeOfCommunity.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheSizeOfCommunity.sql
deleted file mode 100644
index e445e7db3e9..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/organizationsByTheSizeOfCommunity.sql
+++ /dev/null
@@ -1,23 +0,0 @@
--- SELECT
---     lower(split_part(cast(v["repo"]["name"] as string), '/', 1)) AS org,
---     count(distinct cast(v["actor"]["login"] as string)) AS authors,
---     count(distinct pr_author) AS pr_authors,
---     count(distinct issue_author) AS issue_authors,
---     count(distinct comment_author) AS comment_authors,
---     count(distinct review_author) AS review_authors,
---     count(distinct push_author) AS push_authors
--- FROM
--- (
--- SELECT
---     cast(v["repo"]["name"] as string),
---     cast(v["actor"]["login"] as string),
---     CASE WHEN cast(v["type"] as string) = 'PullRequestEvent' THEN 
cast(v["actor"]["login"] as string) ELSE NULL END pr_author,
---     CASE WHEN cast(v["type"] as string) = 'IssuesEvent' THEN 
cast(v["actor"]["login"] as string) ELSE NULL END issue_author,
---     CASE WHEN cast(v["type"] as string) = 'IssueCommentEvent' THEN 
cast(v["actor"]["login"] as string) ELSE NULL END comment_author,
---     CASE WHEN cast(v["type"] as string) = 'PullRequestReviewCommentEvent' 
THEN cast(v["actor"]["login"] as string) ELSE NULL END review_author,
---     CASE WHEN cast(v["type"] as string) = 'PushEvent' THEN 
cast(v["actor"]["login"] as string) ELSE NULL END push_author
--- FROM github_events
--- WHERE cast(v["type"] as string) IN ('PullRequestEvent', 'IssuesEvent', 
'IssueCommentEvent', 'PullRequestReviewCommentEvent', 'PushEvent')
--- ) t
--- GROUP BY org
--- ORDER BY authors DESC
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks1.sql
deleted file mode 100644
index 65ab889b251..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks1.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT
-    repo_name,
-    sum(fork) AS forks,
-    sum(star) AS stars,
-    round(sum(star) / sum(fork), 3) AS ratio
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        CASE WHEN cast(v["type"] as string) = 'ForkEvent' THEN 1 ELSE 0 END AS 
fork,
-        CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 END 
AS star
-    FROM github_events
-    WHERE cast(v["type"] as string) IN ('ForkEvent', 'WatchEvent')
-) t
-GROUP BY repo_name
-ORDER BY forks DESC, 1, 3, 4
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks2.sql
deleted file mode 100644
index ffff95dfdc6..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks2.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-SELECT
-    repo_name,
-    sum(fork) AS forks,
-    sum(star) AS stars,
-    round(sum(star) / sum(fork), 3) AS ratio
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        CASE WHEN cast(v["type"] as string) = 'ForkEvent' THEN 1 ELSE 0 END AS 
fork,
-        CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 END 
AS star
-    FROM github_events
-    WHERE cast(v["type"] as string) IN ('ForkEvent', 'WatchEvent')
-) t
-GROUP BY  repo_name 
-HAVING (stars > 20) AND (forks >= 10)
-ORDER BY ratio DESC, repo_name 
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks3.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks3.sql
deleted file mode 100644
index f47c5163302..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks3.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-SELECT
-    repo_name,
-    sum(fork) AS forks,
-    sum(star) AS stars,
-    round(sum(fork) / sum(star), 2) AS ratio
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        CASE WHEN cast(v["type"] as string) = 'ForkEvent' THEN 1 ELSE 0 END AS 
fork,
-        CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 END 
AS star
-    FROM github_events
-    WHERE cast(v["type"] as string) IN ('ForkEvent', 'WatchEvent')
-) t
-GROUP BY repo_name
-HAVING (stars > 4) AND (forks > 4)
-ORDER BY ratio DESC
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks4.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks4.sql
deleted file mode 100644
index 66c67db1b86..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks4.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-SELECT
-    sum(fork) AS forks,
-    sum(star) AS stars,
-    round(sum(star) / sum(fork), 2) AS ratio
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string),
-        CASE WHEN cast(v["type"] as string) = 'ForkEvent' THEN 1 ELSE 0 END AS 
fork,
-        CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 END 
AS star
-    FROM github_events
-    WHERE cast(v["type"] as string) IN ('ForkEvent', 'WatchEvent')
-) t
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks5.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks5.sql
deleted file mode 100644
index 3579b794114..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/proportionsBetweenStarsAndForks5.sql
+++ /dev/null
@@ -1,21 +0,0 @@
-SELECT
-    sum(forks) AS forks,
-    sum(stars) AS stars,
-    round(sum(stars) / sum(forks), 2) AS ratio
-FROM
-(
-    SELECT
-        sum(fork) AS forks,
-        sum(star) AS stars
-    FROM
-    (
-        SELECT
-            cast(v["repo"]["name"] as string) as repo_name,
-            CASE WHEN cast(v["type"] as string) = 'ForkEvent' THEN 1 ELSE 0 
END AS fork,
-            CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 
END AS star
-        FROM github_events
-        WHERE cast(v["type"] as string) IN ('ForkEvent', 'WatchEvent')
-    ) t
-    GROUP BY repo_name
-    HAVING stars > 10
-) t2
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesByAmountOfModifiedCode.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesByAmountOfModifiedCode.sql
deleted file mode 100644
index 6c1632769f3..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesByAmountOfModifiedCode.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-SELECT 
/*+SET_VAR(enable_fallback_to_original_planner=false,disable_streaming_preaggregations=false)
 */
-    cast(v["repo"]["name"] as string) as repo_name,
-    count() AS prs,
-    count(distinct cast(v["actor"]["login"] as string)) AS authors,
-    sum(cast(v["payload"]["pull_request"]["additions"] as int)) AS adds,
-    sum(cast(v["payload"]["pull_request"]["deletions"] as int)) AS dels
-FROM github_events
-WHERE (cast(v["type"] as string) = 'PullRequestEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened') AND 
(cast(v["payload"]["pull_request"]["additions"] as int) < 10000) AND 
(cast(v["payload"]["pull_request"]["deletions"] as int) < 10000)
-GROUP BY repo_name
-HAVING (adds / dels) < 10
-ORDER BY adds + dels DESC, 1
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesByTheNumberOfPushes.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesByTheNumberOfPushes.sql
deleted file mode 100644
index e37ced40838..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesByTheNumberOfPushes.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT
-    cast(v["repo"]["name"] as string),
-    count() AS pushes,
-    count(distinct cast(v["actor"]["login"] as string)) AS authors
-FROM github_events
-WHERE (cast(v["type"] as string) = 'PushEvent') AND (cast(v["repo"]["name"] as 
string) IN
-(
-    SELECT cast(v["repo"]["name"] as string)
-    FROM github_events
-    WHERE cast(v["type"] as string) = 'WatchEvent'
-    GROUP BY cast(v["repo"]["name"] as string)
-    ORDER BY count() DESC
-    LIMIT 10000
-))
-GROUP BY cast(v["repo"]["name"] as string)
-ORDER BY count() DESC, cast(v["repo"]["name"] as string)
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithClickhouse_related_comments1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithClickhouse_related_comments1.sql
deleted file mode 100644
index 1dba0577e78..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithClickhouse_related_comments1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() FROM github_events WHERE 
lower(cast(v["payload"]["comment"]["body"] as string)) LIKE '%apache%' GROUP BY 
cast(v["repo"]["name"] as string) ORDER BY count() DESC, cast(v["repo"]["name"] 
as string) ASC LIMIT 50
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithClickhouse_related_comments2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithClickhouse_related_comments2.sql
deleted file mode 100644
index 15b5adf3fb2..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithClickhouse_related_comments2.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT
-    repo_name,
-    sum(num_star) AS num_stars,
-    sum(num_comment) AS num_comments
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 END 
AS num_star,
-        CASE WHEN lower(cast(v["payload"]["comment"]["body"] as string)) LIKE 
'%apache%' THEN 1 ELSE 0 END AS num_comment
-    FROM github_events
-    WHERE (lower(cast(v["payload"]["comment"]["body"] as string)) LIKE 
'%apache%') OR (cast(v["type"] as string) = 'WatchEvent')
-) t
-GROUP BY repo_name 
-HAVING num_comments > 0
-ORDER BY num_stars DESC,num_comments DESC, repo_name ASC
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithDoris_related_comments1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithDoris_related_comments1.sql
deleted file mode 100644
index 15f7de0c3b9..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithDoris_related_comments1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() FROM github_events WHERE 
lower(cast(v["payload"]["comment"]["body"] as string)) LIKE '%spark%' GROUP BY 
cast(v["repo"]["name"] as string) ORDER BY count() DESC, cast(v["repo"]["name"] 
as string) ASC LIMIT 50
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithDoris_related_comments2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithDoris_related_comments2.sql
deleted file mode 100644
index 17a055f6549..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithDoris_related_comments2.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT
-    repo_name,
-    sum(num_star) AS num_stars,
-    sum(num_comment) AS num_comments
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 END 
AS num_star,
-        CASE WHEN lower(cast(v["payload"]["comment"]["body"] as string)) LIKE 
'%spark%' THEN 1 ELSE 0 END AS num_comment
-    FROM github_events
-    WHERE (lower(cast(v["payload"]["comment"]["body"] as string)) LIKE 
'%spark%') OR (cast(v["type"] as string) = 'WatchEvent')
-) t
-GROUP BY repo_name
-HAVING num_comments > 0
-ORDER BY num_stars DESC,num_comments DESC,repo_name ASC
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheHighestGrowthYoY.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheHighestGrowthYoY.sql
deleted file mode 100644
index b5270ee38f1..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheHighestGrowthYoY.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-SELECT
-    repo_name,
-    sum(created_at_2022) AS stars2022,
-    sum(created_at_2015) AS stars2015,
-    round(sum(created_at_2022) / sum(created_at_2015), 3) AS yoy,
-    min(created_at) AS first_seen
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        CASE year(cast(v["created_at"] as datetime)) WHEN 2022 THEN 1 ELSE 0 
END AS created_at_2022,
-        CASE year(cast(v["created_at"] as datetime)) WHEN 2015 THEN 1 ELSE 0 
END AS created_at_2015,
-        cast(v["created_at"] as datetime) as created_at
-    FROM github_events
-    WHERE cast(v["type"] as string) = 'WatchEvent'
-) t
-GROUP BY  repo_name 
-HAVING (min(created_at) <= '2023-01-01 00:00:00') AND (stars2022 >= 1) and 
(stars2015 >= 1)
-ORDER BY yoy DESC, repo_name 
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
deleted file mode 100644
index 93164a4cfe1..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() AS c, count(distinct 
cast(v["actor"]["login"] as string)) AS u FROM github_events WHERE 
cast(v["type"] as string) = 'IssuesEvent' AND cast(v["payload"]["action"] as 
string) = 'opened' GROUP BY cast(v["repo"]["name"] as string) ORDER BY c DESC, 
cast(v["repo"]["name"] as string) LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
deleted file mode 100644
index cfddc738371..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-SELECT
-    repo_name,
-    sum(issue_created) AS c,
-    count(distinct actor_login) AS u,
-    sum(star) AS stars
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        CASE WHEN (cast(v["type"] as string) = 'IssuesEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened') THEN 1 ELSE 0 END AS 
issue_created,
-        CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 END 
AS star,
-        CASE WHEN (cast(v["type"] as string) = 'IssuesEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened') THEN 
cast(v["actor"]["login"] as string) ELSE NULL END AS actor_login 
-    FROM github_events
-    WHERE cast(v["type"] as string) IN ('IssuesEvent', 'WatchEvent')
-) t
-GROUP BY repo_name
-ORDER BY c DESC, repo_name
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues3.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues3.sql
deleted file mode 100644
index 60759a10199..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues3.sql
+++ /dev/null
@@ -1,19 +0,0 @@
-SELECT
-    repo_name,
-    sum(issue_created) AS c,
-    count(distinct actor_login) AS u,
-    sum(star) AS stars
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        CASE WHEN (cast(v["type"] as string) = 'IssuesEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened') THEN 1 ELSE 0 END AS 
issue_created,
-        CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 END 
AS star,
-        CASE WHEN (cast(v["type"] as string) = 'IssuesEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened') THEN 
cast(v["actor"]["login"] as string) ELSE NULL END AS actor_login 
-    FROM github_events
-    WHERE cast(v["type"] as string) IN ('IssuesEvent', 'WatchEvent')
-) t
-GROUP BY repo_name
-HAVING stars >= 10
-ORDER BY c, u, stars DESC, repo_name
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues4.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues4.sql
deleted file mode 100644
index 756e6f6bd95..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfIssues4.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-SELECT
-    repo_name,
-    sum(issue_created) AS c,
-    count(distinct actor_login) AS u,
-    sum(star) AS stars
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        CASE WHEN (cast(v["type"] as string) = 'IssuesEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened') THEN 1 ELSE 0 END AS 
issue_created,
-        CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 END 
AS star,
-        CASE WHEN (cast(v["type"] as string) = 'IssuesEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened') THEN 
cast(v["actor"]["login"] as string) ELSE NULL END AS actor_login 
-    FROM github_events
-    WHERE cast(v["type"] as string) IN ('IssuesEvent', 'WatchEvent')
-) t
-GROUP BY repo_name
-ORDER BY u, c, stars DESC, 1
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfPullRequests1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfPullRequests1.sql
deleted file mode 100644
index f0c50521063..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfPullRequests1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string) as repo_name, count(), count(distinct 
cast(v["actor"]["login"] as string)) FROM github_events WHERE cast(v["type"] as 
string) = 'PullRequestEvent' AND cast(v["payload"]["action"] as string) = 
'opened' GROUP BY cast(v["repo"]["name"] as string) ORDER BY 2,1,3 DESC LIMIT 50
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfPullRequests2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfPullRequests2.sql
deleted file mode 100644
index bba2a4c8981..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumAmountOfPullRequests2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count(), count(distinct 
cast(v["actor"]["login"] as string)) AS u FROM github_events WHERE 
cast(v["type"] as string) = 'PullRequestEvent' AND cast(v["payload"]["action"] 
as string) = 'opened' GROUP BY cast(v["repo"]["name"] as string) ORDER BY u 
DESC, 2 DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
deleted file mode 100644
index 36aa448c66a..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT
-    repo_name,
-    sum(invitation) AS invitations,
-    sum(star) AS stars
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        CASE WHEN cast(v["type"] as string) = 'MemberEvent' THEN 1 ELSE 0 END 
AS invitation,
-        CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 END 
AS star
-    FROM github_events
-    WHERE cast(v["type"] as string) IN ('MemberEvent', 'WatchEvent')
-) t
-GROUP BY repo_name
-HAVING stars >= 2
-ORDER BY invitations DESC, stars DESC, repo_name
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
deleted file mode 100644
index 329cfc908b6..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-SELECT
-    repo_name,
-    count(distinct actor_login) AS u,
-    sum(star) AS stars
-FROM
-(
-    SELECT
-        lower(cast(v["repo"]["name"] as string)) as repo_name,
-        CASE WHEN cast(v["type"] as string) = 'PushEvent' THEN 
cast(v["actor"]["login"] as string) ELSE NULL END AS actor_login,
-        CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 END 
AS star
-    FROM github_events WHERE cast(v["type"] as string) IN ('PushEvent', 
'WatchEvent') AND cast(v["repo"]["name"] as string) != '/'
-) t
-GROUP BY repo_name ORDER BY u, stars, repo_name DESC LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
deleted file mode 100644
index 410f69c47a5..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
+++ /dev/null
@@ -1,13 +0,0 @@
--- SELECT
---     cast(v["repo"]["name"] as string),
---     count(distinct cast(v["actor"]["login"] as string)) AS u,
---     sum(star) AS stars
--- FROM
--- (
---     SELECT
---         cast(v["repo"]["name"] as string),
---         CASE WHEN cast(v["type"] as string) = 'PushEvent' AND (ref LIKE 
'%/master' OR ref LIKE '%/main') THEN cast(v["actor"]["login"] as string) ELSE 
NULL END AS cast(v["actor"]["login"] as string),
---         CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 
END AS star
---     FROM github_events WHERE cast(v["type"] as string) IN ('PushEvent', 
'WatchEvent') AND cast(v["repo"]["name"] as string) != '/'
--- ) t
--- GROUP BY cast(v["repo"]["name"] as string) ORDER BY u DESC LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
deleted file mode 100644
index dbcf16db2ac..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
+++ /dev/null
@@ -1,16 +0,0 @@
--- SELECT
---     cast(v["repo"]["name"] as string),
---     count(distinct cast(v["actor"]["login"] as string)) AS u,
---     sum(star) AS stars
--- FROM
--- (
---     SELECT
---         cast(v["repo"]["name"] as string),
---         CASE WHEN cast(v["type"] as string) = 'PushEvent' AND (ref LIKE 
'%/master' OR ref LIKE '%/main') THEN cast(v["actor"]["login"] as string) ELSE 
NULL END AS cast(v["actor"]["login"] as string),
---         CASE WHEN cast(v["type"] as string) = 'WatchEvent' THEN 1 ELSE 0 
END AS star
---     FROM github_events WHERE cast(v["type"] as string) IN ('PushEvent', 
'WatchEvent') AND cast(v["repo"]["name"] as string) != '/'
--- ) t
--- GROUP BY cast(v["repo"]["name"] as string)
--- HAVING stars >= 100
--- ORDER BY u DESC
--- LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostStarsOverOneDay1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostStarsOverOneDay1.sql
deleted file mode 100644
index 1e6fdb4b769..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostStarsOverOneDay1.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-SELECT
-    repo_name,
-    day,
-    stars
-FROM
-(
-    SELECT
-        row_number() OVER (PARTITION BY repo_name  ORDER BY stars DESC) AS 
rank,
-        repo_name,
-        day,
-        stars
-    FROM
-    (
-        SELECT
-            cast(v["repo"]["name"] as string) as repo_name,
-            to_date(cast(v["created_at"] as datetime)) AS day,
-            count() AS stars
-        FROM github_events
-        WHERE cast(v["type"] as string) = 'WatchEvent'
-        GROUP BY cast(v["repo"]["name"] as string), day
-    ) t1
-) t2
-WHERE rank = 1
-ORDER BY stars DESC, 1
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostStarsOverOneDay2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostStarsOverOneDay2.sql
deleted file mode 100644
index 92a1c9a9c6e..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostStarsOverOneDay2.sql
+++ /dev/null
@@ -1,25 +0,0 @@
--- SELECT
---     cast(v["repo"]["name"] as string),
---     day,
---     stars
--- FROM
--- (
---     SELECT
---         row_number() OVER (PARTITION BY cast(v["repo"]["name"] as string) 
ORDER BY stars DESC) AS rank,
---         cast(v["repo"]["name"] as string),
---         day,
---         stars
---     FROM
---     (
---         SELECT
---             cast(v["repo"]["name"] as string),
---             to_date(cast(v["created_at"] as datetime)) AS day,
---             count() AS stars
---         FROM github_events
---         WHERE cast(v["type"] as string) = 'WatchEvent'
---         GROUP BY cast(v["repo"]["name"] as string), day
---     ) t1
--- ) t2
--- WHERE rank = 1
--- ORDER BY stars DESC
--- LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostStarsOverOneDay3.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostStarsOverOneDay3.sql
deleted file mode 100644
index 29fd779ffa3..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostStarsOverOneDay3.sql
+++ /dev/null
@@ -1 +0,0 @@
--- SELECT cast(v["repo"]["name"] as string), cast(v["created_at"] as 
datetime), count() AS stars FROM github_events WHERE cast(v["type"] as string) 
= 'WatchEvent' GROUP BY cast(v["repo"]["name"] as string), cast(v["created_at"] 
as datetime) ORDER BY count() DESC LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostSteadyGrowthOverTime.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostSteadyGrowthOverTime.sql
deleted file mode 100644
index 5d05e3cb8db..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheMostSteadyGrowthOverTime.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-SELECT
-    repo_name,
-    max(stars) AS daily_stars,
-    sum(stars) AS total_stars,
-    sum(stars) / max(stars) AS rate
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        to_date(cast(v["created_at"] as datetime)) AS day,
-        count() AS stars
-    FROM github_events
-    WHERE cast(v["type"] as string) = 'WatchEvent'
-    GROUP BY
-        repo_name,
-        day
-) t
-GROUP BY repo_name
-ORDER BY rate DESC, 1
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheWorstStagnation_order.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheWorstStagnation_order.sql
deleted file mode 100644
index f0019d64330..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoriesWithTheWorstStagnation_order.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-SELECT
-    repo_name,
-    sum(created_at_2022) AS stars2022,
-    sum(created_at_2015) AS stars2015,
-    round(sum(created_at_2022) / sum(created_at_2015), 3) AS yoy,
-    min(created_at) AS first_seen
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        CASE year(cast(v["created_at"] as datetime)) WHEN 2022 THEN 1 ELSE 0 
END AS created_at_2022,
-        CASE year(cast(v["created_at"] as datetime)) WHEN 2015 THEN 1 ELSE 0 
END AS created_at_2015,
-        cast(v["created_at"] as datetime) as created_at
-    FROM github_events
-    WHERE cast(v["type"] as string) = 'WatchEvent'
-) t
-GROUP BY repo_name
-HAVING (min(created_at) <= '2019-01-01 00:00:00') AND (max(created_at) >= 
'2020-06-01 00:00:00') AND (stars2015 >= 2)
-ORDER BY yoy, repo_name
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoryAffinityList1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoryAffinityList1.sql
deleted file mode 100644
index d1c3b8150d6..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoryAffinityList1.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-SELECT
-  cast(v["repo"]["name"] as string) as repo_name,
-  count() AS stars
-FROM github_events
-WHERE (cast(v["type"] as string) = 'WatchEvent') AND (cast(v["actor"]["login"] 
as string) IN
-(
-    SELECT cast(v["actor"]["login"] as string)
-    FROM github_events
-    WHERE (cast(v["type"] as string) = 'WatchEvent') AND 
(cast(v["repo"]["name"] as string) IN ('apache/spark', 
'prakhar1989/awesome-courses'))
-)) AND (cast(v["repo"]["name"] as string) NOT IN ('ClickHouse/ClickHouse', 
'yandex/ClickHouse'))
-GROUP BY repo_name
-ORDER BY stars DESC, repo_name 
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoryAffinityList2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoryAffinityList2.sql
deleted file mode 100644
index 293f4b90396..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/repositoryAffinityList2.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-SELECT
-  repo_name,
-  total_stars,
-  round(spark_stars / total_stars, 2) AS ratio
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo_name,
-        count(distinct cast(v["actor"]["login"] as string)) AS total_stars
-    FROM github_events
-    WHERE (cast(v["type"] as string) = 'WatchEvent') AND 
(cast(v["repo"]["name"] as string) NOT IN ('apache/spark'))
-    GROUP BY repo_name
-    HAVING total_stars >= 10
-) t1
-JOIN
-(
-    SELECT
-        count(distinct cast(v["actor"]["login"] as string)) AS spark_stars
-    FROM github_events
-    WHERE (cast(v["type"] as string) = 'WatchEvent') AND 
(cast(v["repo"]["name"] as string) IN ('apache/spark'))
-) t2
-ORDER BY ratio DESC, repo_name
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/starsFromHeavyGithubUsers1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/starsFromHeavyGithubUsers1.sql
deleted file mode 100644
index ba9f4ab2604..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/starsFromHeavyGithubUsers1.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-SELECT
-    cast(v["repo"]["name"] as string),
-    count()
-FROM github_events
-WHERE (cast(v["type"] as string) = 'WatchEvent') AND (cast(v["actor"]["login"] 
as string) IN
-(
-    SELECT cast(v["actor"]["login"] as string)
-    FROM github_events
-    WHERE (cast(v["type"] as string) = 'PullRequestEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened')
-))
-GROUP BY cast(v["repo"]["name"] as string)
-ORDER BY count() DESC, cast(v["repo"]["name"] as string)
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/starsFromHeavyGithubUsers2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/starsFromHeavyGithubUsers2.sql
deleted file mode 100644
index c55c37a294a..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/starsFromHeavyGithubUsers2.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-SELECT
-    cast(v["repo"]["name"] as string),
-    count()
-FROM github_events
-WHERE (cast(v["type"] as string) = 'WatchEvent') AND (cast(v["actor"]["login"] 
as string) IN
-(
-    SELECT cast(v["actor"]["login"] as string)
-    FROM github_events
-    WHERE (cast(v["type"] as string) = 'PullRequestEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened')
-    GROUP BY cast(v["actor"]["login"] as string)
-    HAVING count() >= 2
-))
-GROUP BY cast(v["repo"]["name"] as string)
-ORDER BY 1, count() DESC, 1
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theLongestRepositoryNames1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theLongestRepositoryNames1.sql
deleted file mode 100644
index 117dc222667..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theLongestRepositoryNames1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT count(), cast(v["repo"]["name"] as string) FROM github_events WHERE 
cast(v["type"] as string) = 'WatchEvent' GROUP BY cast(v["repo"]["name"] as 
string) ORDER BY length(cast(v["repo"]["name"] as string)) DESC, 
cast(v["repo"]["name"] as string) LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theLongestRepositoryNames2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theLongestRepositoryNames2.sql
deleted file mode 100644
index 203b253d889..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theLongestRepositoryNames2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() FROM github_events WHERE 
cast(v["type"] as string) = 'WatchEvent' AND cast(v["repo"]["name"] as string) 
LIKE '%_/_%' GROUP BY cast(v["repo"]["name"] as string) ORDER BY 
length(cast(v["repo"]["name"] as string)) ASC, cast(v["repo"]["name"] as 
string) LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theMostToughCodeReviews.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theMostToughCodeReviews.sql
deleted file mode 100644
index 670a70ff725..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theMostToughCodeReviews.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-SELECT
-    concat('https://github.com/', cast(v["repo"]["name"] as string), '/pull/') 
AS URL,
-    count(distinct cast(v["actor"]["login"] as string)) AS authors
-FROM github_events
-WHERE (cast(v["type"] as string) = 'PullRequestReviewCommentEvent') AND 
(cast(v["payload"]["action"] as string) = 'created')
-GROUP BY
-    cast(v["repo"]["name"] as string),
-    cast(v["payload"]["issue"]["number"] as string) 
-ORDER BY authors DESC, URL ASC
-LIMIT 50
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfRepositoriesOnGithub.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfRepositoriesOnGithub.sql
deleted file mode 100644
index 9fdc19bfcef..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfRepositoriesOnGithub.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT count(distinct cast(v["repo"]["name"] as string)) FROM github_events
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub1.sql
deleted file mode 100644
index 56f9ddf9473..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT count(distinct cast(v["actor"]["login"] as string)) FROM github_events
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub2.sql
deleted file mode 100644
index f2ed81a78bd..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT count(distinct cast(v["actor"]["login"] as string)) FROM github_events 
WHERE cast(v["type"] as string) = 'WatchEvent'
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub3.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub3.sql
deleted file mode 100644
index 3a2dd0c08b3..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub3.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT count(distinct cast(v["actor"]["login"] as string)) FROM github_events 
WHERE cast(v["type"] as string) = 'PushEvent'
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub4.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub4.sql
deleted file mode 100644
index 59410fa57bc..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/theTotalNumberOfUsersOnGithub4.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT count(distinct cast(v["actor"]["login"] as string)) FROM github_events 
WHERE cast(v["type"] as string) = 'PullRequestEvent' AND 
cast(v["payload"]["action"] as string) = 'opened'
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/topLabels1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/topLabels1.sql
deleted file mode 100644
index 8e4ae36dd63..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/topLabels1.sql
+++ /dev/null
@@ -1,9 +0,0 @@
--- SELECT
---     label,
---     count() AS c
--- FROM github_events
--- LATERAL VIEW explode_split(labels, ',') t AS label
--- WHERE (cast(v["type"] as string) IN ('IssuesEvent', 'PullRequestEvent', 
'IssueCommentEvent')) AND (action IN ('created', 'opened', 'labeled'))
--- GROUP BY label
--- ORDER BY c DESC
--- LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/topLabels2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/topLabels2.sql
deleted file mode 100644
index 302e08519a1..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/topLabels2.sql
+++ /dev/null
@@ -1,9 +0,0 @@
--- SELECT
---     label,
---     count() AS c
--- FROM github_events
--- LATERAL VIEW explode_split(labels, ',') t AS label
--- WHERE (cast(v["type"] as string) IN ('IssuesEvent', 'PullRequestEvent', 
'IssueCommentEvent')) AND (action IN ('created', 'opened', 'labeled')) AND 
((lower(label) LIKE '%bug%') OR (lower(label) LIKE '%feature%'))
--- GROUP BY label
--- ORDER BY c DESC
--- LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/topLabels3.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/topLabels3.sql
deleted file mode 100644
index 30c6e7ee8be..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/topLabels3.sql
+++ /dev/null
@@ -1,14 +0,0 @@
--- SELECT
---     sum(bug) AS bugs,
---     sum(feature) AS feature,
---     sum(bug) / sum(feature) AS ratio
--- FROM
--- (
---     SELECT
---         CASE WHEN lower(label) LIKE '%bug%' THEN 1 ELSE 0 END AS bug,
---         CASE WHEN lower(label) LIKE '%feature%' THEN 1 ELSE 0 END AS feature
---     FROM github_events
---     LATERAL VIEW explode_split(labels, ',') t AS label
---     WHERE (cast(v["type"] as string) IN ('IssuesEvent', 'PullRequestEvent', 
'IssueCommentEvent')) AND (action IN ('created', 'opened', 'labeled')) AND 
((lower(label) LIKE '%bug%') OR (lower(label) LIKE '%feature%'))
--- ) t
--- LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/topRepositoriesByStars.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/topRepositoriesByStars.sql
deleted file mode 100644
index 8ca99e182b7..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/topRepositoriesByStars.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["repo"]["name"] as string), count() AS stars FROM github_events 
WHERE cast(v["type"] as string) = 'WatchEvent' GROUP BY cast(v["repo"]["name"] 
as string) ORDER BY stars DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql
deleted file mode 100644
index 116fe5ca57c..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT dayofweek(cast(v["created_at"] as datetime)) AS day, count() AS stars 
FROM github_events WHERE cast(v["type"] as string) = 'WatchEvent' GROUP BY day 
ORDER BY day
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars1.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars1.sql
deleted file mode 100644
index 445853c2efa..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["actor"]["login"] as string), count() AS stars FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' GROUP BY 
cast(v["actor"]["login"] as string) ORDER BY stars DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars2.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars2.sql
deleted file mode 100644
index 1fc9a6158ed..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT cast(v["actor"]["login"] as string), count() AS stars FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' AND 
cast(v["actor"]["login"] as string) = 'cliffordfajardo' GROUP BY 
cast(v["actor"]["login"] as string) ORDER BY stars DESC LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars3.sql
 
b/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars3.sql
deleted file mode 100644
index 43426a2c9e4..00000000000
--- 
a/regression-test/suites/variant_github_events_index_type_p2/sparsed/sql/whoAreAllThosePeopleGivingStars3.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-SELECT
-    cast(v["repo"]["name"] as string),
-    count() AS stars
-FROM github_events
-WHERE (cast(v["type"] as string) = 'WatchEvent') AND (cast(v["repo"]["name"] 
as string) IN
-(
-    SELECT cast(v["repo"]["name"] as string)
-    FROM github_events
-    WHERE (cast(v["type"] as string) = 'WatchEvent') AND 
(cast(v["actor"]["login"] as string) = 'cliffordfajardo')
-))
-GROUP BY cast(v["repo"]["name"] as string)
-ORDER BY stars DESC, cast(v["repo"]["name"] as string)
-LIMIT 50


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

(doris) branch branch-3.1 updated: [regression-test](variant) refine variant_github_events_index_type_p2 (#54691)

Reply via email to