Member since
09-03-2025
2
Posts
0
Kudos Received
0
Solutions
09-03-2025
06:09 AM
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
... View more
09-03-2025
01:17 AM
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
... View more
Labels: