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 __init__(
      self,
      *,
      sql: str,
      hive_table: str,
      create: bool = True,
      recreate: bool = False,
      partition: dict | None = None,
      delimiter: str = chr(1),
      quoting: int | None = None,
      quotechar: str = '"',
      escapechar: str | None = None,
      mysql_conn_id: str = "mysql_default",
      hive_cli_conn_id: str = "hive_cli_default",
      hive_auth: str | None = None,
      tblproperties: dict | None = None,
      **kwargs,
  ) -> None:
      super().__init__(**kwargs)
      self.sql = sql
      self.hive_table = hive_table
      self.partition = partition
      self.create = create
      self.recreate = recreate
      self.delimiter = str(delimiter)
      self.quoting = quoting or csv.QUOTE_MINIMAL
      self.quotechar = quotechar
      self.escapechar = escapechar
      self.mysql_conn_id = mysql_conn_id
      self.hive_cli_conn_id = hive_cli_conn_id
      self.partition = partition or {}
      self.tblproperties = tblproperties
      self.hive_auth = hive_auth
  
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 1 to create a new MySqlToHiveOperator object from inherited base classes: BaseOperator with example: obj = MySqlToHiveOperator()