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 :

enter image description here

when send job ask parameter values, put:

enter image description here

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&#39;action échoué, message d&#39;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

Popular posts from this blog

sublimetext3 - what keyboard shortcut is to comment/uncomment for this script tag in sublime -

java - No use of nillable="0" in SOAP Webservice -

ubuntu - Laravel 5.2 quickstart guide gives Not Found Error -