Error Running Teradata to hadoop script "PTS00031"

Tools

Error Running Teradata to hadoop script "PTS00031"

cmd: tbuild -f PTS00031 -v jobvars.txt -j PTS00031

 

Output:

Teradata Parallel Transporter Version 15.10.01.03 64-Bit

Job log: /opt/teradata/client/15.10/tbuild/logs/PTS00031-57.out

Job id is PTS00031-57, running on xyz@123.com

Found CheckPoint file: /opt/teradata/client/15.10/tbuild/checkpoint/PTS00031LVCP

This is a restart job; it restarts at step MAIN_STEP.

Teradata Parallel Transporter Export Operator Version 15.10.01.03

$EXPORT: private log not specified

Teradata Parallel Transporter DataConnector Operator Version 15.10.01.03

$FILE_WRITER[1]: Instance 1 directing private log report to '8589-1'.

$FILE_WRITER[1]: DataConnector Consumer operator Instances: 1

To create the JNI CLASSPATH,

the HADOOP_HOME or HADOOP_PREFIX environment variable is required.

getJNIEnv: getGlobalJNIEnv failed

$FILE_WRITER[1]: TPT19015 TPT Exit code set to 12.

$EXPORT: connecting sessions

$FILE_WRITER[1]: Total files processed: 0.

$EXPORT: disconnecting sessions

$EXPORT: Total processor time used = '0.084 Second(s)'

$EXPORT: Start : Mon Aug 22 22:17:09 2016

$EXPORT: End   : Mon Aug 22 22:17:14 2016

Job step MAIN_STEP terminated (status 12)

Job PTS00031 terminated (status 12)

Job start: Mon Aug 22 22:17:05 2016

Job end:   Mon Aug 22 22:17:14 2016

Job end:   Mon Aug 22 22:17:14 2016

 

I was trying to run the Teradata to hadoop script "PTS00031", and got the above output. 

 

I have filled in the "TPT LOAD Operator attributes" and "TPT DataConnector Producer Operator attributes" in the jobvar.txt files.

3 REPLIES
Teradata Employee

Re: Error Running Teradata to hadoop script "PTS00031"

Did you provide the Hadoop_Home and/or Hadoop_Prefix job variables?

-- SteveF
Enthusiast

Re: Error Running Teradata to hadoop script "PTS00031"

Hi Steve,

If I'm running TPT script for a server which is not edge node (i.e. not any of the node in the hadoop cluster), what value in HADOOP_HOME variable I should provide?

Or, If I want to load data from TD to HDFS via HDFS API, I should execute tbuild command from edge node of Hadoop cluster?

 

Thanks & Regards,

Arpan.

Teradata Employee

Re: Error Running Teradata to hadoop script "PTS00031"

Running TPT-HDFS should allow for TPT to run on the client load sever, not on the Hadoop node. That is the way it was designed.

-- SteveF