Need instructions on configuring Squirrel SQL for Phoenix on a cluster using knox authentication (cluster is also kerberoized)
I'm not familiar with Squirrel SQL but it looks like a fairly standard JDBC based client. If that is the case then this post provides the information required to get the driver installed.
Once you have that then you need three things.
For #1 in hive-site you will need know/set the following values. Make sure you restart HS2 if you change any of them. hive.server2.transport.mode=http hive.server2.thrift.http.port=10001 hive.server2.thrift.http.path=cliservice
For #2 the url for the HIVE role service should have the matching port and path from above.
For #3 the JDBC connection URL will look something like this:
The sslTrustStore and trustStorePassword are not required if the Knox SSL public key is added to the default truststore however.
I upvoted this but didn't realize that it the OP was looking for HBase with Phoenix. This may not be the correct answer.
Oh you are probably correct. I was answering this in the context of HiveServer2. We don't currently have any tested support of Phoenix via Knox.
Can you please help me with JBDC hive server 2 connectivity using SQuirrel SQL client or any other.
I have followed the steps mentioned at the link mentioned(also written below) but facing issues while doing JDBC connection .Please find the attached log. I believe that it is because of the SSL issue .(AS in the ODBC client i am able to connect tableu with hive server2 with knox and ldap, using hortonworks ODBC driver . In ODBC i can select http mode and added SSL options , enable SSL and allow Self Signed server certficate.Bingo !! test successful and data is there) )But in JDBC i facing issues how to add ssl certificate.
1.Installed Squirrel Client
2.Added all the jars
3.Settings at the hive xml file done
4 Beeline is connected to my cluster and ran below command there , i am able to connect but when i am passing this through SQuirrel I am facing attached issue.errorlog.txt
Also ,what does it means "The sslTrustStore and trustStorePassword are not required if the Knox SSL public key is added to the default truststore however." Please explain a bit.
It is done as above after doing two tweaks:-
Set my SSL mode OFF as we do not need it now
Used SQuirrel JDBC client as i believe TD Studio has some issues.
Note: In SQuirrel JDBC client we need to remove the hadoop-comman.jar as it is pretty old one , download a new and rename it .