Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: transformation in kitchen takes along time & Java process is not ending

  1. #1

    Default transformation in kitchen takes along time & Java process is not ending

    Hello,

    I have a problem with kitchen, my job is processing around 20000 rows. The transformation includes an input table step and an sql step including an update statement (updating 3 fields):
    "
    update table1
    set (F1, F2, F3) =
    (select Table2.name, Table2.id, Table2.kurzzeichen from Table2 where Table2.id = Table1.ober5)
    where ober5 != 0;
    "
    when kitchen is called it is taking along time (around 7 H) and often it is not stopping at all (Java process is ruining always and we have to end the process from task-manager) causing the database to be full (due to archive log)
    is there any suggestion what to do, please?
    is there anyway to force to stop after a given time (like a timeout, after 6 H to be stopped)

    thanks in advanced

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Table Input to SQL Statement?
    This could cause the same SQL Statement to be run 1000's of times...

    Since your SQL Statement doesn't need a input, try putting it after a "generate rows" step that is only generating one row.

  3. #3

    Default

    Thanks a lot gutlez, it works

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.