Anyone got impala working?
Posted on September 7, 2013 at 3:24pm
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:
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: Method not supported
So anyone got Impala working? I am hoping it can work. otherwise have to look at pentaho for Impala integration.
Posted on October 16, 2013 at 2:08am
Posted on June 9, 2014 at 12:30pm
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
Posted on September 25, 2014 at 12:43pm
An update on this, I downloaded Jasper report server 5.6.1 and it came with CDH5 Hive Impala driver. But this time I tried to hook up with IBM BigSQL 3 and it works!