> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sync.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Apache Hive

export const CommonDatasourceMoreInformation = ({datasource = "the data source", advancedurl = "", siteName = "CData Sync", driverVersion = ""}) => {
  return <>
      <p>
        For more information about interactions between {siteName} and {datasource}, see{' '}
        <a href={`https://cdn.cdata.com/help/${advancedurl}${driverVersion}/synch/default.htm`}>
          {datasource} Connector for {siteName}
        </a>.
      </p>
    </>;
};

export const CommonDatasourceAddConnector = ({datasource = "the data source", title = "the connector", destination = false, siteNameShort = "Sync"}) => {
  return <>
      <p>
        To enable {siteNameShort} to use data from {datasource}, you first must add the
        connector, as follows:
      </p>
      <ol>
        <li>Open the <strong>Connections</strong> page of the {siteNameShort} dashboard.</li>
        <li>Click <strong>Add Connection</strong> to open the <strong>Select Connectors</strong> page.</li>
        <li>
          Click the <strong>{destination ? "Destinations" : "Sources"}</strong> tab and locate
          the <strong>{title}</strong> row.
        </li>
        <li>
          Click the <strong>Configure Connection</strong> icon at the end of that row to open
          the <strong>New Connection</strong> page. This action opens the{' '}
          <strong>Add Connection</strong> dialog box.
          <br />
          <strong>Note:</strong> If the <strong>Configure Connection</strong> icon is not
          available, click the <strong>Download Connector</strong> icon to install
          the {title} connector.
        </li>
        <li>Enter a name for your connection in the <strong>Add Connection</strong> dialog box.</li>
        <li>Click <strong>Add</strong> to open the <strong>Settings</strong> tab for your connector.</li>
      </ol>
      <p>
        For more information about installing new connectors, see{' '}
        <a href="../connections">Connections</a>.
      </p>
    </>;
};

export const CommonDatasourceIntroSource = ({datasource = "the data source", siteName = "CData Sync"}) => {
  return <p>
      You can use the {datasource} connector from the {siteName} application to capture data
      from {datasource} and move it to any supported destination. To do so, you need to add
      the connector, authenticate to the connector, and complete your connection.
    </p>;
};

export const driverVersion = "M";

export const siteNameShort = "Sync";

export const siteName = "CData Sync";

export const datasource = "Apache Hive";
export const pageTitle = "Apache Hive";
export const advancedurl = "FI";

<CommonDatasourceIntroSource datasource={datasource} siteName={siteName} />

## Add the Apache Hive Connector

<CommonDatasourceAddConnector datasource={datasource} title={pageTitle} destination={false} siteNameShort={siteNameShort} />

## Authenticate to Apache Hive

After you add the connector, you need to set the required properties.

**Server:** Enter the host name or the IP address of the server that hosts HiveServer2.

{siteName} supports authenticating to {pageTitle} in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

* [**Plain**](#plain)
* [**LDAP**](#ldap)
* [**NoSasl**](#no-simple-authentication-and-security-layer)
* [**Kerberos**](#kerberos)

### Plain

To connect with a plain-text login, specify these properties:

* **Auth Scheme:** Select **Plain**.
* **User:** Enter the username that you use to authenticate to your {pageTitle} account.
* **Password:** Enter the password that you use to authenticate to your {pageTitle} account.

### LDAP

To connect with Lightweight Directory Access Protocol (LDAP) credentials, specify the following properties:

* **Auth Scheme:** Select **LDAP**.
* **User:** Enter the username that you use to authenticate to your {pageTitle} account.
* **Password:** Enter the password that you use to authenticate to your {pageTitle} account.

### No Simple Authentication and Security Layer

To connect with No Simple Authentication and Security Layer (NOSASL) credentials, specify the following properties:

* **Auth Scheme:** Select **NoSasl**.
* **User:** Enter the username that you use to authenticate to your {pageTitle} account.
* **Password:** Enter the password that you use to authenticate to your {pageTitle} account.

### Kerberos

To connect with Kerberos, specify these settings:

* **Auth Scheme:** Select **Kerberos**.
* **User:** Enter the username that you use to authenticate to your {pageTitle} account.
* **Password:** Enter the password that you use to authenticate to your {pageTitle} account.
* **Kerberos KDC:** Enter the Massachusetts Institute of Technology (MIT) Kerberos Key Distribution Center (KDC) service that you use to authenticate to Hive.
* **Kerberos Realm:** Enter the Kerberos realm that you use to authenticate to Apache Hive.
* **Kerberos SPN:** Enter the service principal name (SPN) for the Kerberos domain controller.
* **Sasl Qop:** Select the quality-of-protection level for the SASL framework.
  * **auth:** Specifies authentication only.
  * **auth-int:** Specifies authentication plus integrity protection.
  * **auth-conf:** Specifies authentication plus integrity and confidentiality protection.
* **Kerberos Keytab File:** Enter the keytab file that contains your pairs of the Kerberos principals and encrypted keys.
* **Kerberos Ticket Cache:** Enter the full file path to the Kerberos credential cache file.

## Complete Your Connection

To complete your connection:

1. Specify the following properties:
   * **Transport Mode:** Select the transport mode that you want to use to communicate with the Hive server. The default mode is **BINARY**.
   * (Optional) **Port:** Enter the port number for the connection to your HiveServer2 instance. The default port is **10000**.
   * (Optional) **Database:** Enter the name of the Hive database that you want to use.
2. Define advanced connection settings on the **Advanced** tab. (In most cases, though, you should not need these settings.)
3. Click **Create & Test** to create your connection.

## More Information

<CommonDatasourceMoreInformation datasource={datasource} advancedurl={advancedurl} siteName={siteName} driverVersion={driverVersion} />