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

pankaj pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/airflow.git


The following commit(s) were added to refs/heads/main by this push:
     new 43f7da702f Add system test and docs for DataprocSubmitJobOperator 
(Trino job) (#32796)
43f7da702f is described below

commit 43f7da702fae7eb5cb185ed5a5ec74f6ed8e4a25
Author: max <[email protected]>
AuthorDate: Wed Jul 26 11:43:39 2023 +0200

    Add system test and docs for DataprocSubmitJobOperator (Trino job) (#32796)
---
 .../operators/cloud/dataproc.rst                   |  24 +++-
 .../cloud/dataproc/example_dataproc_trino.py       | 121 +++++++++++++++++++++
 2 files changed, 143 insertions(+), 2 deletions(-)

diff --git a/docs/apache-airflow-providers-google/operators/cloud/dataproc.rst 
b/docs/apache-airflow-providers-google/operators/cloud/dataproc.rst
index b42cdc7e79..db4ef47d76 100644
--- a/docs/apache-airflow-providers-google/operators/cloud/dataproc.rst
+++ b/docs/apache-airflow-providers-google/operators/cloud/dataproc.rst
@@ -111,6 +111,19 @@ If this is your case, please specify correct 
``image_version`` that you can find
     :start-after: [START how_to_cloud_dataproc_create_cluster]
     :end-before: [END how_to_cloud_dataproc_create_cluster]
 
+You can also create Dataproc cluster with optional component Trino.
+To do so, please use the following configuration.
+Note that default image might not support the chosen optional component.
+If this is your case, please specify correct ``image_version`` that you can 
find in the
+`documentation.  
<https://cloud.google.com/dataproc/docs/concepts/components/overview#available_optional_components>`__
+
+
+.. exampleinclude:: 
/../../tests/system/providers/google/cloud/dataproc/example_dataproc_trino.py
+    :language: python
+    :dedent: 0
+    :start-after: [START how_to_cloud_dataproc_create_cluster]
+    :end-before: [END how_to_cloud_dataproc_create_cluster]
+
 You can use deferrable mode for this action in order to run the operator 
asynchronously:
 
 .. exampleinclude:: 
/../../tests/system/providers/google/cloud/dataproc/example_dataproc_cluster_deferrable.py
@@ -266,8 +279,7 @@ Example of the configuration for a Pig Job:
     :start-after: [START how_to_cloud_dataproc_pig_config]
     :end-before: [END how_to_cloud_dataproc_pig_config]
 
-
-Example of the configuration for a SparkR:
+Example of the configuration for a SparkR Job:
 
 .. exampleinclude:: 
/../../tests/system/providers/google/cloud/dataproc/example_dataproc_sparkr.py
     :language: python
@@ -283,6 +295,14 @@ Example of the configuration for a Presto Job:
     :start-after: [START how_to_cloud_dataproc_presto_config]
     :end-before: [END how_to_cloud_dataproc_presto_config]
 
+Example of the configuration for a Trino Job:
+
+.. exampleinclude:: 
/../../tests/system/providers/google/cloud/dataproc/example_dataproc_trino.py
+    :language: python
+    :dedent: 0
+    :start-after: [START how_to_cloud_dataproc_trino_config]
+    :end-before: [END how_to_cloud_dataproc_trino_config]
+
 Working with workflows templates
 --------------------------------
 
diff --git 
a/tests/system/providers/google/cloud/dataproc/example_dataproc_trino.py 
b/tests/system/providers/google/cloud/dataproc/example_dataproc_trino.py
new file mode 100644
index 0000000000..828f596041
--- /dev/null
+++ b/tests/system/providers/google/cloud/dataproc/example_dataproc_trino.py
@@ -0,0 +1,121 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+"""
+Example Airflow DAG for DataprocSubmitJobOperator with trino job.
+"""
+from __future__ import annotations
+
+import os
+from datetime import datetime
+
+from airflow import models
+from airflow.providers.google.cloud.operators.dataproc import (
+    DataprocCreateClusterOperator,
+    DataprocDeleteClusterOperator,
+    DataprocSubmitJobOperator,
+)
+from airflow.utils.trigger_rule import TriggerRule
+
+ENV_ID = os.environ.get("SYSTEM_TESTS_ENV_ID")
+DAG_ID = "dataproc_trino"
+PROJECT_ID = os.environ.get("SYSTEM_TESTS_GCP_PROJECT")
+
+CLUSTER_NAME = f"cluster-{ENV_ID}-{DAG_ID}".replace("_", "-")
+REGION = "europe-west1"
+
+# Cluster definition
+# [START how_to_cloud_dataproc_create_cluster]
+
+CLUSTER_CONFIG = {
+    "master_config": {
+        "num_instances": 1,
+        "machine_type_uri": "n1-standard-4",
+        "disk_config": {"boot_disk_type": "pd-standard", "boot_disk_size_gb": 
1024},
+    },
+    "worker_config": {
+        "num_instances": 2,
+        "machine_type_uri": "n1-standard-4",
+        "disk_config": {"boot_disk_type": "pd-standard", "boot_disk_size_gb": 
1024},
+    },
+    "software_config": {
+        "optional_components": [
+            "TRINO",
+        ],
+        "image_version": "2.1",
+    },
+}
+
+# [END how_to_cloud_dataproc_create_cluster]
+
+# Jobs definitions
+# [START how_to_cloud_dataproc_trino_config]
+TRINO_JOB = {
+    "reference": {"project_id": PROJECT_ID},
+    "placement": {"cluster_name": CLUSTER_NAME},
+    "trino_job": {"query_list": {"queries": ["SHOW CATALOGS"]}},
+}
+# [END how_to_cloud_dataproc_trino_config]
+
+
+with models.DAG(
+    DAG_ID,
+    schedule="@once",
+    start_date=datetime(2021, 1, 1),
+    catchup=False,
+    tags=["example", "dataproc", "trino"],
+) as dag:
+    create_cluster = DataprocCreateClusterOperator(
+        task_id="create_cluster",
+        project_id=PROJECT_ID,
+        cluster_config=CLUSTER_CONFIG,
+        region=REGION,
+        cluster_name=CLUSTER_NAME,
+    )
+
+    trino_task = DataprocSubmitJobOperator(
+        task_id="trino_task", job=TRINO_JOB, region=REGION, 
project_id=PROJECT_ID
+    )
+
+    delete_cluster = DataprocDeleteClusterOperator(
+        task_id="delete_cluster",
+        project_id=PROJECT_ID,
+        cluster_name=CLUSTER_NAME,
+        region=REGION,
+        trigger_rule=TriggerRule.ALL_DONE,
+    )
+
+    (
+        # TEST SETUP
+        create_cluster
+        # TEST BODY
+        >> trino_task
+        # TEST TEARDOWN
+        >> delete_cluster
+    )
+
+    from tests.system.utils.watcher import watcher
+
+    # This test needs watcher in order to properly mark success/failure
+    # when "teardown" task with trigger rule is part of the DAG
+    list(dag.tasks) >> watcher()
+
+
+from tests.system.utils import get_test_run  # noqa: E402
+
+# Needed to run the example DAG with pytest (see: 
tests/system/README.md#run_via_pytest)
+test_run = get_test_run(dag)

Reply via email to