I am evaluating for my company if impala can be used on jasperreport.
I have tried iReport, jaspersoft studio and JasperServer on the latest 5.2 download for Impala connection.
The result is,
JasperSoft studio takes the connection url jdbc:hive://10.0.0.5:21000/default and tested successful. However on getting the meta data it returns nothing.
iReport does not even take the above url. But they both works for hive connection on port 10000.
JasperServer failed such connection as data source using hadoop Hive data source
so I added a custom JDBC driver for impala given url like jdbc:hive2://10.0.0.5:21050/;auth=noSasl and use org.apache.hive.jdbc.HiveDriver as jdbc driver. but it leads to a jar conflict. I had to hack some jar to resolve this. Then the connection test sucessful. But on building a domain using this connection, it throws error, "Cannot get a connection, pool exhausted". The exception is not follow:
So anyone got Impala working? I am hoping it can work. otherwise have to look at pentaho for Impala integration.
Support for Impala before 5.5 was pretty much a "headache". I suggest to try 5.5 or 5.6 that have better support for Impala.
Make sure you use this connection string when creating a Hadoop-Hive Data Source for Impala: jdbc:hive2://10.0.0.5:21050/;auth=noSasl