Hello
First time Hop user, first time mailing list message.
Using version 2.0.0 both locally (desktop application) and in a remote
Hop server.
I have a pipeline P1 that is called from a workflow W1. When P1 runs as
part of W1 in the remote hop server, I get the following error:
2022/09/02 14:53:48 - Group by.0 - ERROR: Unexpected error
2022/09/02 14:53:48 - Group by.0 - ERROR:
org.apache.hop.core.exception.HopException:
2022/09/02 14:53:48 - Group by.0 - Please specify an aggregation type
for field 'field_name'
2022/09/02 14:53:48 - Group by.0 -
2022/09/02 14:53:48 - Group by.0 - at
org.apache.hop.pipeline.transforms.groupby.GroupBy.newAggregate(GroupBy.java:622)
2022/09/02 14:53:48 - Group by.0 - at
org.apache.hop.pipeline.transforms.groupby.GroupBy.processRow(GroupBy.java:168)
2022/09/02 14:53:48 - Group by.0 - at
org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:51)
2022/09/02 14:53:48 - Group by.0 - at
java.base/java.lang.Thread.run(Thread.java:833)
2022/09/02 14:53:48 - Table input.0 - Finished reading query, closing
connection.
2022/09/02 14:53:48 - Group by.0 - Finished processing (I=0, O=0, R=1,
W=0, U=0, E=1)
The transformation has an aggregation type set for field 'field_name'.
Actually, the only way to reproduce it is by running W1 remotely, in any
other setup (running P1 locally, running P1 remotely, running W1
locally) the transformation runs without error.
Summarizing:
PASS /path/to/hop-run.sh -r local P1.hwf
PASS /path/to/hop-run.sh -r local W1.hwf
PASS /path/to/hop-run.sh -r remote1 P1.hwf
FAIL /path/to/hop-run.sh -r remote1 W1.hwf
passing '-l ROWLEVEL' doesn't add any meaningful information.
I've tried to look for 'Group By' in Hop's Jira but 'group by' is a term
so generic that search result are noisy.
Do you have any recommendation on how to continue debugging this?
Thanks
m
