Teradata Express 15 for VMware Player Available Now

The team is swamped. I started looking at the error in the internal trouble shooting guide. I came up with the following potential meanings for the errors. Not sure if this will help. let me know and i'll continue to pursue having the team look at it. 

*** Failure 7810 [TblOp] [TD-SQLH]: Could not obtain block: BP-1757658947-3
.32.8.3-1405036512676:blk_1073844091_103320 file=/apps/hive/warehouse/tdsqlh_
test/dt=2012-10-10/country=usa/tdsqlh_data.csv.
                Statement# 1, Info =0

KAP1144256

Add the below clause verbatim in the query. Example:
SELECT * FROM DATABASE.load_from_hcatalog(USING
...
hadoop_properties('dfs.client.use.datanode.hostname=true')
) as D1;
 
if hadoop cluster and teradata cluster are on the same fini band
'<dfs.client.use.datanode.hostname=true>'
if on different BYNET
'<dfs.client.use.datanode.hostname=true>,<dfs.datanode.use.datanode.hostname=true>'
Another scenario is that one of the teradata nodes are unable to ping the Hadoop Data node.

Add below parameter after templeton_port entry:-
 
hadoop_properties('dfs.client.use.datanode.hostname=true')
 
This parameter instructs Hadoop to send a Hadoop Node’s name, instead of its IP address.
Second requirement: The “hosts” file on SQL-H server must contain entries for ALL of the nodes in that Hadoop System.
Allowing it to map each received Hadoop Nodename to the external, corporate network IP address for that Hadoop Node.
 
 
SELECT count(*)
FROM SYSLIB.load_from_hcatalog(USING
       server('153.64.234.119')
        port('9083')
        username('hive')
        dbname('default')
        tablename('test')
        columns('*')
        templeton_port('50111')
        hadoop_properties('dfs.client.use.datanode.hostname=true')
)dt;
 
*** Query completed. One row found. One column returned.
 *** Total elapsed time was 11 seconds.
 
   Count(*)
-----------
          5

*** Error 7825 in UDF/XSP/UDM SYSLIB.hcatalog_contract: SQLSTATE 38001: [
TD-SQLH]:unknown host: XXX

There is also a chance that you may need the D2D package mentioned earlier in this wiki if it is a TD15 to HDP 2.1.x.x

Please confirm the hostname in the error is included in the /etc/host/ file next to the IPs of the Master/Name node 

*** Error 7825 in UDF/XSP/UDM SYSLIB.hcatalog_contract: SQLSTATE 38001: [
TD-SQLH]:MetaException(message:Could not connect to meta store using any of t
he URIs provided. Most recent failure: org.apache.thrift.transport.TTransport
Exception: java.net.ConnectException: Conne

Check that /etc/hosts has all the Master/Name nodes and Slave/Data nodes.
Ping to the hostnames, telnet with the correct ports to confirm connection.

Depending on full message, but usually means it is having issues connecting to one of the
Hadoop cluster nodes.