Hi,
> I was looking at HiveServer2 performance going through Knox in KNOX-1524 and > found that HTTP mode is significantly slower. The HTTP mode does re-auth for every row before HIVE-20621 was fixed – Knox should be doing cookie-auth to prevent ActiveDirectory/LDAP from throttling this. I fixed it for the open-source JDBC drivers, but I think the proprietary ODBC drivers are still broken (the C++ code doesn’t save cookies). > I also didn't see any information about reducing amount of data over the wire > with compression. It’s possible Knox doesn’t generate/forward the Accept-Encoding headers. https://issues.apache.org/jira/browse/HIVE-17194 Cheers, Gopal From: Prasanth Jayachandran <pjayachand...@hortonworks.com> Reply-To: "user@hive.apache.org" <user@hive.apache.org> Date: Monday, October 15, 2018 at 12:34 PM To: "user@hive.apache.org" <user@hive.apache.org>, "user@hive.apache.org" <user@hive.apache.org> Subject: Re: HiveServer2 performance references? One performance fix that is fixed recently and is related is HIVE-20621 Thanks Prasanth On Mon, Oct 15, 2018 at 12:11 PM -0700, "Kevin Risden" <kris...@apache.org> wrote: Are there any resources on HiveServer2 performance - specifically binary vs HTTP mode? I would also be interested in any information about enabling compression between HiveServer2 and a client like beeline. I was looking at HiveServer2 performance going through Knox in KNOX-1524 and found that HTTP mode is significantly slower. I searched and didn't find any references to performance of HiveServer2 out of the box. I also didn't see any information about reducing amount of data over the wire with compression. Any pointers would be very helpful. Thanks! Kevin Risden