I'm using JasperReport Server 5.5 enterprise evaluation edition on windows 64bit machine. When i select "Hadoop-Hive Data Source" in JasperReport server it says connection failed.When i checked the log it says ERROR DataSourceAction,http-apr-8080-exec-7:455 - exception testing custom data source
net.sf.jasperreports.engine.JRException: java.net.ConnectException: Connection refused .
Is it because of any hadoop or hive jars?
I'm using Apache Hadoop 1.1.1 and Apache Hive o.9.0 .Here in jasperReport server latest hive jar is used instead of hive0.9.0. Is it due to incompatibility of the hive jdbc jar?
Please suggest the solution.
Thanks in advance
This may well be a driver issue (jar versions) as you suggested but the hive 0.10 jar should work fine. I assume that the problem may be with the thrift protocol. You can try adding libthrift-0.9.0.jar and hive-serde-0.11.0.jar to Jasper's /WEB-INF/libs and restarting the server.
@shreecs you have run into a problem that has to do with the Hive1 implementation, currently for remote connection the only DB supported is Default
"For standalone server, uri is "jdbc:hive://host:port/dbname" where host and port are determined by where the Hive server is run. For example, "jdbc:hive://localhost:10000/default". Currently, the only dbname supported is "default"."
Regarding your second question, since the Hive HQL is not fully SQL92 compliant you can not use domains yet (as of Jasper 5.5) with Hive. To use Adhoc with the Hive connector you have to use Topics.
A Topic is basically a JRXML file that defines the query and fields to be exposed in the AdHoc UI ( as any report It may contain parameters and input controls).
Information about Topic creation can be found in the User Guide -> http://community.jaspersoft.com/documentation/jasperreports-server-user-...