Impala

Tool Permissions Prerequisites

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

Download and Install Impala ODBC Driver

• Download the ODBC driver for Impala from your vendor’s website:
  Impala 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)

1. 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.

2. Create a New DSN (User DSN or System DSN)

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

Verify the Impala ODBC Connection

• Test the connection and ensure the setup is successful.
• If the connection fails, verify the host, port, database, and authentication settings.

---

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 Impala Connector Name.
   • Example: Impala_Metadata_Export.zip
3. Verify its content:
   • Check the quantity and quality of inner files.

Troubleshoot Extraction Errors

⚠ Error during extraction? Try the following steps:

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