Error While connecting to Hadoop_hive connection from jaspersoft Studio 5.5

Posted on January 9, 2014 at 1:05am

Hi,

i'm trying to conncet to Hadoop-Hive connection from Jaspersoft Studio 5.5 proffesional edition.

So I have done " New Data Adapter > Database JDBC Connection > Hadoop_Hive Connection ". Once i test the connection i'm getting the error  " Unable to connect to repository http://jasperstudio.sf.net/jssproductrepo_5_1_x_PRO/content.xml".

I have not added any Hadoop hive jars externally to the jaspersoft studio 5.5.My Apache hadoop and Hive are running properly. Also Thrift server is also running properly.

Below is the Exception stack trace related to the above error

java.net.ConnectException: Connection timed out: connect
  at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
  at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
  at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
  at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
  at java.net.PlainSocketImpl.connect(Unknown Source)
  at java.net.SocksSocketImpl.connect(Unknown Source)
  at java.net.Socket.connect(Unknown Source)
  at org.eclipse.ecf.provider.filetransfer.events.socket.SocketEventCreateUtil.createSocket(SocketEventCreateUtil.java:43)
  at org.eclipse.ecf.internal.provider.filetransfer.httpclient.ECFHttpClientProtocolSocketFactory.createSocket(ECFHttpClientProtocolSocketFactory.java:81)
  at org.eclipse.ecf.internal.provider.filetransfer.httpclient.ECFHttpClientProtocolSocketFactory.createSocket(ECFHttpClientProtocolSocketFactory.java:73)
  at org.eclipse.ecf.internal.provider.filetransfer.httpclient.ECFHttpClientProtocolSocketFactory.createSocket(ECFHttpClientProtocolSocketFactory.java:65)
  at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)
  at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.open(MultiThreadedHttpConnectionManager.java:1361)
  at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387)
  at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
  at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
  at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:346)
  at org.eclipse.ecf.provider.filetransfer.httpclient.HttpClientFileSystemBrowser.runRequest(HttpClientFileSystemBrowser.java:232) 
  at org.eclipse.ecf.provider.filetransfer.browse.AbstractFileSystemBrowser$DirectoryJob.run(AbstractFileSystemBrowser.java:69)
  at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Please help me in this regard.What can be done to solve the above error?

Thanks in advance

Shree

shreecs's picture
shreecs
14
Joined: Dec 23 2013 - 12:55am
Last seen: 9 years 3 months ago

1 Answer:

Posted on January 13, 2014 at 4:25pm

Hi -

Is this a new installation, or have you upgraded from a previous version?

Thanks,
Ilona

ilona's picture
ilona
6310
Joined: Aug 2 2012 - 11:06am
Last seen: 9 years 2 months ago

Hi ilona,
Yes it's a new installation.

I'm able to connect to the Hadoop-Hive data source connection.When i changed hive default metastore to mysql solved the problem.

shreecs - 9 years 8 months ago
add comment
Feedback