Cheat Code
Ambari-> Hive -> Custom hiveserver2-site
hive.server2.thrift.http.request.header.size=65536
hive.server2.thrift.http.response.header.size=65536
Our Azure HDInsight is secured with Enterprise Service Package/ESP (a fancy name saying the cluster is join domain to AD for authentication). Some of the users said they are having difficulties trying to logon from their beloved, most powerful, most flexible BI tool – Excel.
After troubleshooting with our friend and amazing expert from Microsoft Support, we found that the http header size is quite big from our users connection and it hit the default limit.
So, slapping the cheat code above via Ambari then restart the Hive service.
And in the end users live happily ever after.
My IT Cheat Code 
https://waterfallmagazine.com
Heya i’m for the primary time here. I came across this board and I in finding It really useful & it helped
me out a lot. I hope to give something again and help others like you helped me.
LikeLike