I am using apache hadoop-2.7.0, apache-hive-2.0.0 and pentaho report designer version: on my CentOS system.

I want to create the Pentaho report designer connection with Hive.

I have put hive-jdbc-2.0.0.jar in report-designer/lib/jdbc folder. now i am trying to create the data source.
I select:
Hadoop Hive 2
Host name: localhost
Database name: default
Port number: 10000

I got the following error when i test the connection:
Error connecting to database: (using class org.apache.hive.jdbc.HiveDriver)

kindly help to solve the problem.