Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

superset is not integrated with kerberized hive iam getting following error? can any one solve this issue

superset is not integrated with kerberized hive iam getting following error? can any one solve this issue

New Contributor

hi iam using python 3.7 and superset service from hdp 3.x.

ERROR: {"error": "Connection failed!\n\nThe error message returned was:\nPassword should be set if and only if in LDAP or CUSTOM mode; Remove password or use one of those modes"}

97434-sdsdfsdfsdf.png

2 REPLIES 2

Re: superset is not integrated with kerberized hive iam getting following error? can any one solve this issue

Expert Contributor

@choppadandi vamshi krishna

Adjust the SQLAlchemy URI to get access to kerberized cluster:

hive://hive@dev4.com:10001/default?auth=KERBEROS&kerberos_service_name=hive

And get kerberos ticket manually to make it work:

kinit -k -t /etc/security/keytabs/superset.headless.keytab devhcdl4.azure.ril.com@DEVHCDLRIL.COM 

Reference here

Please accept the answer you found most useful.

Re: superset is not integrated with kerberized hive iam getting following error? can any one solve this issue

New Contributor

hey thanks for your reply,i already checked the reference case ,added ldap properties in ambari superset config ,after adding the ldap properties in ambari ,the UI is shown Invalid login.So i remove the Ldap properties give the superset ticket to kerberos still i am facing that issue.

Don't have an account?
Coming from Hortonworks? Activate your account here