You can translate the question and the replies:

Connecting with Hive database in Cloudera distribution in VDP Denodo

Hi, I am trying to connect to Hive database in cloudera distribution with denodo installed on my local machine. I have database in hive and unable to configure the data source properties in VDP as it is asking for Credentials. Please provide me the directions/instructions for establishing the connection. And also is it possible to install denodo platform on Cloudera?
user
20-04-2017 10:28:13 -0400
code

3 Answers

Hi In order to connect to cloudera hive database I tried the following and it worked fine for me. 1. Select a new JDBC datasource 2. In the Database Adapter select the "Hive 1.1.0 for Cloudera(HIveServer2)" in the list 3. Enter the Database URI with host of the cloudera hive database and port and the database name you wish to connect"jdbc:hive2://host:port/database" *For example: jdbc:hive2://10.132.23.224:10000/testing* 4. Then in the Authentication enter the credentials to connect to the database. Now you will be able to connect to the Cloudera Hive Database. To answer you second question you can install the denodo platform in the cloudera sandbox. To achieve it kindly read the following article [Headless Installation](https://community.denodo.com/kb/view/document/Headless%20installation?category=Installation+%26+Updates) Hope this helps.
Denodo Team
24-04-2017 10:03:15 -0400
code
Hi Team, Thank you for your response. In response to first answer, I have tried the same procedure for connecting to the Cloudera Hive but I am getting error with the driver I need provide as Denodo by default is not providing. If possible can you please attach me a link for downloading the driver. Please look into the link for the error: https://drive.google.com/open?id=0B-vBy7S8EHM9TEc2N3VJYktTaUU
user
24-04-2017 10:30:19 -0400
Hi, I was able to obtain the driver from [here](https://www.cloudera.com/downloads/connectors/hive/jdbc/2-5-18.html). The downloaded filed contains two zip files. Each one contains the driver supporting the JDBC API version indicated in the archive name. I could make the connection by unzipping the one called 'Cloudera_HiveJDBC41_2.5.18.1050' and then specifying the path to that folder (not a specific jar) in the "Driver Class Path". Hope that helps!
Denodo Team
24-04-2017 16:23:15 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here