class_docstr: Moves data from Microsoft SQL Server to Hive.
  
  The operator runs your query against Microsoft SQL Server, 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 Microsoft SQL Server
      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 mssql_conn_id: source Microsoft SQL Server 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
class_docstr_tok: ["Moves","data","from","Microsoft","SQL","Server","to","Hive",".","The","operator","runs","your","query","against","Microsoft","SQL","Server",",","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","is","n'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","Microsoft","SQL","Server","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","does","n'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","mssql_conn_id",":","source","Microsoft","SQL","Server","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),
      mssql_conn_id: str = "mssql_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 = delimiter
      self.mssql_conn_id = mssql_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/mssql_to_hive.py
imports: from __future__ import annotations
  import csv
  from tempfile import NamedTemporaryFile
  from typing import TYPE_CHECKING, Sequence
  import pymssql
  from airflow.models import BaseOperator
  from airflow.providers.apache.hive.hooks.hive import HiveCliHook
  from airflow.providers.microsoft.mssql.hooks.mssql import MsSqlHook
label_desc: Use image node_id 1 to create a new MsSqlToHiveOperator object from inherited base classes: BaseOperator with example: obj = MsSqlToHiveOperator()