Try to increase the heap size for nodemanager from Yarn -> Configs and see if that resolves your issue.  If not then probably you will have to do a performance or query tuning.   Please accept this answer if it helps you resolve your issue. ... View more

@AHassan  You can use the below command to start  HiveServer2 from the command line   #su $HIVE_USER nohup /usr/hdp/current/hive-server2/bin/hiveserver2 -hiveconf hive.metastore.uris=/tmp/hiveserver2HD.out 2 /tmp/hiveserver2HD.log    Refer below doc for more info on starting hdp services from the command line https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.6.0/bk_reference/content/starting_hdp_services.html ... View more