Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: BulkLoad INTO MYSQL PROBLEM

  1. #1

    Default BulkLoad INTO MYSQL PROBLEM

    HI,
    I am facing a problem when i try to bulk load into database using the Bulk Loader available in jobs.If my file ,which is to be uploaded contains more than 20 or even 20 rows.
    Syntax being used:
    LOAD DATA CONCURRENT INFILE '' REPLACE INTO TABLE feed_articles FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES ()
    I get an error:
    Data truncated for column '' at row 16
    or
    Data truncated for column '' at row 96
    I tried using the MySql Bulk Loader in transformations,but that is not working.
    Please help.
    P.S. I am attaching a trial job and transformation as well.


    trial.ktrtesting.kjb

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

    Default

    It means that the data you are trying to load has a length that is too long or a precision that is too high (for floating point data).

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.