Re: HiveServer2 slowly increaseing background CPU usage until restated

2022-09-07 Thread gwenael le barzic
Hello! In addition to the CPU, did you see if the heap usage of the HS2 was increasing, please ? Le mer. 7 sept. 2022 à 11:48, Deepak Goel a écrit : > Can you please post the utilisation graph of r5.24xlarge too? > > > Deepak > "The greatness of a nation can be judged by the way its animals

Re: Poor Hive 3.1.0 performance

2021-11-23 Thread gwenael le barzic
AM gwenael le barzic wrote: > Hello. > > I send you this mail because I migrated my cluster recently to HDP 3.1.4. > (hive 3.1.0) > > I experience very slow queries when I perform ALTER DATABASE SET > LOCATION ''. > > When I check the logs of hiveserver2, I can

Poor Hive 3.1.0 performance

2021-11-23 Thread gwenael le barzic
Hello. I send you this mail because I migrated my cluster recently to HDP 3.1.4. (hive 3.1.0) I experience very slow queries when I perform ALTER DATABASE SET LOCATION ''. When I check the logs of hiveserver2, I can see that the compiling step of the query takes a looot of time (around 8