The connection to zookeeper seems to fail from hs2. Is your zookeeper up and running? Also is Zookeeper service dependency enabled in HS2 configuration  (CM > Hive > Configuration >ZooKeeper Service > Select service > Save and Restart) ... View more

The call to this region server 1.1.1.1:60020 is getting closed instantly Caused by: org.apache.hadoop.hbase.exceptions.ConnectionClosingException: Call to hostname003.enterprisenet.org/1.1.1.1:60020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosingException: Connection to hostname003.enterprisenet.org/1.1.1.1:60020 is closing. Call id=4045, waitTime=2 1. Is there any hbase-site.xml that is bundled with your application jar? 2. If yes, Can you rebuild the jar with latest hbase-site.xml from /etc/hbase/conf/ 3. I am not sure if server is printing any ERROR but it will be worth to check, what exactly is happening on RS logs in node hostname003.enterprisenet.org at the time   2020 Mar 27 01:18:16 (i.e when the connection from client is closed) ... View more

Can you attach the full exception or the error log - Its unclear what is the actual error with the snippet you pinged in last response ... View more

These are 2 separate issues   ERROR1: Did you delete till /disk{1,2,3,4,5}/yarn/nm/usercache/mcaf or you deleted till  /disk{1,2,3,4,5}/yarn/nm/usercache/   If you had deleted till /disk{1,2,3,4,5}/yarn/nm/usercache/ then please restart all the nodemanagers. If not, Can you please let me know How many nodemanagers do you have in this cluster? Can you run  namei -l /disk{1,2,3,4,5}/yarn/nm/usercache/ across all those machines?   Please paste your result with "Insert or code sample" option in the portable so that it will has better readablity   ERROR2: Mar26 11:36:00,863 main com.class.engineering.portfolio.dmxsloader.main.DMXSLoaderMain: org.apache.hadoop.hbase.client.RetriesExhaustedException thrown: Can't get the location   a. The machine from which you are submitting this job - Does it have hbase gateway installed in it? If not can you run it from a machine which has hbase gateway b. Also since you said this job worked from hbase user and not mcaf - Have you attempted to grant permission to mcaf to the respective table which you are trying to access? https://docs.cloudera.com/documentation/enterprise/5-14-x/topics/cdh_sg_hbase_authorization.html#topic_8_3_2 has the steps c. What is the error you see in HMaster logs during the exact timestamp you notice this error in job? ... View more

These app cache directories gets auto generated upon job submission - So can you remove them from nodemanagers [so that it gets created fresh with required acls]    /disk{1,2,3,4,5}/yarn/nm/usercache/mcaf   and then re-submit the job again ... View more

This error usually happens if the client doesnt match the QOP on server.   Can you share the connection string used in your code snippet? Is your hiveserver2 kerberised? Can you please share what is the value set for this property hive.server2.thrift.sasl.qop in your hiveserver2's hive-site.xml?   Example connection string is in link https://github.com/dropbox/PyHive/pull/135/files/ec5270c4b6556bcd20f0f81afbced4a69ca9eff0 ... View more

You would need to tune your heap in accordance with the number of files. The tuning guideline is in document https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.6.5/bk_command-line-installation/content/configuring-namenode-heap-size.html   If you would like to get count of files, You may run hdfs dfs -count /     ... View more

The capacity is not determined based on your cluster size rather estimated based on NN memory. Refer the code here for the computation details https://github.com/cloudera/hadoop-common/blob/134a29f22676e9a5226a07de6c6b9f34934a4625/hadoop-common-project/hadoop-common/src/main/java/org/apache/hadoop/util/LightWeightGSet.java#L326-L362   BlockSize details are not available in rest response of NN. But you may use RestAPI on ClouderaManager to get the configs. Example is in link: https://docs.cloudera.com/documentation/enterprise/5-14-x/topics/cm_intro_api.html#xd_583c10bfdbd326ba--7f25092b-13fba2465e5--7f20__example_jrl_5ln_tm   For Ambari check in link https://github.com/apache/ambari/blob/trunk/ambari-server/docs/api/v1/index.md ... View more

The individual api's called since namenode start can be obtained from NN JMX http://<nn_hostname>:<port>/jmx?qry=Hadoop:service=NameNode,name=RpcDetailedActivityForPort8020   For HiveServer2 similarly the metrics are in its webui too http://<hiveserver2_hostname>:<webui_port>/jmx https://cwiki.apache.org/confluence/display/Hive/Hive+Metrics   The units are not per day aggregate instead its the aggregate since the service started so you can curl the jmx and then diff it on a per day basis ... View more

@MAS The BlockCapacity metric is different from Blocksize. Per the metrics page [https://hadoop.apache.org/docs/current/hadoop-project-dist/hadoop-common/Metrics.html], block capacity denotes "Current number of block capacity" its unit is not bytes/mb it is number of blocks ... View more

49213 open("/var/lib/ambari-agent/tmp/hadoop_java_io_tmpdir/libleveldbjni-64-1-6110205147654050510.8", O_RDWR|O_CREAT|O_EXCL, 0666) = -1 EACCES (Permission denied) During this step, the script is trying to open and get file descriptor for this directory and it was denied access  /var/lib/ambari-agent/tmp/hadoop_java_io_tmpdir/libleveldbjni-64-1-6110205147654050510.8 So far we have inspected its parent directories and haven't seen any issues with. Can we get details of this directory too ls -ln /var/lib/ambari-agent/tmp/hadoop_java_io_tmpdir/libleveldbjni-64-1-6110205147654050510.8 stat /var/lib/ambari-agent/tmp/hadoop_java_io_tmpdir/libleveldbjni-64-1-6110205147654050510.8 id yarn   ... View more

Per https://serverfault.com/questions/647569/reverse-ssh-connection-time-out-during-banner-exchange this error  may indicate network issues. If you see a socket is established using netstat on both the server and the client, there may be a firewall or packet inspection device that is preventing the SSH connection from being established   Are you able to manually ssh from oozie server machine to the remote <host> as <user>  ... View more

Hi san_t_o Thanks for adding more context.   When cleaning the directories indicated, the libraries are copied automatically or it is necessary to copy them manually? --> /var/log/hadoop-yarn/nodemanager/recovery-state/yarn-nm-state/* and also on /var/lib/ambari-agent/tmp/ I was testing in my local cluster. Apologies, I meant to clear /var/lib/ambari-agent/tmp/hadoop_java_io_tmpdir/ and sorry for the typo in my previous comment.   Even before clearing off these directories or altering the location it would be best to review with strace once. It traces all system level calls and reviewing the last call prior to failure could give us more clues. To install strace - you can run yum -y install strace   export HADOOP_LIBEXEC_DIR=/usr/hdp/3.0.1.0-187/hadoop/libexec strace -f -s 2000 -o problematic_node /usr/hdp/3.0.1.0-187/hadoop-yarn/bin/yarn --debug --config /usr/hdp/3.0.1.0-187/hadoop/conf --daemon start nodemanager export HADOOP_LIBEXEC_DIR=/usr/hdp/3.0.1.0-187/hadoop/libexec strace -f -s 2000 -o good_node /usr/hdp/3.0.1.0-187/hadoop-yarn/bin/yarn --debug --config /usr/hdp/3.0.1.0-187/hadoop/conf --daemon start nodemanager   The file problematic_node and good_node would have the traces and can you attach/paste them here. ... View more

Spark1.6/2.3 arent available in CDH6.3 - Unlike CDH5 you cant add another spark version in CDH6 Quote from doc: Important: CDH 6 does not support using multiple versions of Spark. Upgrading to CDH 6 disables the CDS 2 parcel if it exists, and all Spark services will use the built-in Spark version https://docs.cloudera.com/documentation/enterprise/upgrade/topics/ug_spark_standalone.html ... View more

CDH6.3.x supports Spark2.4.0 - https://docs.cloudera.com/documentation/enterprise/6/release-notes/topics/rg_cdh_63_packaging.html#cdh_630_packaging     ... View more

Please share the full exception from beeline, if full exception is not available try with --verbose on the beeline command ... View more