You can translate the question and the replies:

Hive 0.14.0

I was trying to connect to hive database through JDBC, but the vdp keeps on running and doesnt go through. It has been 4 hours and it is still processing. What's wrong?
user
03-06-2015 04:33:19 -0400
code

4 Answers

Could you provide some more context to your question to help me understand the behaviour you are seeing? Could you list the steps you have gone through to configure, connect and query Hive for me?
Denodo Team
03-06-2015 05:20:05 -0400
code
Sure. I am using Hortonworks Sandbox running on 127.0.0.1:8000. In VDP the steps I followed: New->Data Source->JDBC. In the adapters list Hive 0.12.0 s the latest one so I selected that only. And the URl: jdbc:hive2://127.0.0.1:8000/default. After which I click OK and then it stays there with OK pressed down. In task manager, it shows in the running mode.
user
03-06-2015 05:37:00 -0400
Okay, now i downloaded the 0.14.0 driver and put it in the thirdparty folder. But this time it says "Insufficient resources to execute this operation". Please help!
user
03-06-2015 06:22:46 -0400
In order to connect to Hive, you should be able to do so using the following standard steps using the HDP 2.2.4.2-2 sandbox: 1) First, gather the IP address of Hortonworks server. You should see a message such as "To initiate your Hortonworks Sandbox session, please open a browser and enter this address in the browser's address field http://192.168.157.142". In this case the IP address is 192.168.157.142. 2) Open the VDP Admin Tool to create the data source, and add a JDBC data source. 2.1) Select Hive 0.12.0 (HiveServer2) as the Database Adapter and leave the other settings as default values. 2.2) Enter the database URIconnection in the format jdbc:hive2://host:port/database e.g for the default HDP database jdbc:hive2://192.168.157.142:10000/default. NB: In some HDP installations, it may be that the port does not need to be specified. 2.3) Enter the connection parameters (default HDP installation doesn't need any credentials). 2.4) Confirm the connection parameters and Denodo will introspect HDP via Hive interface. 3) Select those tables you want to create virtual base views on top: 4) Your base views are ready to be used.
Denodo Team
13-07-2015 09:25:09 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here