GitHub user fcwojtul created a discussion: Hop workflow issue: Process receives 
old rows instead of empty result after lookup

Hi! I’ve just switched from Pentaho and I’m having a problem with one of my 
workflows.

I have a workflow layout like this:
crts – copy rows to result
grfr – get rows from result

get_data1 (crts) → (grfr) process_data_1 (crts) → (grfr) get_data_2 (crts) → 
(grfr) process_data_2

In get_data_2 I fetch records from the previous transformation and then check 
their existence in the database (database lookup). The data doesn’t exist in 
the database, so the lookup returns no rows, and as a result no dataset is 
passed forward.
Then process_data_2, during get rows from result, receives the same set of rows 
as get_data_2, instead of an empty one, so it crashes because the expected 
columns are missing.

Is this normal behavior in Hop? In Pentaho it worked differently — it didn’t 
pass those rows forward.
Is this an issue caused by importing Pentaho → Hop, or is this simply a 
behavioral difference between the two tools?

GitHub link: https://github.com/apache/hop/discussions/6059

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to