Running hdp vm 2.1, TD Studio 15.10.00 (on MAC) (no problems with 15.10.3 TD Studio express on MAC)
connect to HDP VM, and cannot pull up Hadoop databases on HDP... exact same configuration as my TD Studio express which works
Norm, There was a problem fixed in Studio 15.10.00.01 regarding Hive Hadoop support. Can you upgrade Studio to our latest version, 15.10.00.03?
i think i'm there already, here's the zip file i installed:
the about help.. 126.96.36.1995..studio base feature , feature
Norm, Yes, that is the latest version. When it comes to Hadoop, the main difference between Studio and Studio Express is that Studio Express only supports running HiveQL statements. The connection profile management and Data Source Explorer display of Databases and Tables is the same code. Is there some difference in how the HDP VM is configured in the connection profile? Is there any error messages in the Studio error logs? The error logs are in your workspace directory, <Workspace>/.metadata/.log and /.metadata/Teradata/teradata.log.
attached a snibbet of the log.. i can send the whole log if needed.. thanks
MESSAGE Could not connect to HDP 2.1 VM.
Norm, In Studio, if you are going to perform data transfer between Hadoop and Teradata, so choose the TDCH (Teradata Data Transfers) option, you need to install and configure TDCH, Teradata Connector for Hadoop, on your Hadoop system. The error message you attached appears to indicate that TDCH has not been configured.
agreed.. i was trying to just connect.. BUT, i went back to the configuration and unticked TDCH, and was able to bring up the list of databases... even though i hadn't tried to use TDCH...
so solved..thanks for the quick response
I am facing similar issue. I have installed TDCH on HDP VM 2.1 From HDP i can transfer to/from HDFS to Teradata and vice versa but when it comes to TD studio Data Transfer is not working. When I click TDCH and enter login details, i am able to ping successfully but No databases are listed in the drop down. As I unclick the TDCH I am able to query HIVE tables. Is there any other setting than installing TDCH on HDFS to make Data Transfer work.
TDCH installed is teradata-connector-1.4.0-hadoop2.x.noarch.rpm
TD Studio is TeradataStudio__win64_x86.15.10.00.03.zip
HDP is Hortonworks Sandbox 2.2
In the studio log file I see