Hey guys. Analyzing the jstack, I found that the ALTER DATABASE SET LOCATION performs a check on all the folders inside the database folder in HDFS. And I have some databases with some tables with a loooot of partitions ;-). So nothing abnormal here.
Best regards. On Tue, Nov 23, 2021 at 10:26 AM gwenael le barzic <glebar...@gmail.com> 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 <mydb> SET > LOCATION '<mynewlocation>'. > > When I check the logs of hiveserver2, I can see that the compiling step of > the query takes a looot of time (around 8 minuts). > > I checked my database hive (postgresql) to see if there is any problem > there. > > I was wondering if anyone has already seen this kind of slowness in hive > 3.1.0 ? > > Best regards. > >
