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