Support Questions

Find answers, ask questions, and share your expertise

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

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

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.

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.