[Does JasperReport Server Community Edition support Hadoop-Hive data source?]

I solved this problem by using jasperServer6.1.1 。

 It has the impala connector.The impala connector can connect to hive and hive2

[Can't create a Hadoop datasource.]

I solved this problem by using jasperServer6.1.1 。

 It has the impala connector.

[Hive2 and kerberos on jasperserver]

I solved this problem by using jasperServer6.1.1 。

 It has the impala connector.

[How to add the JDBC driver for Hadoop Hive to Jasper Report Server 6.3.0 community version.]

I solved this problem by using jasperServer6.1.1 。

 It has the impala connector.

[It have exctpion :JDBC driver for Hadoop Hive to Jasper Report Server 6.3.0 community version]

I solved this problem by using jasperServer6.1.1 。

 It has the impala connector.

 

[It have exctpion :JDBC driver for Hadoop Hive to Jasper Report Server 6.3.0 community version]

Jasper Report Server 6.3.0 cannot support hive2.

I sovled the problem by use Jasper Report Server 6.1.1. use dateSource impala .

 

[Hive2 and kerberos on jasperserver]

I add this jars . It work in studio, but donot work in server.

[It have exctpion :JDBC driver for Hadoop Hive to Jasper Report Server 6.3.0 community version]

I add this jars . in studio it work.but it donot work in server~

it exception in server:

It exceptions :

com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection Arguments: atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:64) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:69) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1823) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1169) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1051) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:946) atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) atjava.lang.Thread.run(Thread.java:745) Caused by: org.apache.commons.dbcp.SQLNestedException:    Cannot get a connection, pool error Could not create a validated object, cause: Method not supported atorg.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:68) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:56)... 9 more Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: Method not supported atorg.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1233) atorg.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)... 11 more[/code]

 

[How to add the JDBC driver for Hadoop Hive to Jasper Report Server 6.3.0 community version.]

in studio it worl.but it donot work in server~

I add this jars

/sites/default/files/images/index(25).png

It exceptions :

com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection Arguments: atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:64) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:69) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1823) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1169) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1051) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:946) atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) atjava.lang.Thread.run(Thread.java:745) Caused by:org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: Method not supported atorg.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:68) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:56)... 9 more Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: Method not supported atorg.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1233) atorg.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)... 11 more[/code]