Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Not able to load \ in a file using mysql bulk laod

  1. #1

    Default Not able to load \ in a file using mysql bulk laod

    I am generating a large file form google analytics and it has many reocrds which has \ at the end.

    Error records\,1,2,3,
    Since , is escpaed while loading the file though my sql loader . Any idea how can I go ahead with loading this file in penthaa.

  2. #2
    Join Date
    Apr 2008


    If it's a text file, use Text Input File step to load the file, then use Table Output step to copy data to MySQL.


  3. #3


    Due to the large volume of the file and table is truncate and load , we need to use bulk upload functionality of mysql and hence using sql loader for the same.

  4. #4
    Join Date
    Nov 1999


    Have a few step copies do string replacement on that field (\ --> \\, something like that)?

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.