Connecting to Impala Virtual Warehouse from Impala shell client

You need to provide commands to your client users for installing and launching the Impala shell to connect to your Impala Virtual Warehouse. Client users can then query your tables. You learn how to obtain the command for installing the Impala shell on a client and other information to provide to clients.

To query an Impala Virtual Warehouse from the Impala Shell, clients need to connect to HiveServer (HS2), which is available in the same cluster as Impala. The JDBC URL for the HS2 endpoint uses the strict HS2 protocol option to access the Impala Virtual Warehouse from the Impala Shell.
  • Obtain the DWUser role.
  • You must run a Virtual Warehouse version DWX 1.1.2-b2008 or later.
  1. In the Impala Virtual Warehouse, click Options , and select Copy Impala shell Download command.
    The command for installing the Impala shell compatible with your Impala Virtual Warehouse is copied to the clipboard. The command looks something like this:
    pip install impala-shell==4.1.0a1

    Using this command, your clients update impyla to the version compatible with CDW, as listed in the Data Warehouse Release Notes in section, “Version mapping”.

  2. Click Options again, and select Copy Impala shell command.
    This action copies the command that launches the Impala shell and includes the connection string your client needs to connect to your Virtual Warehouse. For example:
    impala-shell --protocol='hs2-http' --ssl -i '' -u client_max -l
  3. Provide the commands you copied to your client user.
  4. Provide the instructions in the next topic Using the Impala Shell client to your client user.