Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Total rows Inserted are not equal total rows input

  1. #1
    Join Date
    May 2008
    Posts
    8

    Default Total rows Inserted are not equal total rows input

    I used Table Input to select data from database A and Insert in to database B. I after finished not all input data were inserted.
    Please help, thanks

    Result
    Table Input - Finished reading query, closing connection.
    Table Input - Finished processing (I=152910, O=0, R=0, W=152910, U=0, E=0)
    Insert / Update.0 - linenr 150000
    Insert / Update.0 - Finished processing (I=152910, O=38029, R=152910, W=152910, U=114881, E=0)

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

    Default

    If a row is already in the database *using your specs of row is the same" the row is not update/inserted.

    Regards,
    Sven

  3. #3
    Join Date
    May 2008
    Posts
    8

    Default Thanks

    Thanks sboden, i has just solved this problem. There are many duplicate key in the database

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.