SameerMesiah97 commented on code in PR #72081: URL: https://github.com/apache/airflow/pull/72081#discussion_r3886886119
########## 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: Calculation will now be stopped once timeout is reached. A new helper has been introduced to handle calculation termination during both timeout and `on_kill` scenarios. -- 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]
