(doris) branch branch-2.1 updated: branch-2.1: [chore](regression-test) move some variant cases to directory #45169 (#45259)

eldenmoon Wed, 11 Dec 2024 20:16:19 -0800

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

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



The following commit(s) were added to refs/heads/branch-2.1 by this push:
     new 8217371d156 branch-2.1: [chore](regression-test) move some variant 
cases to directory #45169 (#45259)
8217371d156 is described below

commit 8217371d156ba22ebe9c937506858a4f13fba1be
Author: github-actions[bot] 
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Dec 12 12:16:04 2024 +0800

    branch-2.1: [chore](regression-test) move some variant cases to directory 
#45169 (#45259)
    
    Cherry-picked from #45169
    
    Co-authored-by: lihangyu <[email protected]>
---
 .../{ => sql}/affinityByIssuesAndPRs1.out          |  0
 .../{ => sql}/affinityByIssuesAndPRs2.out          |  0
 .../{ => sql}/authorsWithTheMostPushes.out         |  0
 .../{ => sql}/countingStar1.out                    |  0
 .../{ => sql}/countingStar2.out                    |  0
 .../{ => sql}/countingStar3.out                    |  0
 .../distributionOfRepositoriesByStarCount.out      |  0
 .../{ => sql}/githubRoulette.out                   |  0
 ...heListOfTopRepositoriesChangedOverTheYears1.out |  0
 ...heListOfTopRepositoriesChangedOverTheYears2.out |  0
 ...heListOfTopRepositoriesChangedOverTheYears3.out |  0
 ...heListOfTopRepositoriesChangedOverTheYears4.out |  0
 ...heListOfTopRepositoriesChangedOverTheYears5.out |  0
 ...heListOfTopRepositoriesChangedOverTheYears6.out |  0
 .../howHasTheTotalNumberOfStarsChangedOverTime.out |  0
 .../{ => sql}/issuesWithTheMostComments1.out       |  0
 .../{ => sql}/issuesWithTheMostComments2.out       |  0
 .../{ => sql}/issuesWithTheMostComments3.out       |  0
 .../{ => sql}/issuesWithTheMostComments4.out       |  0
 .../{ => sql}/issuesWithTheMostComments5.out       |  0
 .../{ => sql}/issuesWithTheMostComments6.out       |  0
 .../{ => sql}/issuesWithTheMostComments7.out       |  0
 .../variant_github_events_p2/{ => sql}/load.out    |  0
 .../{ => sql}/mostForkedRepositories.out           |  0
 .../{ => sql}/mostPopularCommentsOnGithub.out      |  0
 .../organizationsByTheNumberOfRepositories.out     |  0
 .../{ => sql}/organizationsByTheNumberOfStars.out  |  0
 .../{ => sql}/proportionsBetweenStarsAndForks1.out |  0
 .../{ => sql}/proportionsBetweenStarsAndForks2.out |  0
 .../{ => sql}/proportionsBetweenStarsAndForks3.out |  0
 .../{ => sql}/proportionsBetweenStarsAndForks4.out |  0
 .../{ => sql}/proportionsBetweenStarsAndForks5.out |  0
 .../repositoriesByAmountOfModifiedCode.out         |  0
 .../{ => sql}/repositoriesByTheNumberOfPushes.out  |  0
 ...epositoriesWithClickhouse_related_comments1.out |  0
 ...epositoriesWithClickhouse_related_comments2.out |  0
 .../repositoriesWithDoris_related_comments1.out    |  0
 .../repositoriesWithDoris_related_comments2.out    |  0
 .../repositoriesWithTheHighestGrowthYoY.out        |  0
 .../repositoriesWithTheMaximumAmountOfIssues1.out  |  0
 .../repositoriesWithTheMaximumAmountOfIssues2.out  |  0
 .../repositoriesWithTheMaximumAmountOfIssues3.out  |  0
 .../repositoriesWithTheMaximumAmountOfIssues4.out  |  0
 ...sitoriesWithTheMaximumAmountOfPullRequests1.out |  0
 ...sitoriesWithTheMaximumAmountOfPullRequests2.out |  0
 ...esWithTheMaximumNumberOfAcceptedInvitations.out |  0
 ...sitoriesWithTheMostPeopleWhoHavePushAccess1.out |  0
 .../repositoriesWithTheMostStarsOverOneDay1.out    |  0
 ...repositoriesWithTheMostSteadyGrowthOverTime.out |  0
 .../repositoriesWithTheWorstStagnation_order.out   |  0
 .../{ => sql}/repositoryAffinityList1.out          |  0
 .../{ => sql}/repositoryAffinityList2.out          |  0
 .../{ => sql}/starsFromHeavyGithubUsers1.out       |  0
 .../{ => sql}/starsFromHeavyGithubUsers2.out       |  0
 .../{ => sql}/theLongestRepositoryNames1.out       |  0
 .../{ => sql}/theLongestRepositoryNames2.out       |  0
 .../{ => sql}/theMostToughCodeReviews.out          |  0
 .../theTotalNumberOfRepositoriesOnGithub.out       |  0
 .../{ => sql}/theTotalNumberOfUsersOnGithub1.out   |  0
 .../{ => sql}/theTotalNumberOfUsersOnGithub2.out   |  0
 .../{ => sql}/theTotalNumberOfUsersOnGithub3.out   |  0
 .../{ => sql}/theTotalNumberOfUsersOnGithub4.out   |  0
 .../{ => sql}/topRepositoriesByStars.out           |  0
 .../whatIsTheBestDayOfTheWeekToCatchAStar.out      |  0
 .../{ => sql}/whoAreAllThosePeopleGivingStars1.out |  0
 .../{ => sql}/whoAreAllThosePeopleGivingStars2.out |  0
 .../{ => sql}/whoAreAllThosePeopleGivingStars3.out |  0
 .../sql/affinityByIssuesAndPRs1.sql                | 14 ----------
 .../sql/affinityByIssuesAndPRs2.sql                | 14 ----------
 .../sql/authorsWithTheMostPushes.sql               |  9 -------
 .../sql/countingStar1.sql                          |  1 -
 .../sql/countingStar2.sql                          |  1 -
 .../sql/countingStar3.sql                          |  1 -
 .../sql/distributionOfRepositoriesByStarCount.sql  | 14 ----------
 .../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 --
 .../sql/issuesWithTheMostComments1.sql             |  1 -
 .../sql/issuesWithTheMostComments2.sql             |  1 -
 .../sql/issuesWithTheMostComments3.sql             | 17 ------------
 .../sql/issuesWithTheMostComments4.sql             |  9 -------
 .../sql/issuesWithTheMostComments5.sql             |  9 -------
 .../sql/issuesWithTheMostComments6.sql             | 11 --------
 .../sql/issuesWithTheMostComments7.sql             |  9 -------
 .../sql/issuesWithTheMostComments8.sql             | 13 ----------
 .../sql/mostForkedRepositories.sql                 |  1 -
 .../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/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 ---------------
 .../sql/repositoryAffinityList1.sql                | 13 ----------
 .../sql/repositoryAffinityList2.sql                | 23 -----------------
 .../sql/starsFromHeavyGithubUsers1.sql             | 13 ----------
 .../sql/starsFromHeavyGithubUsers2.sql             | 15 -----------
 .../sql/test_distinct_streaming_agg.sql            |  5 ----
 .../sql/theLongestRepositoryNames1.sql             |  1 -
 .../sql/theLongestRepositoryNames2.sql             |  1 -
 .../sql/theMostToughCodeReviews.sql                | 10 --------
 .../sql/theTotalNumberOfRepositoriesOnGithub.sql   |  1 -
 .../sql/theTotalNumberOfUsersOnGithub1.sql         |  1 -
 .../sql/theTotalNumberOfUsersOnGithub2.sql         |  1 -
 .../sql/theTotalNumberOfUsersOnGithub3.sql         |  1 -
 .../sql/theTotalNumberOfUsersOnGithub4.sql         |  1 -
 .../sql/topLabels1.sql                             |  9 -------
 .../sql/topLabels2.sql                             |  9 -------
 .../sql/topLabels3.sql                             | 14 ----------
 .../sql/topRepositoriesByStars.sql                 |  1 -
 .../sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql  |  1 -
 .../sql/whoAreAllThosePeopleGivingStars1.sql       |  1 -
 .../sql/whoAreAllThosePeopleGivingStars2.sql       |  1 -
 .../sql/whoAreAllThosePeopleGivingStars3.sql       | 13 ----------
 .../repositoriesByAmountOfModifiedCode.sql         | 12 ---------
 .../{ => sql}/affinityByIssuesAndPRs1.sql          |  0
 .../{ => sql}/affinityByIssuesAndPRs2.sql          |  0
 .../{ => sql}/authorsWithTheMostPushes.sql         |  0
 .../{ => sql}/countingStar1.sql                    |  0
 .../{ => sql}/countingStar2.sql                    |  0
 .../{ => sql}/countingStar3.sql                    |  0
 .../distributionOfRepositoriesByStarCount.sql      |  0
 .../{ => sql}/githubRoulette.sql                   |  0
 ...heListOfTopRepositoriesChangedOverTheYears1.sql |  0
 ...heListOfTopRepositoriesChangedOverTheYears2.sql |  0
 ...heListOfTopRepositoriesChangedOverTheYears3.sql |  0
 ...heListOfTopRepositoriesChangedOverTheYears4.sql |  0
 ...heListOfTopRepositoriesChangedOverTheYears5.sql |  0
 ...heListOfTopRepositoriesChangedOverTheYears6.sql |  0
 ...heListOfTopRepositoriesChangedOverTheYears7.sql |  0
 .../howHasTheTotalNumberOfStarsChangedOverTime.sql |  0
 .../{ => sql}/issuesWithTheMostComments1.sql       |  0
 .../{ => sql}/issuesWithTheMostComments2.sql       |  0
 .../{ => sql}/issuesWithTheMostComments3.sql       |  0
 .../{ => sql}/issuesWithTheMostComments4.sql       |  0
 .../{ => sql}/issuesWithTheMostComments5.sql       |  0
 .../{ => sql}/issuesWithTheMostComments6.sql       |  0
 .../{ => sql}/issuesWithTheMostComments7.sql       |  0
 .../{ => sql}/issuesWithTheMostComments8.sql       |  0
 .../{ => sql}/mostForkedRepositories.sql           |  0
 .../{ => sql}/mostPopularCommentsOnGithub.sql      |  0
 .../organizationsByTheNumberOfRepositories.sql     |  0
 .../{ => sql}/organizationsByTheNumberOfStars.sql  |  0
 .../organizationsByTheSizeOfCommunity.sql          |  0
 .../{ => sql}/proportionsBetweenStarsAndForks1.sql |  0
 .../{ => sql}/proportionsBetweenStarsAndForks2.sql |  0
 .../{ => sql}/proportionsBetweenStarsAndForks3.sql |  0
 .../{ => sql}/proportionsBetweenStarsAndForks4.sql |  0
 .../{ => sql}/proportionsBetweenStarsAndForks5.sql |  0
 .../sql/repositoriesByAmountOfModifiedCode.sql     |  0
 .../{ => sql}/repositoriesByTheNumberOfPushes.sql  |  0
 ...epositoriesWithClickhouse_related_comments1.sql |  0
 ...epositoriesWithClickhouse_related_comments2.sql |  0
 .../repositoriesWithDoris_related_comments1.sql    |  0
 .../repositoriesWithDoris_related_comments2.sql    |  0
 .../repositoriesWithTheHighestGrowthYoY.sql        |  0
 .../repositoriesWithTheMaximumAmountOfIssues1.sql  |  0
 .../repositoriesWithTheMaximumAmountOfIssues2.sql  |  0
 .../repositoriesWithTheMaximumAmountOfIssues3.sql  |  0
 .../repositoriesWithTheMaximumAmountOfIssues4.sql  |  0
 ...sitoriesWithTheMaximumAmountOfPullRequests1.sql |  0
 ...sitoriesWithTheMaximumAmountOfPullRequests2.sql |  0
 ...esWithTheMaximumNumberOfAcceptedInvitations.sql |  0
 ...sitoriesWithTheMostPeopleWhoHavePushAccess1.sql |  0
 ...sitoriesWithTheMostPeopleWhoHavePushAccess2.sql |  0
 ...sitoriesWithTheMostPeopleWhoHavePushAccess3.sql |  0
 .../repositoriesWithTheMostStarsOverOneDay1.sql    |  0
 .../repositoriesWithTheMostStarsOverOneDay2.sql    |  0
 .../repositoriesWithTheMostStarsOverOneDay3.sql    |  0
 ...repositoriesWithTheMostSteadyGrowthOverTime.sql |  0
 .../repositoriesWithTheWorstStagnation_order.sql   |  0
 .../{ => sql}/repositoryAffinityList1.sql          |  0
 .../{ => sql}/repositoryAffinityList2.sql          |  0
 .../{ => sql}/starsFromHeavyGithubUsers1.sql       |  0
 .../{ => sql}/starsFromHeavyGithubUsers2.sql       |  0
 .../{ => sql}/theLongestRepositoryNames1.sql       |  0
 .../{ => sql}/theLongestRepositoryNames2.sql       |  0
 .../{ => sql}/theMostToughCodeReviews.sql          |  0
 .../theTotalNumberOfRepositoriesOnGithub.sql       |  0
 .../{ => sql}/theTotalNumberOfUsersOnGithub1.sql   |  0
 .../{ => sql}/theTotalNumberOfUsersOnGithub2.sql   |  0
 .../{ => sql}/theTotalNumberOfUsersOnGithub3.sql   |  0
 .../{ => sql}/theTotalNumberOfUsersOnGithub4.sql   |  0
 .../{ => sql}/topLabels1.sql                       |  0
 .../{ => sql}/topLabels2.sql                       |  0
 .../{ => sql}/topLabels3.sql                       |  0
 .../{ => sql}/topRepositoriesByStars.sql           |  0
 .../whatIsTheBestDayOfTheWeekToCatchAStar.sql      |  0
 .../{ => sql}/whoAreAllThosePeopleGivingStars1.sql |  0
 .../{ => sql}/whoAreAllThosePeopleGivingStars2.sql |  0
 .../{ => sql}/whoAreAllThosePeopleGivingStars3.sql |  0
 220 files changed, 725 deletions(-)

diff --git 
a/regression-test/data/variant_github_events_p2/affinityByIssuesAndPRs1.out 
b/regression-test/data/variant_github_events_p2/sql/affinityByIssuesAndPRs1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/affinityByIssuesAndPRs1.out
rename to 
regression-test/data/variant_github_events_p2/sql/affinityByIssuesAndPRs1.out
diff --git 
a/regression-test/data/variant_github_events_p2/affinityByIssuesAndPRs2.out 
b/regression-test/data/variant_github_events_p2/sql/affinityByIssuesAndPRs2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/affinityByIssuesAndPRs2.out
rename to 
regression-test/data/variant_github_events_p2/sql/affinityByIssuesAndPRs2.out
diff --git 
a/regression-test/data/variant_github_events_p2/authorsWithTheMostPushes.out 
b/regression-test/data/variant_github_events_p2/sql/authorsWithTheMostPushes.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/authorsWithTheMostPushes.out
rename to 
regression-test/data/variant_github_events_p2/sql/authorsWithTheMostPushes.out
diff --git a/regression-test/data/variant_github_events_p2/countingStar1.out 
b/regression-test/data/variant_github_events_p2/sql/countingStar1.out
similarity index 100%
rename from regression-test/data/variant_github_events_p2/countingStar1.out
rename to regression-test/data/variant_github_events_p2/sql/countingStar1.out
diff --git a/regression-test/data/variant_github_events_p2/countingStar2.out 
b/regression-test/data/variant_github_events_p2/sql/countingStar2.out
similarity index 100%
rename from regression-test/data/variant_github_events_p2/countingStar2.out
rename to regression-test/data/variant_github_events_p2/sql/countingStar2.out
diff --git a/regression-test/data/variant_github_events_p2/countingStar3.out 
b/regression-test/data/variant_github_events_p2/sql/countingStar3.out
similarity index 100%
rename from regression-test/data/variant_github_events_p2/countingStar3.out
rename to regression-test/data/variant_github_events_p2/sql/countingStar3.out
diff --git 
a/regression-test/data/variant_github_events_p2/distributionOfRepositoriesByStarCount.out
 
b/regression-test/data/variant_github_events_p2/sql/distributionOfRepositoriesByStarCount.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/distributionOfRepositoriesByStarCount.out
rename to 
regression-test/data/variant_github_events_p2/sql/distributionOfRepositoriesByStarCount.out
diff --git a/regression-test/data/variant_github_events_p2/githubRoulette.out 
b/regression-test/data/variant_github_events_p2/sql/githubRoulette.out
similarity index 100%
rename from regression-test/data/variant_github_events_p2/githubRoulette.out
rename to regression-test/data/variant_github_events_p2/sql/githubRoulette.out
diff --git 
a/regression-test/data/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
 
b/regression-test/data/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
rename to 
regression-test/data/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
diff --git 
a/regression-test/data/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
 
b/regression-test/data/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
rename to 
regression-test/data/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
diff --git 
a/regression-test/data/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
 
b/regression-test/data/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
rename to 
regression-test/data/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
diff --git 
a/regression-test/data/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
 
b/regression-test/data/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
rename to 
regression-test/data/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
diff --git 
a/regression-test/data/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
 
b/regression-test/data/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
rename to 
regression-test/data/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
diff --git 
a/regression-test/data/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
 
b/regression-test/data/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
rename to 
regression-test/data/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
diff --git 
a/regression-test/data/variant_github_events_p2/howHasTheTotalNumberOfStarsChangedOverTime.out
 
b/regression-test/data/variant_github_events_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/howHasTheTotalNumberOfStarsChangedOverTime.out
rename to 
regression-test/data/variant_github_events_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
diff --git 
a/regression-test/data/variant_github_events_p2/issuesWithTheMostComments1.out 
b/regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/issuesWithTheMostComments1.out
rename to 
regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments1.out
diff --git 
a/regression-test/data/variant_github_events_p2/issuesWithTheMostComments2.out 
b/regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/issuesWithTheMostComments2.out
rename to 
regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments2.out
diff --git 
a/regression-test/data/variant_github_events_p2/issuesWithTheMostComments3.out 
b/regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments3.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/issuesWithTheMostComments3.out
rename to 
regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments3.out
diff --git 
a/regression-test/data/variant_github_events_p2/issuesWithTheMostComments4.out 
b/regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments4.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/issuesWithTheMostComments4.out
rename to 
regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments4.out
diff --git 
a/regression-test/data/variant_github_events_p2/issuesWithTheMostComments5.out 
b/regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments5.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/issuesWithTheMostComments5.out
rename to 
regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments5.out
diff --git 
a/regression-test/data/variant_github_events_p2/issuesWithTheMostComments6.out 
b/regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments6.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/issuesWithTheMostComments6.out
rename to 
regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments6.out
diff --git 
a/regression-test/data/variant_github_events_p2/issuesWithTheMostComments7.out 
b/regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments7.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/issuesWithTheMostComments7.out
rename to 
regression-test/data/variant_github_events_p2/sql/issuesWithTheMostComments7.out
diff --git a/regression-test/data/variant_github_events_p2/load.out 
b/regression-test/data/variant_github_events_p2/sql/load.out
similarity index 100%
rename from regression-test/data/variant_github_events_p2/load.out
rename to regression-test/data/variant_github_events_p2/sql/load.out
diff --git 
a/regression-test/data/variant_github_events_p2/mostForkedRepositories.out 
b/regression-test/data/variant_github_events_p2/sql/mostForkedRepositories.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/mostForkedRepositories.out
rename to 
regression-test/data/variant_github_events_p2/sql/mostForkedRepositories.out
diff --git 
a/regression-test/data/variant_github_events_p2/mostPopularCommentsOnGithub.out 
b/regression-test/data/variant_github_events_p2/sql/mostPopularCommentsOnGithub.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/mostPopularCommentsOnGithub.out
rename to 
regression-test/data/variant_github_events_p2/sql/mostPopularCommentsOnGithub.out
diff --git 
a/regression-test/data/variant_github_events_p2/organizationsByTheNumberOfRepositories.out
 
b/regression-test/data/variant_github_events_p2/sql/organizationsByTheNumberOfRepositories.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/organizationsByTheNumberOfRepositories.out
rename to 
regression-test/data/variant_github_events_p2/sql/organizationsByTheNumberOfRepositories.out
diff --git 
a/regression-test/data/variant_github_events_p2/organizationsByTheNumberOfStars.out
 
b/regression-test/data/variant_github_events_p2/sql/organizationsByTheNumberOfStars.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/organizationsByTheNumberOfStars.out
rename to 
regression-test/data/variant_github_events_p2/sql/organizationsByTheNumberOfStars.out
diff --git 
a/regression-test/data/variant_github_events_p2/proportionsBetweenStarsAndForks1.out
 
b/regression-test/data/variant_github_events_p2/sql/proportionsBetweenStarsAndForks1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/proportionsBetweenStarsAndForks1.out
rename to 
regression-test/data/variant_github_events_p2/sql/proportionsBetweenStarsAndForks1.out
diff --git 
a/regression-test/data/variant_github_events_p2/proportionsBetweenStarsAndForks2.out
 
b/regression-test/data/variant_github_events_p2/sql/proportionsBetweenStarsAndForks2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/proportionsBetweenStarsAndForks2.out
rename to 
regression-test/data/variant_github_events_p2/sql/proportionsBetweenStarsAndForks2.out
diff --git 
a/regression-test/data/variant_github_events_p2/proportionsBetweenStarsAndForks3.out
 
b/regression-test/data/variant_github_events_p2/sql/proportionsBetweenStarsAndForks3.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/proportionsBetweenStarsAndForks3.out
rename to 
regression-test/data/variant_github_events_p2/sql/proportionsBetweenStarsAndForks3.out
diff --git 
a/regression-test/data/variant_github_events_p2/proportionsBetweenStarsAndForks4.out
 
b/regression-test/data/variant_github_events_p2/sql/proportionsBetweenStarsAndForks4.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/proportionsBetweenStarsAndForks4.out
rename to 
regression-test/data/variant_github_events_p2/sql/proportionsBetweenStarsAndForks4.out
diff --git 
a/regression-test/data/variant_github_events_p2/proportionsBetweenStarsAndForks5.out
 
b/regression-test/data/variant_github_events_p2/sql/proportionsBetweenStarsAndForks5.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/proportionsBetweenStarsAndForks5.out
rename to 
regression-test/data/variant_github_events_p2/sql/proportionsBetweenStarsAndForks5.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesByAmountOfModifiedCode.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesByAmountOfModifiedCode.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesByAmountOfModifiedCode.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesByAmountOfModifiedCode.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesByTheNumberOfPushes.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesByTheNumberOfPushes.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesByTheNumberOfPushes.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesByTheNumberOfPushes.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithClickhouse_related_comments1.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithClickhouse_related_comments1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithClickhouse_related_comments1.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithClickhouse_related_comments1.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithClickhouse_related_comments2.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithClickhouse_related_comments2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithClickhouse_related_comments2.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithClickhouse_related_comments2.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithDoris_related_comments1.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithDoris_related_comments1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithDoris_related_comments1.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithDoris_related_comments1.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithDoris_related_comments2.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithDoris_related_comments2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithDoris_related_comments2.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithDoris_related_comments2.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithTheHighestGrowthYoY.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithTheHighestGrowthYoY.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues1.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues1.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues2.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues2.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues3.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues3.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues4.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues4.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumAmountOfPullRequests1.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumAmountOfPullRequests1.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumAmountOfPullRequests2.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumAmountOfPullRequests2.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithTheMostStarsOverOneDay1.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithTheMostStarsOverOneDay1.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay1.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithTheMostSteadyGrowthOverTime.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMostSteadyGrowthOverTime.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithTheMostSteadyGrowthOverTime.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithTheMostSteadyGrowthOverTime.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoriesWithTheWorstStagnation_order.out
 
b/regression-test/data/variant_github_events_p2/sql/repositoriesWithTheWorstStagnation_order.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoriesWithTheWorstStagnation_order.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoriesWithTheWorstStagnation_order.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoryAffinityList1.out 
b/regression-test/data/variant_github_events_p2/sql/repositoryAffinityList1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoryAffinityList1.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoryAffinityList1.out
diff --git 
a/regression-test/data/variant_github_events_p2/repositoryAffinityList2.out 
b/regression-test/data/variant_github_events_p2/sql/repositoryAffinityList2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/repositoryAffinityList2.out
rename to 
regression-test/data/variant_github_events_p2/sql/repositoryAffinityList2.out
diff --git 
a/regression-test/data/variant_github_events_p2/starsFromHeavyGithubUsers1.out 
b/regression-test/data/variant_github_events_p2/sql/starsFromHeavyGithubUsers1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/starsFromHeavyGithubUsers1.out
rename to 
regression-test/data/variant_github_events_p2/sql/starsFromHeavyGithubUsers1.out
diff --git 
a/regression-test/data/variant_github_events_p2/starsFromHeavyGithubUsers2.out 
b/regression-test/data/variant_github_events_p2/sql/starsFromHeavyGithubUsers2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/starsFromHeavyGithubUsers2.out
rename to 
regression-test/data/variant_github_events_p2/sql/starsFromHeavyGithubUsers2.out
diff --git 
a/regression-test/data/variant_github_events_p2/theLongestRepositoryNames1.out 
b/regression-test/data/variant_github_events_p2/sql/theLongestRepositoryNames1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/theLongestRepositoryNames1.out
rename to 
regression-test/data/variant_github_events_p2/sql/theLongestRepositoryNames1.out
diff --git 
a/regression-test/data/variant_github_events_p2/theLongestRepositoryNames2.out 
b/regression-test/data/variant_github_events_p2/sql/theLongestRepositoryNames2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/theLongestRepositoryNames2.out
rename to 
regression-test/data/variant_github_events_p2/sql/theLongestRepositoryNames2.out
diff --git 
a/regression-test/data/variant_github_events_p2/theMostToughCodeReviews.out 
b/regression-test/data/variant_github_events_p2/sql/theMostToughCodeReviews.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/theMostToughCodeReviews.out
rename to 
regression-test/data/variant_github_events_p2/sql/theMostToughCodeReviews.out
diff --git 
a/regression-test/data/variant_github_events_p2/theTotalNumberOfRepositoriesOnGithub.out
 
b/regression-test/data/variant_github_events_p2/sql/theTotalNumberOfRepositoriesOnGithub.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/theTotalNumberOfRepositoriesOnGithub.out
rename to 
regression-test/data/variant_github_events_p2/sql/theTotalNumberOfRepositoriesOnGithub.out
diff --git 
a/regression-test/data/variant_github_events_p2/theTotalNumberOfUsersOnGithub1.out
 
b/regression-test/data/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/theTotalNumberOfUsersOnGithub1.out
rename to 
regression-test/data/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub1.out
diff --git 
a/regression-test/data/variant_github_events_p2/theTotalNumberOfUsersOnGithub2.out
 
b/regression-test/data/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/theTotalNumberOfUsersOnGithub2.out
rename to 
regression-test/data/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub2.out
diff --git 
a/regression-test/data/variant_github_events_p2/theTotalNumberOfUsersOnGithub3.out
 
b/regression-test/data/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub3.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/theTotalNumberOfUsersOnGithub3.out
rename to 
regression-test/data/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub3.out
diff --git 
a/regression-test/data/variant_github_events_p2/theTotalNumberOfUsersOnGithub4.out
 
b/regression-test/data/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub4.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/theTotalNumberOfUsersOnGithub4.out
rename to 
regression-test/data/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub4.out
diff --git 
a/regression-test/data/variant_github_events_p2/topRepositoriesByStars.out 
b/regression-test/data/variant_github_events_p2/sql/topRepositoriesByStars.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/topRepositoriesByStars.out
rename to 
regression-test/data/variant_github_events_p2/sql/topRepositoriesByStars.out
diff --git 
a/regression-test/data/variant_github_events_p2/whatIsTheBestDayOfTheWeekToCatchAStar.out
 
b/regression-test/data/variant_github_events_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/whatIsTheBestDayOfTheWeekToCatchAStar.out
rename to 
regression-test/data/variant_github_events_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
diff --git 
a/regression-test/data/variant_github_events_p2/whoAreAllThosePeopleGivingStars1.out
 
b/regression-test/data/variant_github_events_p2/sql/whoAreAllThosePeopleGivingStars1.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/whoAreAllThosePeopleGivingStars1.out
rename to 
regression-test/data/variant_github_events_p2/sql/whoAreAllThosePeopleGivingStars1.out
diff --git 
a/regression-test/data/variant_github_events_p2/whoAreAllThosePeopleGivingStars2.out
 
b/regression-test/data/variant_github_events_p2/sql/whoAreAllThosePeopleGivingStars2.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/whoAreAllThosePeopleGivingStars2.out
rename to 
regression-test/data/variant_github_events_p2/sql/whoAreAllThosePeopleGivingStars2.out
diff --git 
a/regression-test/data/variant_github_events_p2/whoAreAllThosePeopleGivingStars3.out
 
b/regression-test/data/variant_github_events_p2/sql/whoAreAllThosePeopleGivingStars3.out
similarity index 100%
rename from 
regression-test/data/variant_github_events_p2/whoAreAllThosePeopleGivingStars3.out
rename to 
regression-test/data/variant_github_events_p2/sql/whoAreAllThosePeopleGivingStars3.out
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/affinityByIssuesAndPRs1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/affinityByIssuesAndPRs1.sql
deleted file mode 100644
index 043ff99f6a0..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/affinityByIssuesAndPRs1.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    cast(v["repo"]["name"] as string) as repo_name,
-    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 repo_name
-ORDER BY authors DESC, prs DESC, repo_name DESC
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/affinityByIssuesAndPRs2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/affinityByIssuesAndPRs2.sql
deleted file mode 100644
index b3cf37124fc..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/affinityByIssuesAndPRs2.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    cast(v["repo"]["name"] as string) as repo_name,
-    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 repo_name 
-ORDER BY authors DESC, prs DESC, repo_name ASC
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/authorsWithTheMostPushes.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/authorsWithTheMostPushes.sql
deleted file mode 100644
index 637dba7f620..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/authorsWithTheMostPushes.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-      cast(v["actor"]["login"] as string) as actor_login,
-      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 actor_login
-  ORDER BY c DESC, 1, 3
-  LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/countingStar1.sql 
b/regression-test/suites/variant_github_events_new_p2/sql/countingStar1.sql
deleted file mode 100644
index cae7d585bf0..00000000000
--- a/regression-test/suites/variant_github_events_new_p2/sql/countingStar1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ count() FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent'
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/countingStar2.sql 
b/regression-test/suites/variant_github_events_new_p2/sql/countingStar2.sql
deleted file mode 100644
index 15bc6efe169..00000000000
--- a/regression-test/suites/variant_github_events_new_p2/sql/countingStar2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["payload"]["action"] as string) as payload_action, count() FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' GROUP BY 
payload_action
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/countingStar3.sql 
b/regression-test/suites/variant_github_events_new_p2/sql/countingStar3.sql
deleted file mode 100644
index 172967acbfd..00000000000
--- a/regression-test/suites/variant_github_events_new_p2/sql/countingStar3.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 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_new_p2/sql/distributionOfRepositoriesByStarCount.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/distributionOfRepositoriesByStarCount.sql
deleted file mode 100644
index 5dbec453df9..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/distributionOfRepositoriesByStarCount.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    pow(10, floor(log10(c))) AS stars,
-    count(distinct repo)
-FROM
-(
-    SELECT
-        cast(v["repo"]["name"] as string) as repo,
-        count() AS c
-    FROM github_events
-    WHERE cast(v["type"] as string) = 'WatchEvent'
-    GROUP BY repo
-) t
-GROUP BY stars
-ORDER BY stars ASC
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/githubRoulette.sql 
b/regression-test/suites/variant_github_events_new_p2/sql/githubRoulette.sql
deleted file mode 100644
index 20cd59b11ec..00000000000
--- a/regression-test/suites/variant_github_events_new_p2/sql/githubRoulette.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
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_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
deleted file mode 100644
index e3f1053a6be..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, count() AS stars FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' AND 
year(cast(v["created_at"] as datetime)) = '2015' GROUP BY repo_name ORDER BY 
stars DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
deleted file mode 100644
index e3f1053a6be..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, count() AS stars FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' AND 
year(cast(v["created_at"] as datetime)) = '2015' GROUP BY repo_name ORDER BY 
stars DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
deleted file mode 100644
index f68bdcfbf0e..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, count() AS stars FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' AND 
year(cast(v["created_at"] as datetime)) = '2015' GROUP BY repo_name ORDER BY 
stars, repo_name DESC LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
deleted file mode 100644
index e3f1053a6be..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, count() AS stars FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' AND 
year(cast(v["created_at"] as datetime)) = '2015' GROUP BY repo_name ORDER BY 
stars DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
deleted file mode 100644
index e3f1053a6be..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, count() AS stars FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' AND 
year(cast(v["created_at"] as datetime)) = '2015' GROUP BY repo_name ORDER BY 
stars DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
deleted file mode 100644
index e3f1053a6be..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, count() AS stars FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' AND 
year(cast(v["created_at"] as datetime)) = '2015' GROUP BY repo_name ORDER BY 
stars DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
deleted file mode 100644
index 8f7e3f7b36f..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
+++ /dev/null
@@ -1,30 +0,0 @@
--- FIXME: UNSTABLE
--- SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
---     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_new_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.sql
deleted file mode 100644
index f0d95d00ead..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
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_new_p2/sql/issuesWithTheMostComments1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments1.sql
deleted file mode 100644
index 5c0e58e47ef..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ count() FROM 
github_events WHERE cast(v["type"] as string) = 'IssueCommentEvent'
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments2.sql
deleted file mode 100644
index bb12557117b..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, count() FROM github_events 
WHERE cast(v["type"] as string) = 'IssueCommentEvent' GROUP BY repo_name ORDER 
BY count() DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments3.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments3.sql
deleted file mode 100644
index 1ab1e2969bf..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments3.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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 repo_name
-) t
-ORDER BY comments DESC, 1, 3, 4
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments4.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments4.sql
deleted file mode 100644
index 62bba924a99..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments4.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    cast(v["repo"]["name"] as string) as repo_name,
-    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 repo_name, number 
-ORDER BY comments DESC, number ASC, 1
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments5.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments5.sql
deleted file mode 100644
index fb8f3866328..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments5.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    cast(v["repo"]["name"] as string) as repo_name,
-    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 repo_name, number
-ORDER BY comments DESC, repo_name, number
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments6.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments6.sql
deleted file mode 100644
index 3782b46cd00..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments6.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    cast(v["repo"]["name"] as string) as repo_name,
-    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 repo_name, number
-HAVING authors >= 4
-ORDER BY comments DESC, repo_name
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments7.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments7.sql
deleted file mode 100644
index b429dcc8bfe..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments7.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    cast(v["repo"]["name"] as string) as repo_name,
-    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 repo_name
-ORDER BY count() DESC, 1, 3
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments8.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments8.sql
deleted file mode 100644
index 762a7dec440..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/issuesWithTheMostComments8.sql
+++ /dev/null
@@ -1,13 +0,0 @@
--- SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
---     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_new_p2/sql/mostForkedRepositories.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/mostForkedRepositories.sql
deleted file mode 100644
index f0ccb6e2c3d..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/mostForkedRepositories.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, count() AS forks FROM 
github_events WHERE cast(v["type"] as string) = 'ForkEvent' GROUP BY repo_name 
ORDER BY forks DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/mostPopularCommentsOnGithub.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/mostPopularCommentsOnGithub.sql
deleted file mode 100644
index 8b7094ac153..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/mostPopularCommentsOnGithub.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["payload"]["comment"]["body"] as string) as comment_body, count() FROM 
github_events WHERE cast(v["payload"]["comment"]["body"] as string) != "" AND 
length(cast(v["payload"]["comment"]["body"] as string)) < 100 GROUP BY 
comment_body  ORDER BY count(), 1 DESC LIMIT 50
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/organizationsByTheNumberOfRepositories.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/organizationsByTheNumberOfRepositories.sql
deleted file mode 100644
index f6d653413c3..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/organizationsByTheNumberOfRepositories.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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 repo_name 
-    HAVING count() >= 10
-) t
-GROUP BY org
-ORDER BY repos DESC, org ASC
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/organizationsByTheNumberOfStars.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/organizationsByTheNumberOfStars.sql
deleted file mode 100644
index 04b55d39e51..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/organizationsByTheNumberOfStars.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/organizationsByTheSizeOfCommunity.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/organizationsByTheSizeOfCommunity.sql
deleted file mode 100644
index e0352afc55f..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/organizationsByTheSizeOfCommunity.sql
+++ /dev/null
@@ -1,23 +0,0 @@
--- SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
---     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_new_p2/sql/proportionsBetweenStarsAndForks1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks1.sql
deleted file mode 100644
index 9e3f2875ef2..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks1.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/proportionsBetweenStarsAndForks2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks2.sql
deleted file mode 100644
index 2e1cb1b9c1f..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks2.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/proportionsBetweenStarsAndForks3.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks3.sql
deleted file mode 100644
index 6f91ab15eb9..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks3.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/proportionsBetweenStarsAndForks4.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks4.sql
deleted file mode 100644
index 8be41f09497..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks4.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/proportionsBetweenStarsAndForks5.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks5.sql
deleted file mode 100644
index 26bfb2ac630..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/proportionsBetweenStarsAndForks5.sql
+++ /dev/null
@@ -1,21 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/repositoriesByTheNumberOfPushes.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesByTheNumberOfPushes.sql
deleted file mode 100644
index 6db36e257c5..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesByTheNumberOfPushes.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    cast(v["repo"]["name"] as string) as repo_name,
-    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) as repo_name
-    FROM github_events
-    WHERE cast(v["type"] as string) = 'WatchEvent'
-    GROUP BY repo_name
-    ORDER BY count() DESC
-    LIMIT 10000
-))
-GROUP BY repo_name
-ORDER BY count() DESC, repo_name
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithClickhouse_related_comments1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithClickhouse_related_comments1.sql
deleted file mode 100644
index 254888d0e11..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithClickhouse_related_comments1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, count() FROM github_events 
WHERE lower(cast(v["payload"]["comment"]["body"] as string)) LIKE '%apache%' 
GROUP BY repo_name ORDER BY count() DESC, repo_name ASC LIMIT 50
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithClickhouse_related_comments2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithClickhouse_related_comments2.sql
deleted file mode 100644
index 90ef187ba35..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithClickhouse_related_comments2.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/repositoriesWithDoris_related_comments1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithDoris_related_comments1.sql
deleted file mode 100644
index 90a73db9ca3..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithDoris_related_comments1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, count() FROM github_events 
WHERE lower(cast(v["payload"]["comment"]["body"] as string)) LIKE '%spark%' 
GROUP BY repo_name ORDER BY count() DESC, repo_name ASC LIMIT 50
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithDoris_related_comments2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithDoris_related_comments2.sql
deleted file mode 100644
index 28c44705455..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithDoris_related_comments2.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/repositoriesWithTheHighestGrowthYoY.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheHighestGrowthYoY.sql
deleted file mode 100644
index 47d3ad8417d..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheHighestGrowthYoY.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
deleted file mode 100644
index d93b20c783f..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, 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 repo_name ORDER BY c DESC, repo_name LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
deleted file mode 100644
index 5703e50af8f..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.sql
deleted file mode 100644
index 32014cb4c19..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.sql
+++ /dev/null
@@ -1,19 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.sql
deleted file mode 100644
index 484d8b50ea8..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.sql
deleted file mode 100644
index 688d42ec6a9..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
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 repo_name ORDER BY 2,1,3 DESC LIMIT 50
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.sql
deleted file mode 100644
index e4b3b388e24..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, 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 repo_name ORDER BY u DESC, 2 DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
deleted file mode 100644
index f6672875578..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
deleted file mode 100644
index d31a0f38a54..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
deleted file mode 100644
index 5849b3527d3..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
+++ /dev/null
@@ -1,13 +0,0 @@
--- SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
---     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_new_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
deleted file mode 100644
index b3b2133eb29..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
+++ /dev/null
@@ -1,16 +0,0 @@
--- SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
---     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_new_p2/sql/repositoriesWithTheMostStarsOverOneDay1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostStarsOverOneDay1.sql
deleted file mode 100644
index dcf6eb23235..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostStarsOverOneDay1.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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 repo_name, day
-    ) t1
-) t2
-WHERE rank = 1
-ORDER BY stars DESC, 1
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostStarsOverOneDay2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostStarsOverOneDay2.sql
deleted file mode 100644
index 66a7ab7cba5..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostStarsOverOneDay2.sql
+++ /dev/null
@@ -1,25 +0,0 @@
--- SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
---     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_new_p2/sql/repositoriesWithTheMostStarsOverOneDay3.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostStarsOverOneDay3.sql
deleted file mode 100644
index 1bfa7869399..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostStarsOverOneDay3.sql
+++ /dev/null
@@ -1 +0,0 @@
--- SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
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_new_p2/sql/repositoriesWithTheMostSteadyGrowthOverTime.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostSteadyGrowthOverTime.sql
deleted file mode 100644
index d1abdfd9dd4..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheMostSteadyGrowthOverTime.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/repositoriesWithTheWorstStagnation_order.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheWorstStagnation_order.sql
deleted file mode 100644
index a4c09020695..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesWithTheWorstStagnation_order.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/repositoryAffinityList1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoryAffinityList1.sql
deleted file mode 100644
index f75b3d0d493..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoryAffinityList1.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-  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_new_p2/sql/repositoryAffinityList2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/repositoryAffinityList2.sql
deleted file mode 100644
index 6f5ae4cbb33..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoryAffinityList2.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-  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_new_p2/sql/starsFromHeavyGithubUsers1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/starsFromHeavyGithubUsers1.sql
deleted file mode 100644
index 0cd0b5ade50..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/starsFromHeavyGithubUsers1.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    cast(v["repo"]["name"] as string) as repo_name,
-    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 repo_name
-ORDER BY count() DESC, repo_name
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/starsFromHeavyGithubUsers2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/starsFromHeavyGithubUsers2.sql
deleted file mode 100644
index d230a3186fb..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/starsFromHeavyGithubUsers2.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    cast(v["repo"]["name"] as string) as repo_name,
-    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) as actor_login
-    FROM github_events
-    WHERE (cast(v["type"] as string) = 'PullRequestEvent') AND 
(cast(v["payload"]["action"] as string) = 'opened')
-    GROUP BY actor_login
-    HAVING count() >= 2
-))
-GROUP BY repo_name
-ORDER BY 1, count() DESC, 1
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/test_distinct_streaming_agg.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/test_distinct_streaming_agg.sql
deleted file mode 100644
index 40854a2d535..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/test_distinct_streaming_agg.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-SELECT
-    
/*+SET_VAR(batch_size=50,experimental_enable_pipeline_x_engine=false,parallel_pipeline_task_num=1,disable_streaming_preaggregations=false)
 */
-    count(distinct v)
-FROM
-    github_events_2;
\ No newline at end of file
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/theLongestRepositoryNames1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/theLongestRepositoryNames1.sql
deleted file mode 100644
index 4644f27b54f..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/theLongestRepositoryNames1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ count(), 
cast(v["repo"]["name"] as string) as repo_name FROM github_events WHERE 
cast(v["type"] as string) = 'WatchEvent' GROUP BY repo_name ORDER BY 
length(repo_name) DESC, repo_name LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/theLongestRepositoryNames2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/theLongestRepositoryNames2.sql
deleted file mode 100644
index ee34ddfaae0..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/theLongestRepositoryNames2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, count() FROM github_events 
WHERE cast(v["type"] as string) = 'WatchEvent' AND cast(v["repo"]["name"] as 
string) LIKE '%_/_%' GROUP BY repo_name ORDER BY length(repo_name) ASC, 
repo_name LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/theMostToughCodeReviews.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/theMostToughCodeReviews.sql
deleted file mode 100644
index 29cf3d807c3..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/theMostToughCodeReviews.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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_new_p2/sql/theTotalNumberOfRepositoriesOnGithub.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/theTotalNumberOfRepositoriesOnGithub.sql
deleted file mode 100644
index e10d25749b4..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/theTotalNumberOfRepositoriesOnGithub.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ count(distinct 
cast(v["repo"]["name"] as string)) FROM github_events
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub1.sql
deleted file mode 100644
index fe5f1956c79..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ count(distinct 
cast(v["actor"]["login"] as string)) FROM github_events
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub2.sql
deleted file mode 100644
index 72dccfb12d6..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 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_new_p2/sql/theTotalNumberOfUsersOnGithub3.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub3.sql
deleted file mode 100644
index ce96a89bd27..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub3.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 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_new_p2/sql/theTotalNumberOfUsersOnGithub4.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub4.sql
deleted file mode 100644
index 53e611219f3..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/theTotalNumberOfUsersOnGithub4.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 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_new_p2/sql/topLabels1.sql 
b/regression-test/suites/variant_github_events_new_p2/sql/topLabels1.sql
deleted file mode 100644
index eb6dd56d26c..00000000000
--- a/regression-test/suites/variant_github_events_new_p2/sql/topLabels1.sql
+++ /dev/null
@@ -1,9 +0,0 @@
--- SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
---     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_new_p2/sql/topLabels2.sql 
b/regression-test/suites/variant_github_events_new_p2/sql/topLabels2.sql
deleted file mode 100644
index d04bded901d..00000000000
--- a/regression-test/suites/variant_github_events_new_p2/sql/topLabels2.sql
+++ /dev/null
@@ -1,9 +0,0 @@
--- SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
---     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_new_p2/sql/topLabels3.sql 
b/regression-test/suites/variant_github_events_new_p2/sql/topLabels3.sql
deleted file mode 100644
index f35116aaa6d..00000000000
--- a/regression-test/suites/variant_github_events_new_p2/sql/topLabels3.sql
+++ /dev/null
@@ -1,14 +0,0 @@
--- SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
---     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_new_p2/sql/topRepositoriesByStars.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/topRepositoriesByStars.sql
deleted file mode 100644
index 41eec01ee97..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/topRepositoriesByStars.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["repo"]["name"] as string) as repo_name, count() AS stars FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' GROUP BY repo_name 
ORDER BY stars DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql
deleted file mode 100644
index c0d4576ce60..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
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_new_p2/sql/whoAreAllThosePeopleGivingStars1.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars1.sql
deleted file mode 100644
index 91f18664560..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars1.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["actor"]["login"] as string) as actor_login, count() AS stars FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' GROUP BY 
actor_login ORDER BY stars DESC, 1 LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars2.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars2.sql
deleted file mode 100644
index 30a9ea294cc..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars2.sql
+++ /dev/null
@@ -1 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */ 
cast(v["actor"]["login"] as string) as actor_login, count() AS stars FROM 
github_events WHERE cast(v["type"] as string) = 'WatchEvent' AND 
cast(v["actor"]["login"] as string) = 'cliffordfajardo' GROUP BY actor_login 
ORDER BY stars DESC LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars3.sql
 
b/regression-test/suites/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars3.sql
deleted file mode 100644
index 524737737b6..00000000000
--- 
a/regression-test/suites/variant_github_events_new_p2/sql/whoAreAllThosePeopleGivingStars3.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-SELECT /*+SET_VAR(enable_fallback_to_original_planner=false) */
-    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["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 repo_name 
-ORDER BY stars DESC, repo_name
-LIMIT 50
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesByAmountOfModifiedCode.sql
 
b/regression-test/suites/variant_github_events_p2/repositoriesByAmountOfModifiedCode.sql
deleted file mode 100644
index 6c1632769f3..00000000000
--- 
a/regression-test/suites/variant_github_events_p2/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_p2/affinityByIssuesAndPRs1.sql 
b/regression-test/suites/variant_github_events_p2/sql/affinityByIssuesAndPRs1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/affinityByIssuesAndPRs1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/affinityByIssuesAndPRs1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/affinityByIssuesAndPRs2.sql 
b/regression-test/suites/variant_github_events_p2/sql/affinityByIssuesAndPRs2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/affinityByIssuesAndPRs2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/affinityByIssuesAndPRs2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/authorsWithTheMostPushes.sql 
b/regression-test/suites/variant_github_events_p2/sql/authorsWithTheMostPushes.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/authorsWithTheMostPushes.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/authorsWithTheMostPushes.sql
diff --git a/regression-test/suites/variant_github_events_p2/countingStar1.sql 
b/regression-test/suites/variant_github_events_p2/sql/countingStar1.sql
similarity index 100%
rename from regression-test/suites/variant_github_events_p2/countingStar1.sql
rename to regression-test/suites/variant_github_events_p2/sql/countingStar1.sql
diff --git a/regression-test/suites/variant_github_events_p2/countingStar2.sql 
b/regression-test/suites/variant_github_events_p2/sql/countingStar2.sql
similarity index 100%
rename from regression-test/suites/variant_github_events_p2/countingStar2.sql
rename to regression-test/suites/variant_github_events_p2/sql/countingStar2.sql
diff --git a/regression-test/suites/variant_github_events_p2/countingStar3.sql 
b/regression-test/suites/variant_github_events_p2/sql/countingStar3.sql
similarity index 100%
rename from regression-test/suites/variant_github_events_p2/countingStar3.sql
rename to regression-test/suites/variant_github_events_p2/sql/countingStar3.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/distributionOfRepositoriesByStarCount.sql
 
b/regression-test/suites/variant_github_events_p2/sql/distributionOfRepositoriesByStarCount.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/distributionOfRepositoriesByStarCount.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/distributionOfRepositoriesByStarCount.sql
diff --git a/regression-test/suites/variant_github_events_p2/githubRoulette.sql 
b/regression-test/suites/variant_github_events_p2/sql/githubRoulette.sql
similarity index 100%
rename from regression-test/suites/variant_github_events_p2/githubRoulette.sql
rename to regression-test/suites/variant_github_events_p2/sql/githubRoulette.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
 
b/regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
 
b/regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
 
b/regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
 
b/regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
 
b/regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/howHasTheTotalNumberOfStarsChangedOverTime.sql
 
b/regression-test/suites/variant_github_events_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/howHasTheTotalNumberOfStarsChangedOverTime.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/issuesWithTheMostComments1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/issuesWithTheMostComments1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/issuesWithTheMostComments2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/issuesWithTheMostComments2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/issuesWithTheMostComments3.sql
 
b/regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments3.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/issuesWithTheMostComments3.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments3.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/issuesWithTheMostComments4.sql
 
b/regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments4.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/issuesWithTheMostComments4.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments4.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/issuesWithTheMostComments5.sql
 
b/regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments5.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/issuesWithTheMostComments5.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments5.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/issuesWithTheMostComments6.sql
 
b/regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments6.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/issuesWithTheMostComments6.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments6.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/issuesWithTheMostComments7.sql
 
b/regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments7.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/issuesWithTheMostComments7.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments7.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/issuesWithTheMostComments8.sql
 
b/regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments8.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/issuesWithTheMostComments8.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/issuesWithTheMostComments8.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/mostForkedRepositories.sql 
b/regression-test/suites/variant_github_events_p2/sql/mostForkedRepositories.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/mostForkedRepositories.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/mostForkedRepositories.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/mostPopularCommentsOnGithub.sql
 
b/regression-test/suites/variant_github_events_p2/sql/mostPopularCommentsOnGithub.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/mostPopularCommentsOnGithub.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/mostPopularCommentsOnGithub.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/organizationsByTheNumberOfRepositories.sql
 
b/regression-test/suites/variant_github_events_p2/sql/organizationsByTheNumberOfRepositories.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/organizationsByTheNumberOfRepositories.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/organizationsByTheNumberOfRepositories.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/organizationsByTheNumberOfStars.sql
 
b/regression-test/suites/variant_github_events_p2/sql/organizationsByTheNumberOfStars.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/organizationsByTheNumberOfStars.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/organizationsByTheNumberOfStars.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/organizationsByTheSizeOfCommunity.sql
 
b/regression-test/suites/variant_github_events_p2/sql/organizationsByTheSizeOfCommunity.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/organizationsByTheSizeOfCommunity.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/organizationsByTheSizeOfCommunity.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/proportionsBetweenStarsAndForks1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/proportionsBetweenStarsAndForks1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/proportionsBetweenStarsAndForks1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/proportionsBetweenStarsAndForks1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/proportionsBetweenStarsAndForks2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/proportionsBetweenStarsAndForks2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/proportionsBetweenStarsAndForks2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/proportionsBetweenStarsAndForks2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/proportionsBetweenStarsAndForks3.sql
 
b/regression-test/suites/variant_github_events_p2/sql/proportionsBetweenStarsAndForks3.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/proportionsBetweenStarsAndForks3.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/proportionsBetweenStarsAndForks3.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/proportionsBetweenStarsAndForks4.sql
 
b/regression-test/suites/variant_github_events_p2/sql/proportionsBetweenStarsAndForks4.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/proportionsBetweenStarsAndForks4.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/proportionsBetweenStarsAndForks4.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/proportionsBetweenStarsAndForks5.sql
 
b/regression-test/suites/variant_github_events_p2/sql/proportionsBetweenStarsAndForks5.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/proportionsBetweenStarsAndForks5.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/proportionsBetweenStarsAndForks5.sql
diff --git 
a/regression-test/suites/variant_github_events_new_p2/sql/repositoriesByAmountOfModifiedCode.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesByAmountOfModifiedCode.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_new_p2/sql/repositoriesByAmountOfModifiedCode.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesByAmountOfModifiedCode.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesByTheNumberOfPushes.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesByTheNumberOfPushes.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesByTheNumberOfPushes.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesByTheNumberOfPushes.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithClickhouse_related_comments1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithClickhouse_related_comments1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithClickhouse_related_comments1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithClickhouse_related_comments1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithClickhouse_related_comments2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithClickhouse_related_comments2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithClickhouse_related_comments2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithClickhouse_related_comments2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithDoris_related_comments1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithDoris_related_comments1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithDoris_related_comments1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithDoris_related_comments1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithDoris_related_comments2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithDoris_related_comments2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithDoris_related_comments2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithDoris_related_comments2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheHighestGrowthYoY.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheHighestGrowthYoY.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues3.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues3.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues4.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumAmountOfIssues4.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumAmountOfPullRequests1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumAmountOfPullRequests1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumAmountOfPullRequests2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumAmountOfPullRequests2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMostStarsOverOneDay1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMostStarsOverOneDay1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMostStarsOverOneDay2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMostStarsOverOneDay2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMostStarsOverOneDay3.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay3.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMostStarsOverOneDay3.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay3.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheMostSteadyGrowthOverTime.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostSteadyGrowthOverTime.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheMostSteadyGrowthOverTime.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheMostSteadyGrowthOverTime.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoriesWithTheWorstStagnation_order.sql
 
b/regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheWorstStagnation_order.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoriesWithTheWorstStagnation_order.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoriesWithTheWorstStagnation_order.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoryAffinityList1.sql 
b/regression-test/suites/variant_github_events_p2/sql/repositoryAffinityList1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoryAffinityList1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoryAffinityList1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/repositoryAffinityList2.sql 
b/regression-test/suites/variant_github_events_p2/sql/repositoryAffinityList2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/repositoryAffinityList2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/repositoryAffinityList2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/starsFromHeavyGithubUsers1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/starsFromHeavyGithubUsers1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/starsFromHeavyGithubUsers1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/starsFromHeavyGithubUsers1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/starsFromHeavyGithubUsers2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/starsFromHeavyGithubUsers2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/starsFromHeavyGithubUsers2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/starsFromHeavyGithubUsers2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/theLongestRepositoryNames1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/theLongestRepositoryNames1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/theLongestRepositoryNames1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/theLongestRepositoryNames1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/theLongestRepositoryNames2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/theLongestRepositoryNames2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/theLongestRepositoryNames2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/theLongestRepositoryNames2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/theMostToughCodeReviews.sql 
b/regression-test/suites/variant_github_events_p2/sql/theMostToughCodeReviews.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/theMostToughCodeReviews.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/theMostToughCodeReviews.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/theTotalNumberOfRepositoriesOnGithub.sql
 
b/regression-test/suites/variant_github_events_p2/sql/theTotalNumberOfRepositoriesOnGithub.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/theTotalNumberOfRepositoriesOnGithub.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/theTotalNumberOfRepositoriesOnGithub.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/theTotalNumberOfUsersOnGithub1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/theTotalNumberOfUsersOnGithub1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/theTotalNumberOfUsersOnGithub2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/theTotalNumberOfUsersOnGithub2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/theTotalNumberOfUsersOnGithub3.sql
 
b/regression-test/suites/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub3.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/theTotalNumberOfUsersOnGithub3.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub3.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/theTotalNumberOfUsersOnGithub4.sql
 
b/regression-test/suites/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub4.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/theTotalNumberOfUsersOnGithub4.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/theTotalNumberOfUsersOnGithub4.sql
diff --git a/regression-test/suites/variant_github_events_p2/topLabels1.sql 
b/regression-test/suites/variant_github_events_p2/sql/topLabels1.sql
similarity index 100%
rename from regression-test/suites/variant_github_events_p2/topLabels1.sql
rename to regression-test/suites/variant_github_events_p2/sql/topLabels1.sql
diff --git a/regression-test/suites/variant_github_events_p2/topLabels2.sql 
b/regression-test/suites/variant_github_events_p2/sql/topLabels2.sql
similarity index 100%
rename from regression-test/suites/variant_github_events_p2/topLabels2.sql
rename to regression-test/suites/variant_github_events_p2/sql/topLabels2.sql
diff --git a/regression-test/suites/variant_github_events_p2/topLabels3.sql 
b/regression-test/suites/variant_github_events_p2/sql/topLabels3.sql
similarity index 100%
rename from regression-test/suites/variant_github_events_p2/topLabels3.sql
rename to regression-test/suites/variant_github_events_p2/sql/topLabels3.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/topRepositoriesByStars.sql 
b/regression-test/suites/variant_github_events_p2/sql/topRepositoriesByStars.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/topRepositoriesByStars.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/topRepositoriesByStars.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/whatIsTheBestDayOfTheWeekToCatchAStar.sql
 
b/regression-test/suites/variant_github_events_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/whatIsTheBestDayOfTheWeekToCatchAStar.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/whoAreAllThosePeopleGivingStars1.sql
 
b/regression-test/suites/variant_github_events_p2/sql/whoAreAllThosePeopleGivingStars1.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/whoAreAllThosePeopleGivingStars1.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/whoAreAllThosePeopleGivingStars1.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/whoAreAllThosePeopleGivingStars2.sql
 
b/regression-test/suites/variant_github_events_p2/sql/whoAreAllThosePeopleGivingStars2.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/whoAreAllThosePeopleGivingStars2.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/whoAreAllThosePeopleGivingStars2.sql
diff --git 
a/regression-test/suites/variant_github_events_p2/whoAreAllThosePeopleGivingStars3.sql
 
b/regression-test/suites/variant_github_events_p2/sql/whoAreAllThosePeopleGivingStars3.sql
similarity index 100%
rename from 
regression-test/suites/variant_github_events_p2/whoAreAllThosePeopleGivingStars3.sql
rename to 
regression-test/suites/variant_github_events_p2/sql/whoAreAllThosePeopleGivingStars3.sql


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

(doris) branch branch-2.1 updated: branch-2.1: [chore](regression-test) move some variant cases to directory #45169 (#45259)

Reply via email to