there are couple of places that needsd tuining in the query level
1 . stats for the table is must for good performance
2. when user is joining two tables make sure there are using the large table in the last and the first table is smaller
3. you can also use HINTS to imporve query performance.
4. hive table's file format is big a factor
5. choosing when to use paritioning vs bucketing.
6.allocate good memory to hiveserver2 and metastore
7.heapsize
8 .load balancer on the host
https://www.cloudera.com/documentation/enterprise/5-9-x/topics/admin_cm_ha_hosts.html#concept_qkr_bf...