Teradata Workspace Log:
@kchinnad, Can you upgrade Studio to the latest 15.11 release. We have added additional error checking for Hadoop connections which may help to understand what the problem is. Also, you do not need TDCH to run JDBC queries.
@fgrimmer , Thanks for your response and greatly appreciate your support & guidance on this. In our organisation , we have only this version 15.10.00.04 available at the moment. It will take a long time and need to go through lot of process to get the latest version. I'll try to get that as well. In the meantime , I'm not able to proceed to use only JDBC alone in connection profile. Along with TDCH , same JDBC details works fine. To put it short , when i use Hadoop hortonworks connection profile , it makes it mandatory for me to use TDCH option too. With JDBC alone , it does not connect at all. To provide additional background, i'm using IP address in the place of WebHCat hostname , portname , user name. Shout it be Hostname only ? Thanks.
@kchinad, I am confused as to why you need to enter TDCH connection information? When you create the Hortonworks Connection with just JDBC and press Test Connection, is it successful? If not, what error is coming back?
Thanks. My intention is to run only SQL queries against Hive tables that's all. when i create the Hortonworks Connection with just JDBC alone ( without selecting TDCH ) and press Test Connection, it's not successful. below is the error message. However same JDBC details when i enter along with TDCH connection option enabled, JDBC is successful.
Even if the JDBC is successful with TDCH option , i'm not getting database/tables list.
I tried multiple options and got error message for all of them and posted the same.
Option-1: Tried with hostname for JDBC Tab
@kchinad, Is it possible that your username or password for Hive is bad? Have you tried hdfs and no password? Our systems have username guest and password guest-password. Not sure if that is standard on all systems?
@kchinad, Can you verify thru Ambari that your JDBC port number is correct? Can you run Hive commands on your Hadoop system?
@kchinad, I am wondering if you have a DNS issue. Are you using a Hortonworks sandbox?
My port number is correct. I verified it in ambari. I'm able to run hive queries via Hive command line. I'm using banks development server set up by hortonworks team.
Please let me know if there are anymore information required from my side. Thanks.