DataGrip not able to List schema/tables when connecting to Hive through Knox
Hello,
I am trying to connect to a kerbized cluster (running HDP 2.5) and instead of dealing with running kinit (my developers are on windows and I couldn't configure that correctly) I am trying to connect through Knox to simplify. When I connect I am able to query from the tables as I would expect, but I can't view any of the schemas or tables. As shown here:
And based on some other reading I have done, it appears that people have luck after going into schemas in the data sources properties. But even here I am not seeing any databases there:
Finally my connection string for this is: jdbc:hive2://[Knox-Server]:8443/default;ssl=true;?hive.server2.transport.mode=http;hive.server2.thrift.http.path=gateway/default/hive
And I am using the hive jar from https://github.com/timveil/hive-jdbc-uber-jar
Thanks,
Nick
Please sign in to leave a comment.
Hi,
Are there any errors in the log file or in the console?
Thank you.
This problem exists when using zk based connection as well as hive server port based connection.
The seems to be a method that does not exist regarding getting the database schema.
Here is a copy of my logs.... (Not much detail)
1/26/18
4:29 PM Hived: Hadoop Dev
Method not supported.
4:30 PM Hived: Hadoop Dev
Connection to Hived: Hadoop Dev failed.
[ 08S01] Could not open client transport with JDBC Uri: jdbc:hive2://hdp-dev01-n ... more
4:32 PM Hive2: Hadoop Dev
Method not supported.
4:38 PM Hive2: Hadoop Dev
Method not supported.
4:49 PM Hive2: Hadoop Dev
Method not supported.
5:40 PM Hive2: Hadoop Dev
Method not supported.
5:40 PM Hive: Hadoop Dev
Method not supported.
Lucky for me. I have another product that works well for Pheonix/HBase, Impala, Hive2 (zk) and Hive2 (port).
So it should be able to work in Datagrip.