External procedure using shell script execute error 4424
I was attempting to create external procedure.
I used the example from vertica https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/ExtendingHPVertica/ExternalProcedures/CreatingExternalProcedures.htm
However when i execute the procedure getting error 4424 as shown below.
select helloplanet('test') ;
INFO 4427 : Procedure reported
Could not execute procedure , errno=2
ERROR 4424 : Procedure execution error:exit status=1
Username is dbadmin