hive - Hue: oozie parameters -
i want pass 2 parameters hiveql script in oozie, script:
alter table default.otarie_appsession add if not exists partition ( insert_date=${dt},hr=${hr} );
my oozie workflow :
when send job ask parameter values, put:
and error:
2016-02-05 18:41:55,460 warn org.apache.oozie.action.hadoop.hiveactionexecutor: server[dvs1vm65] user[root] group[-] token[] app[my_workflow] job[0000290-160122145737153-oozie-oozi-w] action[0000290-160122145737153-oozie-oozi-w@hive-a586] launcher error, reason: main class [org.apache.oozie.action.hadoop.hivemain], exit code [40000]
this xml of workflow:
<workflow-app name="my_workflow" xmlns="uri:oozie:workflow:0.5"> <start to="hive-a586"/> <kill name="kill"> <message>l'action échoué, message d'erreur[${wf:errormessage(wf:lasterrornode())}]</message> </kill> <action name="hive-a586"> <hive xmlns="uri:oozie:hive-action:0.2"> <job-tracker>${jobtracker}</job-tracker> <name-node>${namenode}</name-node> <job-xml>/user/oozie/some_scripts/hive-site.xml</job-xml> <script>/user/oozie/some_scripts/addpart.hql</script> <param>hr=</param> <param>dt=</param> </hive> <ok to="end"/> <error to="kill"/> </action> <end name="end"/> </workflow-app>
when remove parmeters , use hard coded value, script works fine, clear have problem pass parameters. , final goal pass current date , hour.
thank you.
what setting hive parameters oozie parameters...
<param>hr=${biloutehr}</param> <param>dt=${biloutedt}</param>
...then setting values these oozie parameters @ submission time?
biloutehr 00 biloutedt 20160105
hope solves issue, biloute.
Comments
Post a Comment