Apache Hive

Tool Permissions Prerequisites

⚠ Warning: Missing permissions could result in broken connections or metadata extraction failures.

Download and Install Hive ODBC Driver

• Download the ODBC driver for Hive from your vendor’s website:
  Hive ODBC Driver Download
• Ensure that you choose the correct driver version (32-bit or 64-bit) based on your environment and client tool.

 

Configure the DSN (Data Source Name) 

• Open the ODBC Data Source Administrator

  • Search for "ODBC Data Source" in the Start menu.
  • Select either 32-bit or 64-bit, depending on the installed driver.

• Create a New DSN (User DSN or System DSN)

  • Name: Provide a friendly name (e.g., Hive_ODBC).
  • Description: (Optional) Add details (e.g., “Hive ODBC connection”).
  • Host: Enter the hostname (or IP address) of the Hive service.
  • Port: Default port is 10000 for Hive (confirm in your cluster setup).
  • Database: Specify a default database (e.g., default).
  • Authentication Mechanism: Use User Name and Password authentication.
  • SSL/TLS: If required, configure SSL settings for a secure connection.

How to verify the extracted Metadata File

Access the Octopai Target Folder (TGT)

1. Navigate to the TGT Folder on the server where the Octopai Client is installed.
   • Default location: C:\Program Files (x86)\Octopai\Service\TGT
2. Locate the ZIP file with the Hive Connector Name.
   • Example: Hive_Metadata_Export.zip
3. Verify its content:
   • Check the quantity and quality of inner files.

Troubleshoot

⚠ Error during extraction? Try the following steps:

• Check permissions on the Hive server and ODBC connection.
• Verify the DSN configuration (correct hostname, port, authentication).
• Send the log file with the connector name and number to Octopai Support:
  • C:\Program Files (x86)\Octopai\Service\log