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

3 comments
Comment actions Permalink

Hi,
Are there any errors in the log file or in the console?
Thank you.

0
Comment actions Permalink

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.

0
Comment actions Permalink

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.

0

Please sign in to leave a comment.