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.
- Obtain the DWUser role.
- You must run a Virtual Warehouse version DWX 1.1.2-b2008 or later.
-
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 Cloudera Data Warehouse, as listed in the Cloudera Data Warehouse Release Notes in section, “Version mapping”.
-
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 'coordinator-vw-impala.dw-dwx-rzs556.xcu2-8y8x.dev.cldr.work:443' -u client_max -l
