You can translate the question and the replies:

Hive connection issue with Denodo VDP

Hi Team, Product Name: Virtual DataPort 7.0 (Express) Hive Version: Hive v1.1.0 CDH (Cloudera Distribution Hadoop): v 5.13.0 Database Adapter : Hive 2.0.0 (HiveServer2) Driver Class path : 'hive-2.0.0' Driver Class : org.apache.hive.jdbc.HiveDriver Database Url : jdbc:hive2://xxx.xx.xx.xxx:8888/denodo Login :xxx Pass :xxx Extracted the Cloudera_HiveJDBC4_2.5.4.1006.zip files on below path - C:\Denodo\DenodoPlatform7.0\lib-external\jdbc-drivers\hive-2.0.0 I'm trying to connect with Hive on Big data(hadoop) using JDBC driver and getting failed as beloow message - "Unable to establish connection: The JDBC driver was not found. The Denodo Platform does not include the JDBC driver for this adapter. Copy the jar files of the driver to the folder "<DENODO_HOME>/lib-external/jdbc-drivers/hive-2.0.0", in the host where the Virtual DataPort server runs. You do not need to restart." If i need to use hive version driver "hive-1.1.0" then please share the link to download the same version of hive jdbc drivers and also on local which folder I need to copy these drivers to get connect? Please help. Regards, Pramod
user
25-09-2018 04:26:36 -0400

1 Answer

Hi, You can download the JDBC driver from Cloudera’s Downloads website. You would have to check if the JDBC Driver version you have downloaded supports the Apache Hive version of 1.1.0 and Cloudera Distribution Hadoop version 5.13.0 by checking the System Requirements section of the Cloudera JDBC Driver Documentation available on that website too. If you are using the Cloudera Distribution Hadoop, you would have to placed the jar files to this directory: *<DENODO_HOME>/lib-external/jdbc-drivers/hive-1.1.0-cloudera*. You can refer to [Supported JDBC Data Sources](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/appendix/supported_jdbc_data_sources/supported_jdbc_data_sources) section of the Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
25-09-2018 23:15:12 -0400
You must sign in to add an answer. If you do not have an account, you can register here