aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorОлег <150132506+iddqdex@users.noreply.github.com>2025-05-22 18:27:40 +0300
committerGitHub <noreply@github.com>2025-05-22 17:27:40 +0200
commita821759a6a7e2af10c29fec408d523f7e71b37cc (patch)
tree8ffdf6a84f15177ea571d6518004bbcb40cb5163
parent77f15659733a40d1f5f74739c2881026d6879dcc (diff)
downloadydb-a821759a6a7e2af10c29fec408d523f7e71b37cc.tar.gz
Rm trash results by perfomance_olap_mart.sql (#18686)
-rw-r--r--.github/scripts/analytics/data_mart_queries/perfomance_olap_mart.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/.github/scripts/analytics/data_mart_queries/perfomance_olap_mart.sql b/.github/scripts/analytics/data_mart_queries/perfomance_olap_mart.sql
index 12630831db3..83e6c54516f 100644
--- a/.github/scripts/analytics/data_mart_queries/perfomance_olap_mart.sql
+++ b/.github/scripts/analytics/data_mart_queries/perfomance_olap_mart.sql
@@ -8,7 +8,7 @@ $all_suites = (
Suite,
ListSort(AGG_LIST_DISTINCT(Test)) AS Tests
FROM `perfomance/olap/tests_results`
- WHERE Timestamp >= $start_timestamp
+ WHERE Timestamp >= $start_timestamp and (Suite != 'ExternalA1' or not StartsWith(Test, 'Query'))
GROUP BY Suite
)
FLATTEN LIST BY Tests AS Test
@@ -28,7 +28,7 @@ $launch_times = (
ROW_NUMBER() OVER (PARTITION BY Db, Version ORDER BY Min(RunId) ASC) AS Run_number_in_version,
ROW_NUMBER() OVER (PARTITION BY Db, Branch ORDER BY Min(RunId) DESC) AS Run_number_in_branch_desc
FROM `perfomance/olap/tests_results`
- WHERE Timestamp >= $start_timestamp
+ WHERE Timestamp >= $start_timestamp and (Suite != 'ExternalA1' or not StartsWith(Test, 'Query'))
GROUP BY
Db,
Unicode::SplitToList(JSON_VALUE(Info, "$.cluster.version"), '.')[0] As Branch,
@@ -60,7 +60,7 @@ $all_tests_raw =
)
) AS Color
FROM `perfomance/olap/tests_results` AS tests_results
- WHERE Timestamp >= $start_timestamp;
+ WHERE Timestamp >= $start_timestamp and (Suite != 'ExternalA1' or not StartsWith(Test, 'Query'));
SELECT
Db,