You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudberry.apache.org by ma...@apache.org on 2025/02/07 09:28:28 UTC
(cloudberry) 14/34: Add workload for explain pipeline (#15730)
This is an automated email from the ASF dual-hosted git repository.
maxyang pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
commit cf902688ec70db2155e2cfd68784c9adbc8efd72
Author: THANATOSLAVA <99...@users.noreply.github.com>
AuthorDate: Thu Jun 8 17:01:08 2023 -0700
Add workload for explain pipeline (#15730)
workload5 7X stats added to gp-workloads
Co-authored-by: Jingyu Wang <wj...@vmware.com>
---
.../gporca/concourse/test_explain_pipeline.yml | 117 +++++++++++++++++++++
1 file changed, 117 insertions(+)
diff --git a/src/backend/gporca/concourse/test_explain_pipeline.yml b/src/backend/gporca/concourse/test_explain_pipeline.yml
index 25d313cdf8..100eeaadf6 100644
--- a/src/backend/gporca/concourse/test_explain_pipeline.yml
+++ b/src/backend/gporca/concourse/test_explain_pipeline.yml
@@ -154,6 +154,28 @@ resources:
json_key: ((qp/concourse-gcs-resources-orca-service-account-key))
versioned_file: ((pipeline-name))/explain_results/explain_((workload4))_results.tar.gz
+## resources for workload 5
+- name: explain_output_((workload5))_branch
+ type: gcs
+ source:
+ bucket: ((gcs-bucket-orca))
+ json_key: ((qp/concourse-gcs-resources-orca-service-account-key))
+ versioned_file: ((pipeline-name))/explain_intermediate/explain_((workload5))_branch.tar.gz
+
+- name: explain_output_((workload5))_baseline
+ type: gcs
+ source:
+ bucket: ((gcs-bucket-orca))
+ json_key: ((qp/concourse-gcs-resources-orca-service-account-key))
+ versioned_file: ((pipeline-name))/explain_intermediate/explain_((workload5))_baseline.tar.gz
+
+- name: explain_((workload5))_results
+ type: gcs
+ source:
+ bucket: ((gcs-bucket-orca))
+ json_key: ((qp/concourse-gcs-resources-orca-service-account-key))
+ versioned_file: ((pipeline-name))/explain_results/explain_((workload5))_results.tar.gz
+
## resources for workload 6
- name: explain_output_((workload6))_branch
type: gcs
@@ -637,6 +659,101 @@ jobs:
params:
file: diffs/explain_test_results.tar.gz
+## ======================================================================
+## workload5
+## ======================================================================
+
+- name: run_explain_suite_((workload5))
+ max_in_flight: 1
+ plan:
+ - in_parallel:
+ - get: gporca-commits-to-test
+ passed:
+ - compile_branch
+ - get: bin_gpdb
+ passed:
+ - compile_branch
+ resource: bin_gpdb_rhel8_branch
+ trigger: true
+ - get: gpdb_src
+ resource: gpdb_main_src
+ - get: gp_workloads
+ params:
+ disable_git_lfs: true
+ depth: 1
+ - get: gpdb7-rhel8-test
+ - task: run_explain_suite
+ file: gpdb_src/concourse/tasks/run_explain_suite.yml
+ image: gpdb7-rhel8-test
+ params:
+ MODE: orca
+ WORKLOAD: ((workload5))
+ on_success:
+ try:
+ put: explain_output_((workload5))_branch
+ params:
+ file: output/explain_ouput.tar.gz
+
+- name: run_explain_suite_((workload5))_baseline
+ max_in_flight: 1
+ plan:
+ - in_parallel:
+ - get: gporca-commits-to-test
+ passed:
+ - compile_baseline
+ - get: bin_gpdb
+ resource: bin_gpdb_rhel8_baseline
+ passed:
+ - compile_baseline
+ trigger: true
+ - get: gpdb_src
+ resource: gpdb_main_src
+ params:
+ submodules: none
+ - get: gp_workloads
+ params:
+ disable_git_lfs: true
+ depth: 1
+ - get: gpdb7-rhel8-test
+ - task: run_explain_suite_baseline
+ file: gpdb_src/concourse/tasks/run_explain_suite.yml
+ image: gpdb7-rhel8-test
+ params:
+ MODE: orca
+ WORKLOAD: ((workload5))
+ on_success:
+ try:
+ put: explain_output_((workload5))_baseline
+ params:
+ file: output/explain_ouput.tar.gz
+
+- name: diff_explain_results_((workload5))
+ plan:
+ - in_parallel:
+ - get: gporca-commits-to-test
+ passed:
+ - run_explain_suite_((workload5))
+ - run_explain_suite_((workload5))_baseline
+ trigger: true
+ - get: gpdb_src
+ resource: gpdb_main_src
+ params:
+ submodules: none
+ - get: explain_output
+ resource: explain_output_((workload5))_branch
+ passed:
+ - run_explain_suite_((workload5))
+ - get: explain_output_baseline
+ resource: explain_output_((workload5))_baseline
+ passed:
+ - run_explain_suite_((workload5))_baseline
+ - task: diff_explain_results_((workload5))
+ file: gpdb_src/concourse/tasks/diff_explain_results_with_baseline.yml
+ ensure:
+ put: explain_((workload5))_results
+ params:
+ file: diffs/explain_test_results.tar.gz
+
## ======================================================================
## workload6
## ======================================================================
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org