CDW Public Cloud endpoints change

The format of Hive, Impala, Hue, and Data Analytics Studio (DAS) endpoints have changed in the Cloudera Data Warehouse (CDW) Public Cloud release dated August 27, 2021:

  • FROM:
  • TO:

In the August 27, 2021 release, the format was changed from using the environment ID (env-id) to using the DW environment name (env-name). Consequently, the UI was simplified. If you had the CDW_CUSTOM_CLUSTER_ID entitlement in earlier releases, you might notice the Custom Cluster ID field in Activation Settings has been removed. This field is no longer necessary.

The new endpoint formatting affects the Hive and Impala JDBC URLs, the Impala shell URL, Hue URLs for Hive and Impala, and DAS URLs, as well as the Impala JDBC with coordinator shutdown URL.

Examples of endpoint changes

In these examples, the following values are used for the variables in the endpoint format above:

Variable: env-name
Example value: env1
Description: The name you provided when registering the environment in Management Console.
Variable: env-id
Example value: env-hfwbgd
Description: The random string for the environment ID that gets generated at the time of activation from CDW.
Variable: tenant-id
Example value: 'xcu2-9999'
Description: Your tenant ID.
Variable: workload-domain-name
Example value:
Description: The domain name.
Hive Virtual Warehouse name
Example value: hive1
Impala Virtual Warehouse name
Example value: impl1
Table 1.
Endpoint type New URL (CDW August 27, 2021) Old URL (CDW August 9, 2021 and earlier)
Hive JDBC jdbc:hive2://;transportMode=http;httpPath=cliservice;socketTimeout=60;ssl=true;retries=3; jdbc:hive2://;transportMode=http;httpPath=cliservice;socketTimeout=60;ssl=true;retries=3;
Impala JDBC jdbc:impala://;AuthMech=3;transportMode=http;httpPath=cliservice;ssl=1;UID=<userid>;PWD=PASSWORD jdbc:impala://;AuthMech=3;transportMode=http;httpPath=cliservice;ssl=1;UID=<userid>;PWD=PASSWORD
Impala shell impala-shell --protocol='hs2-http' --ssl -i '' -u <userid> –l impala-shell --protocol='hs2-http' --ssl -i '' -u <userid> –l
Hue Hive
Hue Impala
Impala JDBC with coordinator shutdown enabled jdbc:impala://;AuthMech=3;transportMode=http;httpPath=cliservice;ssl=1;UID=<userid>;PWD=PASSWORD jdbc:impala://;AuthMech=3;transportMode=http;httpPath=cliservice;ssl=1;UID=<userid>;PWD=PASSWORD
Data Analytics Studio (DAS)