class_docstr: Moves data from MySql to Hive.
  
  The operator runs your query against MySQL, stores the file locally
  before loading it into a Hive table.
  
  If the ``create`` or ``recreate`` arguments are set to ``True``,
  a ``CREATE TABLE`` and ``DROP TABLE`` statements are generated.
  Hive data types are inferred from the cursor's metadata. Note that the
  table generated in Hive uses ``STORED AS textfile``
  which isn't the most efficient serialization format. If a
  large amount of data is loaded and/or if the table gets
  queried considerably, you may want to use this operator only to
  stage the data into a temporary table before loading it into its
  final destination using a ``HiveOperator``.
  
  :param sql: SQL query to execute against the MySQL database. (templated)
  :param hive_table: target Hive table, use dot notation to target a
      specific database. (templated)
  :param create: whether to create the table if it doesn't exist
  :param recreate: whether to drop and recreate the table at every
      execution
  :param partition: target partition as a dict of partition columns
      and values. (templated)
  :param delimiter: field delimiter in the file
  :param quoting: controls when quotes should be generated by csv writer,
      It can take on any of the csv.QUOTE_* constants.
  :param quotechar: one-character string used to quote fields
      containing special characters.
  :param escapechar: one-character string used by csv writer to escape
      the delimiter or quotechar.
  :param mysql_conn_id: source mysql connection
  :param hive_cli_conn_id: Reference to the
      :ref:`Hive CLI connection id <howto/connection:hive_cli>`.
  :param hive_auth: optional authentication option passed for the Hive connection
  :param tblproperties: TBLPROPERTIES of the hive table being created
code: def execute(self, context: Context):
      hive = HiveCliHook(
          hive_cli_conn_id=self.hive_cli_conn_id, auth=self.hive_auth
      )
      mysql = MySqlHook(mysql_conn_id=self.mysql_conn_id)
      self.log.info("Dumping MySQL query results to local file")
      with NamedTemporaryFile(mode="w", encoding="utf-8") as f:
          with closing(mysql.get_conn()) as conn, closing(
              conn.cursor()
          ) as cursor:
              cursor.execute(self.sql)
              csv_writer = csv.writer(
                  f,
                  delimiter=self.delimiter,
                  quoting=self.quoting,
                  quotechar=self.quotechar
                  if self.quoting != csv.QUOTE_NONE
                  else None,
                  escapechar=self.escapechar,
              )
              field_dict = {}
              if cursor.description is not None:
                  for field in cursor.description:
                      field_dict[field[0]] = self.type_map(field[1])
              csv_writer.writerows(cursor)  # type: ignore[arg-type]
          f.flush()
          self.log.info("Loading file into Hive")
          hive.load_file(
              f.name,
              self.hive_table,
              field_dict=field_dict,
              create=self.create,
              partition=self.partition,
              delimiter=self.delimiter,
              recreate=self.recreate,
              tblproperties=self.tblproperties,
          )
  
file_path: airflow/airflow/providers/apache/hive/transfers/mysql_to_hive.py
imports: from __future__ import annotations
  import csv
  from contextlib import closing
  from tempfile import NamedTemporaryFile
  from typing import TYPE_CHECKING, Sequence
  import MySQLdb
  from airflow.models import BaseOperator
  from airflow.providers.apache.hive.hooks.hive import HiveCliHook
  from airflow.providers.mysql.hooks.mysql import MySqlHook
label_desc: Use image node_id 3 for calling the MySqlToHiveOperator obj's underlying member method code with example usage: obj.execute(context) without return types