Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: update a row in a table

  1. #1
    Join Date
    Sep 2008

    Default update a row in a table

    where can i found info regarding updating a row of DB using the insert/update command?
    i dont understand what is the stream field used for



  2. #2


    Hi shin,

    think of data processed by Kettle as stream. We have a source (input step) providing a stream of data (tuples). Data is processed by different steps. The update step take one tuple each time and looks whether it finds the key (part of the tuple) in the table. If so it will update some fields in this record. Otherwise it will insert the fields (which have to include the key - next time it can find this record via its key).
    Therefore the update step divide between table fields and stream fields (= input field = field with new/latest data).

    21 is only half the truth

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.