RE: When trying to load the hive data into Teradata table getting ERROR: TPT10510: Instance 1: Error Limit has been reached or exceeded.
When trying to ingest the hive data into Teradata table. As part of execution during the loading of Teradata target table we are facing the ERROR: TPT10510: Instance 1: Error Limit has been reached or exceeded.
This Error occurs when the error limit crosses the one specified in the job level properties. The Error record can be happening due to constraint violation based on the error code TPT10510 specified.
In order to overcome this issue increase the error limit and then try to run the dataflow. once the jobflow is succeded. Try to query the error tables1 and error tables2 then you will know the reason why these records are considered as error records.