Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Uploading data from CSV to Table

  1. #1
    Join Date
    Feb 2016
    Posts
    27

    Default Uploading data from CSV to Table

    I have a giant file I need to upload from a CSV file to a Database Table.

    If I create 10 different tables and distribute (not copy) the file to 10 different outputs, will this be a faster upload? (Later on, I will just merge the table data).

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    I seldom have to deal with more than a million rows, but I couldn't help but notice Kettle supports bulk loaders for a couple of RDBMS.
    Isn't your database system supported?
    So long, and thanks for all the fish.

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.