Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: Bulk load into Mysql

  1. #1
    Join Date
    Jun 2007
    Posts
    128

    Default Bulk load into Mysql

    Hi,

    Sorry to repost this again.But I really didn't understand what the actual problem is.
    I created a job with start and BulkLoad into MySQL to load a csv file into mysql.When I run the job i am getting

    BulkLoad into MySQl job entry started Followed unconditional link filename.

    Nothing is shown under result and also nothing is happening.

    What might be the problem here and how to solve this.I am trying to use this feature in my project.
    Please help me.

    Thanks
    Sreelatha

  2. #2

    Default

    Hi Sreelatha,

    did you put the log to detailed or debug?

    Rgds

    Samatar

  3. #3
    Join Date
    Jun 2007
    Posts
    128

    Default

    Hi,

    I set my log to detailed and this is how it looks.

    2007/09/19 12:41:05 - Job 1 - Loading 2 job entries
    2007/09/19 12:41:05 - Job 1 - Loading 1 job hops
    2007/09/19 12:41:05 - Chef - Starting job...
    2007/09/19 12:41:05 - con1 - New database connection defined
    2007/09/19 12:41:05 - con1 - Connected to database.
    2007/09/19 12:41:05 - con1 - Connection to database closed!
    2007/09/19 12:41:05 - Thread[Job 1 (Job 1 (Thread-3)),5,main] - exec(0, 0, Start.0)
    2007/09/19 12:41:05 - Thread[Job 1 (Job 1 (Thread-3)),5,main] - Sleeping: 0 minutes
    2007/09/19 12:41:05 - Job 1 - Starting entry [BulkLoad into Mysql 1]
    2007/09/19 12:41:05 - Thread[Job 1 (Job 1 (Thread-3)),5,main] - exec(1, 0, BulkLoad into Mysql 1.0)
    2007/09/19 12:41:05 - BulkLoad into Mysql 1 - File [/home/srilatha/f41651.csv] exists.
    2007/09/19 12:41:05 - con1 - New database connection defined
    2007/09/19 12:41:05 - con1 - Connected to database.

    Thanks
    Sreelatha

  4. #4

    Default

    At first sight, it seems that the job is done...
    Do you check that data are "really" loaded ?

    If you still facing this issue.
    Please attach your file with a little bit infos (table colums,..)

    i will have a look

    Rgds

    Samatar

  5. #5
    Join Date
    Jun 2007
    Posts
    128

    Default

    Hi,
    No data is not loaded into the table.
    I tried it with a small file with different data.

    Here is the sample data;
    outlook,temperature,hunidity,windy,play
    sunny,85,85,FALSE,no sunny,80,90,TRUE,no overcast,83,86,FALSE,yes rainy,70,96,FALSE,yes rainy,68,80,FALSE,yes rainy,65,70,TRUE,no overcast,64,65,TRUE,yes sunny,72,95,FALSE,no sunny,69,70,FALSE,yes rainy,75,80,FALSE,yes sunny,75,70,TRUE,yes overcast,72,90,TRUE,yes overcast,81,75,FALSE,yes rainy,71,91,TRUE,no


    I have attached my job also.

    Thanks
    Sreelatha
    Attached Files Attached Files

  6. #6

    Post

    Hi,
    It's working fine (see picture).
    Anyway, you should get the log..

    I saw that you use log table, did you tried without log table?

    Rgds

    Samatar
    Last edited by shassan2; 03-27-2008 at 06:02 AM.

  7. #7
    Join Date
    Jun 2007
    Posts
    128

    Default

    Hi,

    I tried without log file also.But the problem is still there.I am unable to find the problem.


    Thanks
    Sreelatha

  8. #8
    Join Date
    Jun 2007
    Posts
    128

    Default

    Hi,

    Does Bulk Load into MySQL depends on the MySQL version.Is there any requirement for a particular version.I am using MySQL version 5.0.4.Which version of MySQL should be used to make it work?

    Thanks
    Sreelatha

  9. #9

    Default

    Hi Sreelatha,
    I use the version 5.0.27 and it works.
    I read somewhere that the "Local" option will work (since MySQL 3.23.49 and MySQL 4.0.2) only if both client & server handle it.

    see

    http://dev.mysql.com/doc/refman/5.0/...ata-local.html

    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.