Unable to connect to Hive Datastore


I'm new to BI reporting tools so decided to give Jaspersoft a  try.  I'm playing around with the demo and I can't seem to connect to my hive datastore.  I can ping the server the Hive datastore is on, and I can connect to the Hive datastore from other BI software.  When I was running Hive Server I was able to  connect to 'default' datasource but not my datasource, named 'wikipage'.  I switched the hive server to Hive Server 2, and I can't seem to connect to either default or wikipage now.  I've tried changing the URL to jdbc:hive2:// - I'm  not sure what to check from here.


ncuneo's picture
Joined: Apr 11 2014 - 9:50am
Last seen: 9 years 5 months ago

I checked the logs and this is the exception:

2014-04-11 06:53:29,827 ERROR DataSourceAction,http-80-4:455 - exception testing custom data source
net.sf.jasperreports.engine.JRException: Could not create a validated object, cause: validateObject

ncuneo - 9 years 5 months ago

I see now there is a limitation with hive server 1 that only the 'default' database is supported.  Does Jaspersoft support hive2 connector?

ncuneo - 9 years 5 months ago

JasperReport supports HIVE2 connection.  And it should be able to connect other than default databse in up coming version.  Are you trying to connect through Jaspersoft studio or JasperReport Server?  And which version are you using?

VanyaC - 9 years 5 months ago

0 Answers:

No answers yet