passing convext parameter value to the shell scripts in tSSH to execute the Hive scripts

TamilM — Sat, 16 Nov 2024 09:07:16 GMT

Hi Team,

I need some immediate help from you, I have job that run the shell scripts in the Hive, for that I need some parameters to be passed from the context variable (context.batch_ID) some are directly given like table name like material_detail and so on.

I'm using tSSH component to do this , the below is my code in the tSSH component , but when I run the script its saying

"sh: Load_EDW_Table_v1_0.sh: No such file or directory" and nothing got executed, but the server , directory are correct. what's wrong with this syntax ? if its wrong tell me how to pass the parameter value outside the scripts ? can anyone help ?

tSSH component comment:

"sh Load_EDW_Table_v1_0.sh '"+context.Batch_ID+"' material_detail Material_PK /root/EDWTableLoad/HiveQl/Script_scdtype2_edw_layer_material_detail_v1_0.sql"

My shell scripts parameters:

# send the batch number as parameter to all shell script
vbatchNumber=${1}
# send the edw table as parameter to all shell script
vtablename=${2}
# send the edw table as parameter to all shell script
vPrimaykey=${3}
# send the module or sql script name parameter to all shell script
vmoduleName=${4}

Thanks in advance

Tamil

Re: passing convext parameter value to the shell scripts in tSSH to execute the Hive scripts

TRF — Mon, 30 Oct 2017 12:57:18 GMT

Hi,

Try to add the path before the script name, giving:
/usr/blablabla/Load_EDW_Table_v1_0.sh

topic passing convext parameter value to the shell scripts in tSSH to execute the Hive scripts in Talend Studio

passing convext parameter value to the shell scripts in tSSH to execute the Hive scripts

Re: passing convext parameter value to the shell scripts in tSSH to execute the Hive scripts