Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Bulk load into Mysql

  1. #1
    Join Date
    Jun 2007
    Posts
    128

    Default Bulk load into Mysql

    Hi,

    As specified Bulk load into mysql is very faster.
    Can we use this Mysql bulk load to load multiple files by specifying the directory name as we have done with text file input.


    Thanks
    Sreelatha

  2. #2
    Join Date
    Jun 2007
    Posts
    128

    Default

    Hi,

    I have created a job tusing Bulk load into Mysql.
    So this contains start and bulk load into Mysql connected by a hop.
    I have given a csv file as source and target table.When I run the job i am getting
    Start job entry started
    Bulkload intoMysql Unconditional link

    and nothing is happening.

    Do I need to add anything to transformation.

    Thanks
    Sreelatha

  3. #3
    Join Date
    May 2006
    Posts
    4,882

    Default

    Normally not.
    Sven

  4. #4
    Join Date
    Jun 2007
    Posts
    128

    Default

    Hi,

    Can we use multiple files in Bulk load to Mysql .There is no option to specify multiple files in that job step.Can we do it by adding a transformation to the job?

    Thanks
    Sreelatha

  5. #5

    Default

    Hi Sreelatha,

    Mysql Bulk Load source files name is variable sensible, so you can create one job that get all files and the for each one run the bulk load.

    Anyway, if you really need that Mysql Bulk fetch many files, you can file a Request feature.
    Rgds
    Samatar

  6. #6

    Default

    Sorry,

    for new feature :

    http://jira.pentaho.org/secure/CreateIssue!default.jspa

    Rgds

    Samatar

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.