Matt, Thanks for your quick response. I add following details for your reference. "2.1 install IReport plugin, design a new report with hive query"You didn't include details about your data source. It should be a Hive data source (not a JDBC data source). You probably did this correctly, but I wanted to draw attention to this detail since you didn't specify it.=======================Yes, I used a Hive data source(found "Hive connection to Database" after install the hive plugin) "2.2 copy files to [apache-tomcat/webapps/host-manager/META-INF]" This is not right. The files need to be copied to "<appserver>/webapps/jasperserver-pro/WEB-INF". If you didn't copy the files into the jasperserver directory, this is the problem.=======================There is a typo in my post. The files are copied to [apache-tomcat/webapps/jasperserver/META-INF] [root@localhost META-INF]# pwd/opt/jasperreports-server-cp-4.1.0/apache-tomcat/webapps/jasperserver/META-INF[root@localhost META-INF]# ls -ltotal 32-rw-r--r-- 1 root root 1488 Apr 12 14:07 applicationContext-HiveDatasource.xmldrwxr-xr-x 2 root root 4096 Sep 24 02:47 bundles-rw-r--r-- 1 root root 2745 Sep 23 20:39 context.xml-rw-r--r-- 1 root root 1065 Jun 27 04:40 foodmartDS-jdbc.xml-rw-r--r-- 1 root root 1125 Jun 27 04:40 jasperserverDS-jdbc.xmldrwxr-xr-x 2 root root 4096 Sep 24 02:38 lib-rwxr-xr-x 1 root root 106 Jun 27 04:40 MANIFEST.MF-rw-r--r-- 1 root root 1065 Jun 27 04:40 sugarcrmDS-jdbc.xml "2.3 define datasource in Jasper Server (manual and export from IReport), can not pass connection test"It's not possible to test a Hadoop-Hive connection in JasperReports Server. (It would be nice to add this someday, but it's not there yet.) So if you CAN test the connection, then you didn't create the connection correctly. It means you created a JDBC connection instead of creating a Hadoop-Hive connection. Once you have confirmed your step 2.2, then this step should be easy to do.=======================I create a JDBC datasource with following properties, and cannot pass the connection test. Type: JDBC datasourceDriver:org.apache.hadoop.hive.jdbc.HiveDriverURL:jdbc:hive://192.168.1.11:10000/testUserName(required):user1 [no such user in hive definition] Regards,David
