o-nikolas commented on code in PR #72081: URL: https://github.com/apache/airflow/pull/72081#discussion_r3884508421
########## providers/amazon/docs/operators/athena/athena_spark.rst: ########## @@ -0,0 +1,51 @@ +.. 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. + +Athena Spark Operators +====================== + +Amazon Athena supports Apache Spark calculations through session-based APIs. +This page documents the provider support for submitting and monitoring those +calculations from Airflow. + +Prerequisite Tasks +------------------ + +Before using the Athena Spark operator or sensor, make sure that: Review Comment: No sensor added here? ########## providers/amazon/tests/system/amazon/aws/example_athena_spark.py: ########## @@ -0,0 +1,53 @@ +# 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. +from __future__ import annotations + +from datetime import datetime + +from airflow.providers.amazon.aws.operators.athena_spark import AthenaSparkOperator + +from tests_common.test_utils.version_compat import AIRFLOW_V_3_0_PLUS + +if AIRFLOW_V_3_0_PLUS: + from airflow.sdk import DAG +else: + # Airflow 2 path + from airflow.models.dag import DAG # type: ignore[attr-defined,no-redef,assignment] + +DAG_ID = "example_athena_spark" + + +with DAG( + dag_id=DAG_ID, + schedule="@once", + start_date=datetime(2021, 1, 1), + catchup=False, +) as dag: + # [START howto_operator_athena_spark] + run_spark_calculation = AthenaSparkOperator( + task_id="run_spark_calculation", + session_id="my-athena-spark-session-id", Review Comment: hardcoded session id? In general this looks like a non-standard system tests that will fail to run in our test harness. It has no context builder, no watcher, etc. Please compare against existing system tests for guidance. ########## providers/amazon/docs/operators/athena/athena_spark.rst: ########## @@ -0,0 +1,51 @@ +.. 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. + +Athena Spark Operators +====================== + +Amazon Athena supports Apache Spark calculations through session-based APIs. +This page documents the provider support for submitting and monitoring those +calculations from Airflow. + +Prerequisite Tasks Review Comment: Please import the standard prereqs and generic parameters, see any other aws operators doc for examples ########## providers/amazon/src/airflow/providers/amazon/aws/hooks/athena.py: ########## @@ -86,6 +86,20 @@ class AthenaHook(AwsBaseHook): "CANCELLED", ) + SPARK_INTERMEDIATE_STATES = ( Review Comment: Where is this ever used? ########## providers/amazon/src/airflow/providers/amazon/aws/operators/athena_spark.py: ########## @@ -0,0 +1,208 @@ +# +# 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. + +from __future__ import annotations + +import time +from collections.abc import Sequence +from typing import TYPE_CHECKING, Any + +from airflow.providers.amazon.aws.hooks.athena import AthenaHook +from airflow.providers.amazon.aws.operators.base_aws import AwsBaseOperator +from airflow.providers.amazon.aws.utils.mixins import aws_template_fields + +if TYPE_CHECKING: + from airflow.sdk import Context + + +class AthenaSparkOperator(AwsBaseOperator[AthenaHook]): + """ + Run an Apache Spark calculation in an Amazon Athena session. + + Submits a calculation, such as PySpark code, via the Athena API, polls until + the calculation reaches a terminal state, and returns execution metadata. + + .. seealso:: + - :class:`airflow.providers.amazon.aws.hooks.athena.AthenaHook` + - `Athena for Apache Spark + <https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-api-list.html>`__ + + :param session_id: The Athena session ID in which to run the calculation. (templated) + :param code_block: The calculation code, such as PySpark, to execute. (templated) + :param description: Optional description of the calculation. Defaults to None. + :param client_request_token: Optional idempotency token for the submission. Defaults to None. + :param poll_interval: Seconds to wait between status checks. Defaults to 30. + :param max_attempts: Maximum number of polling attempts before timing out. Defaults to 120. Review Comment: Let's use the current standard of waiter_delay/waiter_max_attempts ########## providers/amazon/src/airflow/providers/amazon/aws/operators/athena_spark.py: ########## @@ -0,0 +1,208 @@ +# +# 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. + +from __future__ import annotations + +import time +from collections.abc import Sequence +from typing import TYPE_CHECKING, Any + +from airflow.providers.amazon.aws.hooks.athena import AthenaHook +from airflow.providers.amazon.aws.operators.base_aws import AwsBaseOperator +from airflow.providers.amazon.aws.utils.mixins import aws_template_fields + +if TYPE_CHECKING: + from airflow.sdk import Context + + +class AthenaSparkOperator(AwsBaseOperator[AthenaHook]): + """ + Run an Apache Spark calculation in an Amazon Athena session. + + Submits a calculation, such as PySpark code, via the Athena API, polls until + the calculation reaches a terminal state, and returns execution metadata. + + .. seealso:: + - :class:`airflow.providers.amazon.aws.hooks.athena.AthenaHook` + - `Athena for Apache Spark + <https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark-api-list.html>`__ + + :param session_id: The Athena session ID in which to run the calculation. (templated) + :param code_block: The calculation code, such as PySpark, to execute. (templated) + :param description: Optional description of the calculation. Defaults to None. + :param client_request_token: Optional idempotency token for the submission. Defaults to None. + :param poll_interval: Seconds to wait between status checks. Defaults to 30. + :param max_attempts: Maximum number of polling attempts before timing out. Defaults to 120. + To limit total task time, use execution_timeout on the task as well. + :param log_query: Whether to log submission details. Defaults to True. + :param aws_conn_id: The Airflow connection used for AWS credentials. Defaults to ``aws_default``. + :param region_name: AWS region. If not set, default boto3 behavior is used. Defaults to None. + :param verify: Whether to verify SSL certificates. Defaults to None. + :param botocore_config: Optional botocore configuration dict. Defaults to None. + """ + + aws_hook_class = AthenaHook + ui_color = "#44b5e2" + template_fields: Sequence[str] = aws_template_fields("session_id", "code_block", "description") + template_ext: Sequence[str] = (".py",) + template_fields_renderers = {"code_block": "python"} + + def __init__( + self, + *, + session_id: str, + code_block: str, + description: str | None = None, + client_request_token: str | None = None, + poll_interval: int = 30, + max_attempts: int = 120, + log_query: bool = True, + aws_conn_id: str | None = "aws_default", + region_name: str | None = None, + verify: bool | str | None = None, + botocore_config: dict | None = None, + **kwargs: Any, + ) -> None: + super().__init__( + aws_conn_id=aws_conn_id, + region_name=region_name, + verify=verify, + botocore_config=botocore_config, + **kwargs, + ) + self.session_id = session_id + self.code_block = code_block + self.description = description + self.client_request_token = client_request_token + self.poll_interval = poll_interval + self.max_attempts = max_attempts + self.log_query = log_query + self._calculation_execution_id: str | None = None + + @property + def _hook_parameters(self) -> dict[str, Any]: + return {**super()._hook_parameters, "log_query": self.log_query} + + def execute(self, context: Context) -> dict[str, Any]: + """Submit the Spark calculation, poll until terminal state, then return metadata.""" + self.log.info("Starting Athena Spark calculation in session %s", self.session_id) + + calculation_execution_id = self.hook.start_spark_calculation( + session_id=self.session_id, + code_block=self.code_block, + description=self.description, + client_request_token=self.client_request_token, + ) + self._calculation_execution_id = calculation_execution_id + + self.log.info("Calculation submitted. CalculationExecutionId: %s", calculation_execution_id) + + final_state = self._poll_until_terminal(calculation_execution_id) + return self._handle_terminal_state(calculation_execution_id, final_state) + + def _poll_until_terminal(self, calculation_execution_id: str) -> str: + """Poll calculation status until a terminal state or timeout.""" + for attempt in range(1, self.max_attempts + 1): + state = self.hook.check_spark_calculation_status(calculation_execution_id) + + if state is None: + raise RuntimeError( + f"Malformed or missing status for calculation {calculation_execution_id}. " + "Cannot continue polling." + ) + + self.log.info( + "CalculationExecutionId: %s, current state: %s (attempt %d/%d)", + calculation_execution_id, + state, + attempt, + self.max_attempts, + ) + + if state in AthenaHook.SPARK_TERMINAL_STATES: + return state + + if attempt != self.max_attempts: + time.sleep(self.poll_interval) + + raise RuntimeError( + f"Polling timed out after {self.max_attempts} attempts for calculation " + f"{calculation_execution_id}. Use execution_timeout or increase max_attempts." Review Comment: Do we want to stop the calculation or leave it running unmanaged? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
