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.
