Thyanks for the fruitful discussion , it saved my time. I have just made it working by making below changes  My workflow app xml :   <workflow-app name="shell-impala-invalidate-wf" xmlns="uri:oozie:workflow:0.4"> <start to="shell-impala-invalidate"/> <action name="shell-impala-invalidate"> <shell xmlns="uri:oozie:shell-action:0.1"> <job-tracker>${jobTracker}</job-tracker> <name-node>${nameNode}</name-node> <configuration> <property> <name>mapred.job.queue.name</name> <value>${queueName}</value> </property> </configuration> <exec>${EXEC}</exec> <file>${EXEC}#${EXEC}</file> <file>${EXECQSCRIPT}#${EXECQSCRIPT}</file> </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>   where EXEC and EXECQSCRIPT are the path to the shell script and my sql file respectively.   In my shell script , I just need to add the following lines (I am not using secured environment here, so no Kerberos)   export PYTHON_EGG_CACHE= /home/python-egg-catch impala-shell -f shellq.sql   where shellq.sql is my query file and python-egg-catch is the folder I have created with proper permission.   Thanks     ... View more

Hi, I am able to fix the "Exhausted available authentication methods method" issue the way you suggested. thanks for that. But now I am facing another issue while installing cloudera manager agent. Below is the error message:   Error: Package: cloudera-manager-agent-5.8.1-1.cm581.p0.7.el6.x86_64 (cloudera-manager) Requires: portmap Error: Package: cloudera-manager-agent-5.8.1-1.cm581.p0.7.el6.x86_64 (cloudera-manager) Requires: mod_ssl Error: Package: cloudera-manager-agent-5.8.1-1.cm581.p0.7.el6.x86_64 (cloudera-manager) Requires: httpd   yum install is not soilving my problem since I dont have the repos for portmap, mod_ssl and httpd. Not sure how to install them direcltly from online since I am not getting the correct repo / mirror address.   Looking forward for your cooperation.   ... View more

Hi, I am using CDH 5.4.3 vm to install cloudera manager. But while installing through web console(localhost:7180) I am facing the following error 2016-09-03 09:59:12,012 WARN NodeConfiguratorThread-5-0:com.cloudera.server.cmf.node.NodeConfigurator: Could not authenticate to localhost net.schmizz.sshj.userauth.UserAuthException: Exhausted available authentication methods at net.schmizz.sshj.SSHClient.auth(SSHClient.java:232) at net.schmizz.sshj.SSHClient.auth(SSHClient.java:208) at com.cloudera.server.cmf.node.NodeConfigurator.connect(NodeConfigurator.java:341) at com.cloudera.server.cmf.node.NodeConfigurator.configure(NodeConfigurator.java:889) at com.cloudera.server.cmf.node.NodeConfigurator.run(NodeConfigurator.java:935) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) In my centos vm I do not have any file named 10-perfmgmt under /etc/sudoers.d. So I created one file and add the following lines root ALL=(ALL:ALL) ALL %admin ALL=(ALL) ALL %sudo ALL=(ALL:ALL) ALL userid ALL=(ALL)NOPASSWD:ALL Now my question is, what user id should I write here in order to avoid the error. I am using a vm player and logging as 'training' here. My superuser is 'root'. Why am I getting this error, what is the actual solution for it. Please help me onthis. ... View more