Hadoop-Hive connection form Jaspersoft Studio 5.5

0

Hi,

I have installed Jaspersoft studio 5.5 professional edition and JasperReport Server 5.5 enterprise evaluation edition on the same machine(64bit windows machine). Now i wanted to create reports on hadoop data using hive as a connector. So in Jaspersoft Studio , i have  chosen Hive Connection to create new Data Adapter and  specified URL as

jdbc:hive://172.20.30.84:10000/default  (my hive is installed on remote machine)

When i test the connection it stops there itself i.e, it doesn't proceed further to finish and save the hive connection.

On my remote machine my Thrift Server is running properly.

I'm using jdk 1.6 and eclipse 4.3.0 version.

What could be the problem ? How to overcome this problem ?

 

Thanks in advance

Shreecs

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

Hello Shreecs

I am expriencing the same problem? Could you share your findings regardless if you have found solution or not.

Thanks

 

 

oakrami - 5 years 5 months ago

If you're using hiveserver2, you must change the protocol to hive2, e.g.:

jdbc:hive2://172.20.30.84:10000/default

 

pieter_4 - 5 years 4 months ago

1 Answer:

0

You can trace eroor from 2 ways !
1) Check the jasper server log [if you have deployed it in tomcat, check the catalina.out]
2) Check the hive log ex: /tmp/hduser/hive.log

If you can't trace the error, send the error log !

 

mpf181's picture
2
Joined: Jun 2 2014 - 2:24am
Last seen: 5 years 2 weeks ago
Feedback
randomness