Hi,
I am using kettle stable 4.4 and I am trying to add a Hive Server 2 DB connection, but running into problems. Here is what I have tried so far.

When using the stable releas 4.4 I didn't get any "Hadoop hive 2" connection type, so I tried using the Generic Connection and explicitly specifying the driver class to be 'org.apache.hive.jdbc.HiveDriver' and connection string to be 'jdbc:hive2://<host>:10000/default', but I get the ClassNotFoundException pasted at the end.
Then I compiled the big-data-plugin code and replace the jars, this gives me the option to have a hive server 2 connection but I still get the same ClassNotFoundException.
I also tried to copy the hive-jdbc and other hive jars from my hadoop cluster for version compatibility, but still the same ClassNotFoundException.
I also made sure that the 'org.apache.hive.jdbc.HiveDriver' is in the jdbc jar.

It looks that the current kettle 4.4 stable is not able to load the hive2 driver. Is there anyway to workaround this?


Exception:
========
Error connecting to database [Hive] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database

Exception while loading class
org.apache.hive.jdbc.HiveDriver

org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database

Exception while loading class
org.apache.hive.jdbc.HiveDriver
....
Caused by: java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)

Kind Regards
Ehsan