@Kuldeep Kulkarni - inode name is /user/p/data. Hive action just read from /user/p/data(external hive table), it's not need acces to write. Then why it works from ssh hive? And this action read data as select from several similar path, but permission denied throws only this path. 1. user.name: tech_dmon 2. mapreduce.job.user.name : tech_dmon ... View more

I am rewrite question, but hdfs dfs -ls /user/ms(tech_dmon) - it's working. I can run hive script from ssh hive, but i can't do it from Oozie hive action. ... View more

@Kuldeep Kulkarni - about inode I have a mistake in question, i am rewrite it. And here is workflow.xml, i will hide some addresses <workflow-app name="D_Sim-wf" xmlns="uri:oozie:workflow:0.4" > <credentials> <credential name='hive_auth' type='hcat'> <property> <name>hcat.metastore.uri</name> <value>thrift://Address</value>. </property> <property> <name>hcat.metastore.principal</name> <value>hive/address</value> </property> </credential> </credentials> <start to="shelldsym"/> <action name="shelldsym"> <shell xmlns="uri:oozie:shell-action:0.2"> <job-tracker>${jobTracker}</job-tracker> <name-node>${nameNode}</name-node> <job-xml>hive-site.xml</job-xml> <configuration> <property> <------> <name>mapred.job.queue.name</name> <------> <value>${queueName}</value> <--><------></property> <------> </configuration> <exec>HDynSim.sh</exec> <argument>${HiveDB}</argument> <file>/user/${us}/${working_dir}/HDynSim.sh#HDynSim.sh</file> <capture-output/> </shell> <ok to="hivedsim"/> <error to="fail"/> </action> <action name="hivedsim" cred="hive_auth"> <hive xmlns="uri:oozie:hive-action:0.2"> <job-tracker>${jobTracker}</job-tracker> <name-node>${nameNode}</name-node> <job-xml>hive-site.xml</job-xml> <configuration> <property> <name>mapred.job.queue.name</name> <--><------><value>${queueName}</value> </property> <property> <name>oozie.hive.defaults</name> <value>hive-site.xml</value> </property> </configuration> <script>hive.hql</script> <param>MY_VAR1=${wf:actionData('shelldsym')['MY_VAR1']}</param> <param>MY_VAR2=${wf:actionData('shelldsym')['MY_VAR2']}</param> </hive> <ok to="javadynsim"/> <error to="fail"/> </action> <action name="javadynsim"> <java> <job-tracker>${jobTracker}</job-tracker> <name-node>${nameNode}</name-node> <job-xml>hive-site.xml</job-xml> <configuration> <property> <name>mapred.job.queue.name</name> <value>${queueName}</value> </property> </configuration> <main-class>DSim.DynSim</main-class> <arg>${MySQLDBname}</arg> <arg>${MySQLUserName}</arg> <arg>${working_dir}</arg> <arg>${us}</arg> <arg>${url}</arg> <arg>${SqlTableName}</arg> <file>lib/HadoopTest-1.0-SNAPSHOT.jar</file> <capture-output/> </java> <ok to="end" /> <error to="fail" /> </action> <kill name="fail"> <message>Script failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message> </kill> <end name='end' /> </workflow-app> And here is job.properties nameNode=hdfs://nameservice1 propertyLoc=coord.properties MySQLDBname=dynsim_mon MySQLUserName=dynsim_mon working_dir=Dynsim us=tech_dmon url=address SqlTableName=D_SIM HiveDB=d_mon jobTracker=address wf_application_path=${nameNode}/user/${us}/${working_dir} oozie.coord.application.path=${wf_application_path} oozie.use.system.libpath=true queueName=prod ... View more