providers/apache/spark/docs/operators.rst
.. 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.
~airflow.providers.apache.spark.operators.spark_submit.SparkSubmitOperator
you must configure :doc:Spark Connection <connections/spark-submit>.~airflow.providers.apache.spark.operators.spark_jdbc.SparkJDBCOperator
you must configure both :doc:Spark Connection <connections/spark-submit>
and :doc:JDBC connection <apache-airflow-providers-jdbc:connections/jdbc>.~airflow.providers.apache.spark.operators.spark_sql.SparkSqlOperator
gets all the configurations from operator parameters.~airflow.providers.apache.spark.operators.spark_pyspark.PySparkOperator
you can configure :doc:SparkConnect Connection <connections/spark-connect>.~airflow.providers.apache.spark.operators.spark_pipelines.SparkPipelinesOperator
you must configure :doc:Spark Connection <connections/spark-submit> and have the spark-pipelines CLI available... _howto/operator:SparkJDBCOperator:
Launches applications on a Apache Spark server, it uses SparkSubmitOperator to perform data transfers to/from JDBC-based databases.
For parameter definition take a look at :class:~airflow.providers.apache.spark.operators.spark_jdbc.SparkJDBCOperator.
Using the operator """"""""""""""""""
Using cmd_type parameter, is possible to transfer data from Spark to a database (spark_to_jdbc) or from a database to Spark (jdbc_to_spark), which will write the table using the Spark command saveAsTable.
.. exampleinclude:: /../tests/system/apache/spark/example_spark_dag.py :language: python :dedent: 4 :start-after: [START howto_operator_spark_jdbc] :end-before: [END howto_operator_spark_jdbc]
Reference """""""""
For further information, look at Apache Spark DataFrameWriter documentation <https://spark.apache.org/docs/2.4.5/api/scala/index.html#org.apache.spark.sql.DataFrameWriter>_.
.. _howto/operator:PySparkOperator:
Launches applications on a Apache Spark Connect server or directly in a standalone mode
For parameter definition take a look at :class:~airflow.providers.apache.spark.operators.spark_pyspark.PySparkOperator.
Using the operator """"""""""""""""""
.. exampleinclude:: /../tests/system/apache/spark/example_spark_dag.py :language: python :dedent: 4 :start-after: [START howto_operator_spark_pyspark] :end-before: [END howto_operator_spark_pyspark]
Reference """""""""
For further information, look at Running the Spark Connect Python <https://spark.apache.org/docs/latest/api/python/getting_started/quickstart_connect.html>_.
.. _howto/operator:SparkPipelinesOperator:
Execute Spark Declarative Pipelines using the spark-pipelines CLI. This operator wraps the spark-pipelines binary to execute declarative data pipelines, supporting both pipeline execution and validation through dry-runs.
For parameter definition take a look at :class:~airflow.providers.apache.spark.operators.spark_pipelines.SparkPipelinesOperator.
Using the operator """"""""""""""""""
The operator can be used to run declarative pipelines:
.. code-block:: python
from airflow.providers.apache.spark.operators.spark_pipelines import SparkPipelinesOperator
run_pipeline = SparkPipelinesOperator( task_id="run_pipeline", pipeline_spec="/path/to/pipeline.yml", pipeline_command="run", conn_id="spark_default", num_executors=2, executor_cores=4, executor_memory="2G", driver_memory="1G", )
Pipeline Specification
The pipeline_spec parameter should point to a YAML file defining your declarative pipeline:
.. code-block:: yaml
name: my_pipeline storage: file:///path/to/pipeline-storage libraries: - glob: include: transformations/**
Pipeline Commands
run - Execute the pipeline (default)dry-run - Validate the pipeline without executionReference """""""""
For further information, look at Spark Declarative Pipelines Programming Guide <https://spark.apache.org/docs/latest/declarative-pipelines-programming-guide.html>_.
.. _howto/operator:SparkSqlOperator:
Launches applications on a Apache Spark server, it requires that the spark-sql script is in the PATH.
The operator will run the SQL query on Spark Hive metastore service, the sql parameter can be templated and be a .sql or .hql file.
For parameter definition take a look at :class:~airflow.providers.apache.spark.operators.spark_sql.SparkSqlOperator.
Using the operator """"""""""""""""""
.. exampleinclude:: /../tests/system/apache/spark/example_spark_dag.py :language: python :dedent: 4 :start-after: [START howto_operator_spark_sql] :end-before: [END howto_operator_spark_sql]
Reference """""""""
For further information, look at Running the Spark SQL CLI <https://spark.apache.org/docs/latest/sql-distributed-sql-engine.html#running-the-spark-sql-cli>_.
.. _howto/operator:SparkSubmitOperator:
Launches applications on a Apache Spark server, it uses the spark-submit script that takes care of setting up the classpath with Spark and its dependencies, and can support different cluster managers and deploy modes that Spark supports.
For parameter definition take a look at :class:~airflow.providers.apache.spark.operators.spark_submit.SparkSubmitOperator.
Using the operator """"""""""""""""""
.. exampleinclude:: /../tests/system/apache/spark/example_spark_dag.py :language: python :dedent: 4 :start-after: [START howto_operator_spark_submit] :end-before: [END howto_operator_spark_submit]
Reference """""""""
For further information, look at Apache Spark submitting applications <https://spark.apache.org/docs/latest/submitting-applications.html>_.
Cluster mode crash recovery (Spark standalone) """""""""""""""""""""""""""""""""""""""""""""""
When running in Spark standalone cluster mode (--deploy-mode cluster), the Spark driver runs
independently on the cluster. If the Airflow worker dies while the Spark job is running, the driver keeps running but
Airflow loses track of it and the behaviour to submit a brand new job would be wasting
the compute already done or even cause conflicts if the Spark job itself is not designed to be idempotent.
Now, the SparkSubmitOperator solves this by persisting the driver ID to task_state_store immediately after
submission. On retry, it reads the ID back and reconnects to the already-running driver instead of
resubmitting.
This is the synchronous path — the worker holds a slot for the duration of polling. This is a crash-safety net for teams running sync operators for log observability, org constraints, or because a Triggerer is not available. Teams with a Triggerer available may also consider deferrable operators, which free the worker slot but may come with added complexity.
Connection requirements for crash recovery
The reconnection polling calls the Spark standalone REST API
(GET /v1/submissions/status/{driverId}). Make sure the Spark connection's
REST scheme and REST port extras match your cluster's configuration:
REST scheme — set to https if your cluster has TLS enabled on the REST port
(spark.ssl.standalone.enabled=true). Defaults to http.REST port — set to the value of spark.master.rest.port on your cluster. Defaults to 6066.See :doc:connections/spark-submit for how to configure these fields.
.. note::
Crash recovery in cluster mode requires Airflow 3.3+ (task_state_store support). On earlier
versions the operator falls back to the previous behavior of always submitting fresh.
Tracking driver status via Kubernetes API """"""""""""""""""""""""""""""""""""""""""
When running in Kubernetes cluster mode, spark-submit blocks for the duration of the job.
The JVM runs processes which does nothing but polling of the pod phase and holds heap space for
the entire duration. This is not ideal for long-running jobs, especially when the driver is idle
for long periods (e.g. waiting for data or user input).
Set track_driver_via_k8s_api=True to have the operator track the driver pod status via the
Python Kubernetes client rather than holding spark-submit open for the full job duration:
.. code-block:: python
from airflow.providers.apache.spark.operators.spark_submit import SparkSubmitOperator
run_spark = SparkSubmitOperator( task_id="run_spark", application="local:///opt/spark/examples/jars/spark-examples.jar", conn_id="spark_k8s", deploy_mode="cluster", track_driver_via_k8s_api=True, reconnect_on_retry=True, )
Requirements
master must be k8s://... and deploy_mode must be cluster.spark.kubernetes.submission.waitAppCompletion=true in your conf — this
conflicts with the flag and a ValueError will be raised at task start.reconnect_on_retry=True (the default) to enable crash recovery: the driver pod name is
persisted to task state before polling begins, so a worker crash and retry reconnects to the
existing pod instead of submitting a fresh one. Set reconnect_on_retry=False to always
submit a fresh driver on retry.pod.status.phase. If your driver pods have sidecar
containers (e.g. Istio injection enabled for the driver namespace), the pod phase may not
advance to Succeeded until all sidecars exit. In that case the poll loop will wait
indefinitely — set execution_timeout as a hard bound.YARN ResourceManager API tracking """""""""""""""""""""""""""""""""
When running Spark applications on YARN in cluster deploy mode, the default Spark submit path keeps
the local spark-submit JVM alive on the Airflow worker while the YARN
application runs. For long-running Spark applications this can keep worker memory tied up for the
whole application lifetime.
Set yarn_track_via_rm_api=True to release the local spark-submit JVM after YARN accepts the
application, then poll the YARN ResourceManager REST API until the application reaches a terminal
state. The ResourceManager API polling interval is controlled by status_poll_interval with a
minimum of 10 seconds.
This mode requires the Spark connection extra to set yarn_resourcemanager_webapp_address before
the application is submitted:
.. code-block:: bash
airflow connections add spark_yarn_rm \
--conn-type spark \
--conn-host yarn \
--conn-extra '{
"deploy-mode": "cluster",
"yarn_resourcemanager_webapp_address": "http://rm.example.com:8088"
}'
.. code-block:: python
SparkSubmitOperator(
task_id="spark_pi",
conn_id="spark_yarn_rm",
application="/path/to/spark-examples.jar",
java_class="org.apache.spark.examples.SparkPi",
deploy_mode="cluster",
yarn_track_via_rm_api=True,
)
For Kerberized clusters, install requests-kerberos in the Airflow environment. When the
Spark connection has both keytab and principal configured, Airflow automatically uses
HTTPKerberosAuth() for the ResourceManager REST requests.
Use yarn_rm_auth only when the ResourceManager needs a custom requests authentication
object:
.. code-block:: python
import requests
SparkSubmitOperator(
task_id="spark_pi",
conn_id="spark_yarn_rm",
application="/path/to/spark-examples.jar",
java_class="org.apache.spark.examples.SparkPi",
deploy_mode="cluster",
yarn_track_via_rm_api=True,
yarn_rm_auth=requests.auth.HTTPBasicAuth("user", "password"),
)