I have a transformation that receive input rows from previous transformation, this inputs rows are used to replace variable in query. Sometimes my table input runs for too long, it takes til 1h to get rows from query, but I don't know where's to find some solution.
Please, anyone could help me?
this is problem of DB server. Perform execution query plan for more details. Or may be problem with network for receive data from server.
Thanks for you reply :)
Do you think it could be a Pentaho issue too or not?
And strange is that table input step has hop from previous step but doesn't load any row.
What are you meaning Pentaho issue too? I don't understand it.
Need a lot more detail as asked above. What are the "Get Variables"? Base on youyr question it seems like actually the row data from the prior transform. Then you replace variables in the stream. Why are you blocking and what are those settings? Are you blocking for all input rows 100k+? That will cause memory issues and could create thrashing on the input stream because you cannot output the rows.
A proud part of Hitachi Vantara
© Hitachi Vantara Corporation. All Rights Reserved.