@Anks2411 This could be a bug since it's an older CM version but looking at the logs this seems issue with alternatives.    Can you try these steps and let me know if this improves the behaviour.  1. Stop all roles on the host. 2. Stop the agent. 3. Ensure that the agent and supervisord are fully stopped. 4. Verify the output of the follow command and ensure that it only captures information related to cloudera.   \ls -l /etc/alternatives/ | grep "\/opt\/cloudera"   5. Run the following shell script to cleanup and remove all alternatives related to cloudera parcels.   $ \ls -l /etc/alternatives/ | grep "\/opt\/cloudera" | awk {'print $9'} | \ while read m; do if [[ -e /var/lib/alternatives/${m} ]] ;then echo "Removing ${m}"; \ rm -fv /var/lib/alternatives/${m} ; fi; rm -fv /etc/alternatives/${m}; done   6. Start the agent and review the log data in /var/log/cloudera-scm-agent/cloudera-scm-agent.log. You should see the agent attempt to create new alternatives for your parcels.   7. Verify where the alternative point and restart the roles on the host. Feel free to keep us updated here.  ... View more

Settings look fine. _HOST gets replaced by the actual FQDN of the host at runtime. One thing to check is to make sure reverse DNS lookup works on all hosts.    ... View more

Since this is an external table (EXTERNAL_TABLE), Hive will not keep any stats on the table since it is assumed that another application is changing the underlying data at will.  Why keep stats if we can't trust that the data will be the same in another 5 minutes?  For a managed (non-external) table, data is manipulated through Hive SQL statements (LOAD DATA, INSERT, etc.) so the Hive system will know about any changes to the underlying data and can update the stats accordingly.   Using the HDFS utilities to check the directory file sizes will give you the most accurate answer. ... View more