PDA

View Full Version : How to sort rows in Kettle Etl tool?



kettle_anonymous
01-22-2006, 08:46 PM
While transforming data from one table which has More than 1 lac records to anoher table i am getting an error Tablename:linenr 5000

jbleuel
01-23-2006, 12:42 AM
When 5000 lines are reached, the Sort step uses a temp-file. Check the "Sort directory" in your Sort step. When the directory is wrong, an error like "ERROR : Error processing temp-file: java.io.IOException: Path not found [or similar]" arises. In the latest Kettle version the directory is set by default to "%%java.io.tmpdir%%".

MattCasters
01-23-2006, 12:42 AM
Hi anonymous,

If you post the complete error log, maybe we can help you.
By the way, what is a lac record?

Did you try to verify the transformation. Kettle will check for missing fields, etc.

Thanks,

Matt