interskh
interskh

Reputation: 2591

Impala jdbc driver work with Pentaho Designer

I have some trouble to get impala jdbc driver working with Pentaho Designer.

I got the jdbc driver from cloudera website. After extracting the drivers and put them under lib/jdbc, I set up connection via Generic Database.

I tried a simple query like "SELECT count(*) FROM table_1;", and got an error: "ParentException: java.sql.SQLException: Method not supported"

Any ideas?

Upvotes: 0

Views: 2063

Answers (2)

Animesh Raj Jha
Animesh Raj Jha

Reputation: 2724

Pentaho does not support impala in previous versions. If you are using 4.4.2 PDI,you can use it for instaview.

Impala will be officially support in pentaho 5.0 and its already been released.

Upvotes: 1

user2173049
user2173049

Reputation: 11

Matt from Pentaho submitted pull request to apache repository on github: https://github.com/apache/hive/pull/9

This pull request contains implementation of all needed methods in JDBC driver for Pentaho tools. I fetched his commit, built jar and copied it into libext/JDBC directory instead of jar from Cloudera website. Driver still misses lot of methods, but is able to perform basic operations on Impala.

Upvotes: 1

Related Questions