Merge Operation Fails -gpload utility greenplum

2019-09-16 18:51发布

问题:

We would like try to describe my problem below: We have small gpdb cluster. In that,we are trying for Data integration using Talend tool.

We are trying to load the incremental from a table to another table, quite simple... I thought...

Job Data Flow is

         tgreenplumconnection
                  | 
tmssqlinput--->thdfsoutput-->tmap-->tgreenplumgpload--tgreenplumcommit

Getting error

Exception in thread "Thread-1" java.lang.RuntimeException: Cannot run program "gpload": CreateProcess error=2, The system cannot find the file specified
    at bigdata.sormaster_stg0_copy_0_1.SorMaster_stg0_Copy$2.run(SorMaster_stg0_Copy.java:6425)
Caused by: java.io.IOException: CreateProcess error=2, The system cannot find the file specified
    at java.lang.ProcessImpl.create(Native Method)
    at java.lang.ProcessImpl.<init>(ProcessImpl.java:386)
    at java.lang.ProcessImpl.start(ProcessImpl.java:137)
    at java.lang.ProcessBuilder.start(ProcessBuilder.java:1029)
    at java.lang.Runtime.exec(Runtime.java:620)
    at java.lang.Runtime.exec(Runtime.java:528)
    at bigdata.sormaster_stg0_copy_0_1.SorMaster_stg0_Copy$2.run(SorMaster_stg0_Copy.java:6413)