Support Required: Connecting to Cloudera from Mac CLI

[#1]

Hi Team,

Could you please provide detailed steps on how to connect to my Cloudera trial account from the command line on a Mac?

The host address is: coordinator-jwemca0ltng5.dw-jwemca0ltng5.t7gcn3.cloudera.site

Thank you, Venkat

[#2]

Hello @Venkat_T 

Thank you for reaching to Cloudera community

Could you please elaborate on your query please? What exact steps are you following? A document you are referring?

We will need your inputs to further help you

[#3]

Hi @upadhyayk04 

Context:

• I have access to CDP Data Warehouse and can log in to the Hue console via browser using SSO (Single Sign-On).

• I want to connect to Impala using the impala-shell CLI tool or JDBC driver for querying data.

• I attempted to ingest data using Python through the Cloudera AI console by creating a new project, but I am still encountering the same access permission issues.

What I Have Tried:

• Successfully listed clusters and warehouses using cdp dw CLI commands.

• Retrieved the Impala JDBC connection string and endpoint details.

• Tried to start the virtual warehouse using CLI but faced permission denied (403) errors.

• Attempted to connect via impala-shell CLI with LDAP username and password, but received HTTP 401 Unauthorized errors.

• Verified that no LDAP password is available as login is via SSO.

• Tried to pass password in command line and interactively; none worked.

• Noted that impala-shell does not support browser-based SSO authentication.

• Attempted to add users to virtual warehouse using cdp dw add-user but faced permission denied errors.

• Confirmed that SSO login works fine in Hue and CDP Console but CLI access is blocked due to lack of proper credentials.

Issue:

• CLI tools like impala-shell and cdp dw commands require LDAP credentials or a different authentication method.

• SSO-based authentication used in the environment is not supported by CLI tools by default.

• This prevents me from running queries or managing the Data Warehouse via CLI.
  
  

Thank You,
Venkat