Connecting to Brisk Hive through JDBC

(3 posts) (1 voice)

• Started 1 year ago by john
• Latest reply from john
• This topic is resolved

Tags:

• hive
• jdbc

1. 

   john
   Member

   Hi,

   I am trying to connect to Brisk Hive through JDBC. Usually Hive runs on the default port 10000. However, this does not appear to be the case:

   java.sql.SQLException: Could not establish connecton to jdbc:hive://localhost:10000/default: java.net.ConnectException: Connection refused
   at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:113)
   at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
   at java.sql.DriverManager.getConnection(DriverManager.java:582)
   at java.sql.DriverManager.getConnection(DriverManager.java:185)
   at SmallHiveTest.testConnectJdbc(SmallHiveTest.java:39)

   Which port should I use to connect to?

   Kind regards

   Posted 1 year ago #
2. 

   john
   Member

   Some additional info:

   I tried connecting to all the ports the Brisk process is listening on, it did not succeed.

   Port: Found:
   -------------------------------
   7000 <failed, connection refused>
   7199 <failed, java.sql.SQLException: org.apache.thrift.transport.TTransportException>
   8012 <failed, java.sql.SQLException: org.apache.thrift.transport.TTransportException>
   8081 JMX Management Console (HTTP)
   9160 cassandra
   9260 <failed, connection refused>
   36141 <failed, java.sql.SQLException: org.apache.thrift.transport.TTransportException>
   49854 Hadoop
   50030 Hadoop Map/Reduce Administration (HTTP)
   50060 Hadoop Task Tracker (HTTP)
   54268 <failed, connection refused>
   58522 <failed, java.sql.SQLException: org.apache.thrift.transport.TTransportException>
   60539 <failed, connection refused>

   Posted 1 year ago #
3. 

   john
   Member

   Allright, I got it working after all. The trick was that Hive was not running in the background at all (something I wrongfully assumed, assumption is the mother of all ... :) )

   Here's how to start the Hive server in order to be able to connect to it through JDBC:

   $ export HIVE_PORT=10000
   $ brisk hive --service hiveserver

   Good luck!

   Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.