Hadoop-Hive connection form Jaspersoft Studio 5.5

Posted on January 7, 2014 at 2:43am

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

Jaspersoft® Studio
shreecs's picture
shreecs
14
Joined: Dec 23 2013 - 12:55am
Last seen: 8 years 9 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 - 9 years 4 weeks 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 - 8 years 12 months ago
add comment

1 Answer:

Posted on July 14, 2014 at 11:18pm

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
mpf181
44
Joined: Jun 2 2014 - 2:24am
Last seen: 8 years 7 months ago
Feedback