Issue Loading from Teradata

Aster
Enthusiast

Issue Loading from Teradata

I'm trying to load a table from teradata using the below:

create table test_table distribute by hash(field1)

as

select *

from load_from_teradata(

on mr_driver

TDPID('hostname')

logon_mechanism('ldap')

username('user')

password('password')

query

('Select  field1,field2,field3,field4,field5 from source_table'));

I keep getting a numeric overflow on my decimal columns they are declared as decimal(15,2) in the teradata database table itself. I've attached the log from the process itself and map reduce maps them all but it looks like something is being aggregated and i can't figure out why or what and how to stop it

[10323] CLIENT - INFO:   Using Teradata Client API version 13.10.00.005
[10323] CLIENT - INFO: Calling Initiate() in instance 1 at time 1394651875
[10323] CLIENT - INFO: Initiate() returned 1 in instance 1 at time 1394651875
[10323] CLIENT - INFO: Starting to wait at barrier Initiate in instance 1
[10323] CLIENT - INFO: Calling Initiate() in instance 1 at time 1394651875
[10323] CLIENT - INFO: Initiate() returned 5 in instance 1 at time 1394651875
[10323] CLIENT - INFO: Starting to wait at barrier InitiateSchema in instance 1
[10323] CLIENT - INFO: Successfully set schema in instance 1
[10323] CLIENT - INFO: Calling Initiate() in instance 1 at time 1394651876
[10323] CLIENT - INFO: Initiate() returned 2 in instance 1 at time 1394651876
[10323] CLIENT - INFO: Starting to wait at barrier InitiateTELINFO in instance 1
[10323] CLIENT - INFO: Received TELINFO buffer in instance 1
[10323] CLIENT - INFO: Successfully set TELINFO in instance 1
[10323] CLIENT - INFO: Calling Initiate() in instance 1 at time 1394651876
[10323] CLIENT - INFO: Initiate() returned 1 in instance 1 at time 1394651876
[10323] CLIENT - INFO: Starting to wait at barrier Initiate in instance 1
[10323] CLIENT - INFO: Calling Initiate() in instance 1 at time 1394651876
[10323] CLIENT - INFO: Initiate() returned 1 in instance 1 at time 1394651876
[10323] CLIENT - INFO: Starting to wait at barrier Initiate in instance 1
[10323] CLIENT - INFO: Calling Initiate() in instance 1 at time 1394651876
[10323] CLIENT - INFO: Initiate() returned 3 in instance 1 at time 1394651876
[10323] CLIENT - INFO: Starting to wait at barrier InitiateEnd in instance 1
[10323] CLIENT - INFO: Successfully completed Initiate() in instance 1 at time 1394651876
[10323] CLIENT - INFO: Max buffer length: 64260, row header length: 2, bytes for row length: 2, buffer trailer length: 0
[10323] CLIENT - INFO: Starting to wait at barrier GetBufferTELINFO in instance 1
[10323] CLIENT - INFO: Received TELINFO buffer in instance 1
[10323] CLIENT - INFO: Successfully set TELINFO in instance 1
[10323] CLIENT - INFO: Starting to wait at barrier GetBuffer in instance 1
[10323] CLIENT - INFO: Starting to wait at barrier GetBuffer in instance 1
[10323] CLIENT - INFO: Starting to wait at barrier GetBufferEnd in instance 1
[10323] CLIENT - ERROR: Received error termination message
[10323] CLIENT - ERROR: numeric field overflow: A field with precision 15, scale 2 must round to an absolute value less than 10^13. [Error Info: code=4000; message="numeric field overflow: A field with precision 15, scale 2 must round to an absolute value less than 10^13."]
[10323] INTERNAL - INFO: input provider read a total of 0 rows, 0 bytes
[10323] INTERNAL - WARN: row emitter closed without flushing (0 bytes unflushed)
[10323] INTERNAL - INFO: sending error message from runner-side: numeric field overflow: A field with precision 15, scale 2 must round to an absolute value less than 10^13.
[10323] INTERNAL - ERROR: task failed [Error Info: code=4000; message="numeric field overflow: A field with precision 15, scale 2 must round to an absolute value less than 10^13."]