Hi Team,


Issue:
Not able to connect to hive from Pentaho.


Environment Used:


Clouderea :CDH 5.3
PDI di-ce-5.4.0.1-130


Error Message:


Below is the error while trying to connect through Hadoop Hive
- SQL - Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver)
- SQL - org/apache/hadoop/hive/metastore/api/MetaException


Below is the error while trying to connect through Hadoop Hive 2
- SQL - Error connecting to database: (using class org.apache.hive.jdbc.HiveDriver)
- SQL - org/apache/thrift/transport/TTransportException


Troubleshooting Steps:

1. Check hive is running or not
YES---Hive is running fine.


2. Set active.hadoop.configuration=cdh53 in
pdi-ce-5.4.0.1-130\data-integration\plugins\pentaho-big-data-plugin\plugin.properties file


3. Replace ..\pentaho-big-data-plugin\hadoop-configurations\cdh53\hive.site.xml file with
\etc\hive\conf\hive-site.xml file


After performing above steps system throwing the same error above
then followed with the steps below


4. Append the string(":../plugins/pentaho-big-data-plugin/hadoop-configurations/cdh53/lib")
to classpath property in data-integration\launcher\launcher.properties file.


5. Copy and paste the below jar file from "hive lib location" to "pentaho lib location"


Hive Lib Location :/usr/lib/hive/lib/
Pentaho Lib Location di-ce-5.4.0.1-130\data-integration\plugins\pentaho-big-data-plugin\hadoop-configurations\cdh53\lib
JAR Files Copied:
hive-common-X.XX.X-cdhX.X.X.jar
hive-jdbc-X.XX.X-cdhX.X.X.jar
hive-metastore-X.XX.X-cdhX.X.X.jar
hive-service-X.XX.X-cdhX.X.X.jar
httpclient-X.X.X.jar
httpcore-X.X.X.jar
libfb303-X.X.X.jar
libthrift-X.X.X.jar
log4j-X.X.XX.jar

Note:
I am able to execute map reduce jobs from SQOOP. Hopefully it means all the hadoop services are running fine.


Still the same error is encountering . Could you plese guide me in resolving the issue . Thank You