I have oberserved, hive is extremely slow to execute even if a simple select command or use command in CDH 5 sandbox. I have used CDH 5.5 and then upgraded to the latest i.e. CDH 5.13. The slowness didn't go away. I have allocated 2 core processors and 12 GB RAM to the VM. I also have turned off all other services except HDFS, YARN and Hive. Cluster CPU is just at 10%.
Anyone facing the same issues or have solution to it, please let me know.
I have resolved this issue, by two ways: