Impala

Tool Permissions Prerequisites

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 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 Cloudera 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 Cloudera Support:
  • C:\Program Files (x86)\Octopai\Service\log