Hi,
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.
Thanks
0 Answers:
No answers yet
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
failed
I see now there is a limitation with hive server 1 that only the 'default' database is supported. Does Jaspersoft support hive2 connector?
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?