Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to sort rows in Kettle Etl tool?

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default How to sort rows in Kettle Etl tool?

    While transforming data from one table which has More than 1 lac records to anoher table i am getting an error Tablename:linenr 5000

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: How to sort rows in Kettle Etl tool?

    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

  3. #3
    Join Date
    Nov 1999
    Posts
    459

    Default RE: How to sort rows in Kettle Etl tool?

    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%%".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.