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.