http://www.datastax.com/support-forums/topic/connecting-to-brisk-hive-through-jdbc Software, Support, and Training for Apache Cassandra en-US Fri, 24 May 2013 23:41:12 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/connecting-to-brisk-hive-through-jdbc#post-208 Tue, 21 Jun 2011 11:13:03 +0000 john 208@http://www.datastax.com/support-forums/ <p>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 ... :) )</p> <p>Here's how to start the Hive server in order to be able to connect to it through JDBC:</p> <p>$ export HIVE_PORT=10000<br /> $ brisk hive --service hiveserver</p> <p>Good luck! </p> http://www.datastax.com/support-forums/topic/connecting-to-brisk-hive-through-jdbc#post-207 Tue, 21 Jun 2011 10:58:16 +0000 john 207@http://www.datastax.com/support-forums/ <p>Some additional info:</p> <p>I tried connecting to all the ports the Brisk process is listening on, it did not succeed.</p> <p>Port: Found:<br /> -------------------------------<br /> 7000 &lt;failed, connection refused&gt;<br /> 7199 &lt;failed, java.sql.SQLException: org.apache.thrift.transport.TTransportException&gt;<br /> 8012 &lt;failed, java.sql.SQLException: org.apache.thrift.transport.TTransportException&gt;<br /> 8081 JMX Management Console (HTTP)<br /> 9160 cassandra<br /> 9260 &lt;failed, connection refused&gt;<br /> 36141 &lt;failed, java.sql.SQLException: org.apache.thrift.transport.TTransportException&gt;<br /> 49854 Hadoop<br /> 50030 Hadoop Map/Reduce Administration (HTTP)<br /> 50060 Hadoop Task Tracker (HTTP)<br /> 54268 &lt;failed, connection refused&gt;<br /> 58522 &lt;failed, java.sql.SQLException: org.apache.thrift.transport.TTransportException&gt;<br /> 60539 &lt;failed, connection refused&gt; </p> http://www.datastax.com/support-forums/topic/connecting-to-brisk-hive-through-jdbc#post-206 Tue, 21 Jun 2011 10:26:45 +0000 john 206@http://www.datastax.com/support-forums/ <p>Hi,</p> <p>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:</p> <p>java.sql.SQLException: Could not establish connecton to jdbc:hive://localhost:10000/default: java.net.ConnectException: Connection refused<br /> at org.apache.hadoop.hive.jdbc.HiveConnection.&lt;init&gt;(HiveConnection.java:113)<br /> at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)<br /> at java.sql.DriverManager.getConnection(DriverManager.java:582)<br /> at java.sql.DriverManager.getConnection(DriverManager.java:185)<br /> at SmallHiveTest.testConnectJdbc(SmallHiveTest.java:39)</p> <p>Which port should I use to connect to?</p> <p>Kind regards </p>