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 :www.test.com\,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
    Posts
    1,771

    Default

    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.

    Mick

  3. #3

    Default

    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
    Posts
    9,729

    Default

    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.