@Mohammad Shamim The troubleshooting depends on which kind of Job are you running. However if a job is running slow then broadly there may be any of the following reason which needs to be check as First Ad. 1. Please check if there are any slow responding threads or threads that are consuming more CPU cycles? In such scenarios it is better to collect Thread dumps and the CPU metrics to understand the thread level issues/slowness/hung/CPU utilization etc. https://community.hortonworks.com/articles/72319/how-to-collect-threaddump-using-jcmd-and-analyse-i.html . 2. Please check the memory utilization by your Job and to find out if the memory that is allocated for your job execution is sufficient or needs some tuning. In that case based on the nature of your Job please check the following links: https://community.hortonworks.com/articles/22419/hive-on-tez-performance-tuning-determining-reducer.html https://hortonworks.com/blog/how-to-plan-and-configure-yarn-in-hdp-2-0/ https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.2/bk_spark-component-guide/content/ch_tuning-spark.html . ... View more

@Mohammad Shamim Do desc formatted on the table name,this command will display either the table is External (or) Managed and Location of the table. hive# desc formatted <db-name>.<db-table-name>; Check Size of the Database:- bash# hdfs dfs -count -h -v <hdfs-location> Example:- In the above screenshot you can view i ran desc formatted devrabbit table, The table type is Managed table and the location of the table is /user/hdfs/hive if you want to find the size of the above location then do hdfs dfs -count -h -v /user/hdfs/hive It will display the size of the directory. ... View more