About jAnshula

jAnshula · ‎03-25-2026

Hi @Karma12 , Could you please help us with the following details to investigate the query performance further: • The profile of slow query • The expected completion time for this query • The Impala coordinator logs corresponding to the query execution These will help us analyze the execution plan and identify any bottlenecks.

jAnshula · ‎12-16-2025

@ksmiller99 If your company has completed banned Java, then using JDBC is not possible, Impala’s JDBC driver cannot work without a JVM

jAnshula · ‎10-17-2025

Hi @tableau The Impala ODBC/JDBC drivers don’t natively support SAML authentication. You need to use Apache Knox as the SAML Service Provider (SP). Knox handles authentication with Okta (IdP) and then proxies the authenticated session to Impala using Kerberos delegation. Okta → SAML → Knox SSO (Gateway) → Kerberos delegation → Impala SSL (HTTPS) is required for SAML authentication to work securely. Please refer to the following Cloudera documentation for setup details: https://docs.cloudera.com/cdp-private-cloud-base/7.3.1/knox-authentication/topics/security-knox-authe-saml.html https://docs.cloudera.com/cdp-private-cloud-base/7.3.1/knox-authentication/topics/security-knox-tls-mutual-authentication.html Let us know if you have any questions on the same.

jAnshula · ‎11-08-2024

Hi @repealp Which document you are using to create Impala connection from DBvisualizer? You may follow below documentations and check your configurations again https://www.dbvis.com/docs/ug/reference-material/installing-a-jdbc-driver/ https://www.cdata.com/kb/tech/impala-jdbc-dbv.rst

jAnshula · ‎04-03-2024

@s198 You may try and use NIFI, refer below article https://community.cloudera.com/t5/Support-Questions/How-to-copy-files-from-a-remote-linux-box-using-Nifi/m-p/145133

jAnshula · ‎04-03-2024

Hi @s198 You can use DistCp command to achieve the same. refer ---> https://hadoop.apache.org/docs/current/hadoop-distcp/DistCp.html

jAnshula · ‎04-03-2024

Hi @drgenious First, please test your script outside of Oozie. If it is working outside of Oozie, then it should work from Oozie as well. As for error "No module named impala.dbapi" it could be that there is some version dependency issue with impyla and its related libraries refer ---> https://github.com/cloudera/impyla/issues/227

jAnshula · ‎04-03-2024

Hi @yagoaparecidoti The mini dump created shows that role/process is failing due to memory error. You may need to analyse this dmp file to check why the role/process is failing.

jAnshula · ‎03-28-2024

Hi @felix_ We will recommend you to use HUE Query Processor which provide same functionality as that of DAS. However if you want to keep using DAS, below information may help you: The LDAP implementations tested by Cloudera are the ones in the below documentation (MS Active Directory, OpenLDAP, or OpenDJ) https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/using-das/topics/das-user-authentication-ldap.html You may use below LDAP Search command to check if the configuration used are correct or not Example, Searching for a specific users (peter): ------------------------------------------------------------- ldapsearch -x -H ldap://sme-2012-ad.support.com:389 -D "test1@SUPPORT.COM" -w hadoop12345! -b "ou=users,OU=hortonworks,dc=support, dc=com" "(&(objectclass=user)(cn=peter))"

jAnshula · ‎03-20-2024

Hi @MrBeasr Please check the status of job via Oozie Database: # select count(*) from WF_JOBS where id like '%0043858-220322202819429-oozie-oozi-W%'; If require you may set the status of the job in Database itself: # update wf_jobs set status='FAILED' where id like '%0043858-220322202819429-oozie-oozi-W%';

Online	Online
Last Visited	‎05-05-2026 04:19 AM

Member Since	‎09-15-2020 08:21 AM
Last Visited	‎05-05-2026 04:19 AM
Posts	245
Kudos received	16

Cloudera Community

Re: Alternative JRE for Impala JDBC driver?

Re: Impala Pro Driver Issues - Java --- class jar ...

Re: DAS configure user authentication with LDAP on...

Re: How to deny admin user/group from dropping hiv...

Re: Impala Long running Queries

Re: Impala Performance Issue with ODBC Driver – CD...

Re: Alternative JRE for Impala JDBC driver?

Re: how to setup okta authentication with cdh impa...

Re: Impala Pro Driver Issues - Java --- class jar ...

Re: Can we use sqoop to Transfer file from a HDFS ...

Re: Can we use sqoop to Transfer file from a HDFS ...

Re: Impala.dbapi error

Re: impala having problem after enabling kerberos ...

Re: DAS configure user authentication with LDAP on...

Re: Oozie - unable to kill workflow.