Could not create http connection to jdbc:hive2:HTTP Response code: 413 (state=08S01,code=0)
Category : Hive
If you are using HiveServer2 in HTTP transport mode, then the authentication information is sent as part of HTTP headers. And the above error occurs when the default buffer size is set and the HTTP size is insufficient also using Kerberos is used.
This is a known issue and a bug (https://issues.apache.org/jira/browse/HIVE-11720) has been raised to be addressed in a future release.
To resolve this issue, Set the following properties for a bigger HTTP header size in HiveServer properties:
hive.server2.thrift.http.response.header.size to 32768