Phoenix Thin (EMR) Kerberos SPNEGO not working in DataGrip
Hi Team,
I am trying to connect to Apache Phoenix (Thin client) running on AWS EMR (version 7.8) with Kerberos enabled.
Setup:
- EMR with HBase + Phoenix + Kerberos
- Phoenix Query Server (PQS) is running on port 8765
- Authentication is SPNEGO (HTTP Kerberos)
What is working:
- kinit using keytab works:
kinit -kt phoenixuser.keytab phoenixuser@REALM - Ticket is visible via klist
- Service ticket also works:
kvno HTTP/ - curl works:
curl --negotiate -u : http://:8765
(returns HTTP 400, which is expected)
So Kerberos + PQS setup is working correctly.
DataGrip configuration:
- Driver: Apache Phoenix Thin
- URL:
jdbc:phoenix:thin:url=http://:8765;authentication=SPNEGO - Tried both:
- Using kinit (ticket cache)
- Providing keytab + principal in UI
Issues:
- Connection fails from DataGrip
- Keytab field in UI only accepts folder, not file
- It does not seem to pick up Kerberos ticket (MIT kinit)
- SPNEGO authentication does not complete
Questions:
- Is Phoenix Thin driver with Kerberos (SPNEGO) supported in DataGrip?
- Should DataGrip use MIT Kerberos ticket cache on Windows?
- Is JAAS configuration required for this setup?
- Is there any working example for Phoenix Thin + Kerberos?
Additional clarification needed on,
I understand DataGrip seems does not directly support HBase as a datasource.
However, I am connecting via Apache Phoenix Thin driver (HTTP-based), which sits on top of HBase.
My question is specifically about Kerberos (SPNEGO) support for such HTTP-based drivers.
Is this scenario officially supported, or are there known limitations?Any guidance would be helpful.
Thanks!
Please sign in to leave a comment.
Apache Phoenix is not officially supported because it's not listed in Full and Basic DBMS support. Based on the issues posted on our tracker, there's likely a driver implementation issue that needs to be investigated, not to mention deploying the infrastructure setup for carrying out Kerberos auth tests. Here's what we can do: you can report this issue on our tracker
https://youtrack.jetbrains.com/newIssue?project=DBE
and attach the idea log found in Help - Show Log in Files. We'll create additional infrastructure tasks, so we can replicate your setup while reviewing the log info. Please let me know