Jaspersoft Community 'Read-Only' as of July 8, 2022
Transition to New TIBCO Community Just Weeks Away
You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.
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
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?