Hello team - I have downloaded TDStudio15.10 and tried to connect to a HWSandbox2.1 and a vanilla 4 pseudo HDP2.2 cluser and failed both times.
"The target server failed to respond"
Help greatly apprieciated
addendum: hive2.thrift.type=http causes issues so I turned it back to "binary".
I also downloaded the latest TD Studio 15.10.00.01 and it fails in a similary way for JDBC:
java.lang.Exception: Could not establish connection to jdbc:hive2://localhost:10000/default?hive.server2.
Okay I have some more understanding now: JDBC connectivity works on 10000 if you don't use http transport protocol - but that's no good for the TD Studio setup, you need to use Thrift - and it's default port is 10001 in Sandbox's Ambari. netstat -letpn | grep 10001 show's nothing - so thrift's port is not currently active so it's something to do with the vanilla install of Sanbox. No fault of the TDStudio package. I need to figure out why thrift isn't working on this Sandbox install...
I can connect to the Hortonworks Sandbox as it is provided. I've unchecked the HTTP Transport Mode checkbox which changes the JDBC Port Number to 10000. I've done this with both the 2.1 (a version of HDP we support) and the 2.2 Sandbox (which we haven't done certification with).
Are there any messages in the Error Log indicating problems?
Also did you need to change knox settings? which user did you use for tdch/jdbc/webhcat respectively?
Okay making progress. Restarting stale Hive configs wasn't enough on the Sandbox V18.104.22.168, I needed to restart the entire thing. JDBC now successfully pings. However unfortunately now when I open up TDStudio I still don' get anything more on the sidebar tree than the username under the connection, and I can't run jdbc actions in the SQL editor screen. "show databases" provides no rows.
A DTS0905 "NullPointerException" get's thrown with "show tables;"
an SQLPlugin Internal Error is returned on "show databases;"
Even though on the CLI the following can be returned:
hive> show databases;
Time taken: 0.822 seconds, Fetched: 2 row(s)
hive> show tables;
Time taken: 0.148 seconds, Fetched: 2 row(s)
I think now I'm dealing with a TDStudio bug not a Sandbox setup issue. Keen for ideas.
Connection properties that worked for me...
Check TDCH and JDBC
WebHDFS Host Name: sandbox.hortonworks.com (setup in hosts file on client - windows\system32\drivers\etc\hosts)
WebHDFS Port Number: 50070
WebHDFS User Name: guest
JDBC Host: sandbox.hortonworks.com
JDBC Port Number: 10000
JDBC Database: default
JDBC User Name: hive
JDBC password: left blank
HTTP Transport Mode is left unchecked
WebHCat Host Name: sandbox.hortonworks.com
WebHCat Port Number: 50111
WebHCat User Name: hue
I am able to query the HDFS via Hive and I can navigate the tree on the left. But I cannot load data via TDCH. I saw you had some posts about that. How were you able to get Knox working? did that allow you to load data?
Mike, Have you followed the steps to run the ConfigureOozie script?