Hi cconner It worked by your example, thanks! But if I want to execute impala-shell -f *.sql , in Oozie ,there was error mentioned couldn't find the file. I had upload the sql file into Oozie workspace and add path for it . I try to pass shell argument, like ./impala-shell -f $2 ,but it didn't work. Could you please tell me how to do it in right way? This is my xml ( I replaced sensitive info by ***): <workflow-app name="impala-shelltest" xmlns="uri:oozie:workflow:0.4"> <credentials> <credential name="hcat" type="hcat"> <property> <name>hcat.metastore.uri</name> <value>thrift://***:9083</value> </property> <property> <name>***</name> <value>***</value> </property> </credential> <credential name="hive2" type="hive2"> <property> <name>hive2.jdbc.url</name> <value>jdbc:hive2://***:10000/default</value> </property> <property> <name>hive2.server.principal</name> <value>hive/***</value> </property> </credential> </credentials> <start to="impalashell"/> <action name="impalashell" cred="hcat,hive2"> <shell xmlns="uri:oozie:shell-action:0.1"> <job-tracker>${jobTracker}</job-tracker> <name-node>${nameNode}</name-node> <exec>runstats.sh</exec> <argument>***.keytab</argument> <argument>***.sql</argument> <file>runstats.sh#runstats.sh</file> <file>***.keytab#***.keytab</file> <file>***.sql#***.sql</file> <capture-output/> </shell> <ok to="end"/> <error to="kill"/> </action> <kill name="kill"> <message>Action failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message> </kill> <end name="end"/> </workflow-app>
... View more
