my ssh-action problem is that, run "ls" or"pwd" or "mkdir dirtest" or "java -version" with ssh action is successful. but, when i run "sqlplus","sqlplus user/pass","sqlplus user/pass@localhost/pdb1 @test.sql " is failed and there is not any useful log in "log" tab or "oozie-oozie" directory. and you know i want execute some oracle sql statement bu oozie ssh action. thank you very much. ... View more

my oozie ssh-action problem is that, run "ls" or"pwd" or "mkdir dirtest" or "java -version" with ssh action is successful. but, when i run "sqlplus","sqlplus user/pass","sqlplus user/pass@localhost/pdb1 @test.sql " is failed and there is not any useful log in "log" tab or "oozie-oozie" directory. and you know i want execute some oracle sql statement bu oozie ssh action. thank you very much. ... View more

A simple oozie [ cloudera 5.9 ] SSH action(ls -l) takes 10 minutes to execute or times out, though succeeds eventaully ..... Why We have a sood size oozie server [ where the shh action executes from ] and another linux machine [ where the ssh action is remotely executed ], yet the time to execute takes nearly 10 minutes....the result is succesful ....eventually .  Is this normal?   i meet the same problem as here , 'CURL' is installed on each machine. but, i don't understand the meaning  of "Can you make sure that the target machine is able to send a GET request to the Oozie server"  replyed by Robert K.,and how can i test it?   how can i solved this problem? thank you very much! ... View more

I have a 5 node cluster, where I have deployed CDH-5.9.0-1.cdh5.9.0.p0.23-el7.parcel Other details: Java Version: 1.8., CentOS Linux release 7.3   Now, all the services are up and running except for Hive- Hive Metastore, and which in turn results for Impala's bad health. The major issue is that the Hive metastore is not coming up and throws the below error: java.lang.NullPointerException at org.apache.hadoop.hive.metastore.ObjectStore.getObjectCount(ObjectStore.java:1103) at org.apache.hadoop.hive.metastore.ObjectStore.getTableCount(ObjectStore.java:1081) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:103) at com.sun.proxy.$Proxy7.getTableCount(Unknown Source) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.updateMetrics(HiveMetaStore.java:6244) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:528) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84) at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6280) at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6275) at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:6525) at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:6452) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136) Exception in thread "main" java.lang.NullPointerException   On further investigating the logs, I found the message as below: Can't open /opt/cm5.9.0/run/cloudera-scm-agent/process/{PID}-hive-HIVEMETASTORE/supervisor.conf: Permission denied.         But i think this "Permission denied" isn't the cause,because this "Permission denied" is appearing while starting HBase too,so, i think this "Permission denied" isn't the cause. By the way, hive MetaStore link to Mysql metaDataBase  is ok, it can create table and insert data automatically.   This trouble is the same as here   , Nobody reply except me.   Anyone faced the same issue and got this fixed or has any idea about the issue..THANKS! ... View more