Re: CachedStore for hive.metastore.rawstore.impl in Hive 3.0

2024-02-28 Thread Sungwoo Park
We didn't make any other attempt to fix the problem and just decided not to use CachedStore. However, I think our installation of Metastore based on Hive 3.1.3 is running without any serious problems. Could you share how long it takes to compile typical queries in your environment (with Hive 1

Re: CachedStore for hive.metastore.rawstore.impl in Hive 3.0

2024-02-28 Thread Pau Tallada
Hi, We also had to disable CachedStore as it was producing wrong results in our queries. I'm sorry I cannot provide more detailed info. Cheers, Pau. Missatge de Takanobu Asanuma del dia dc., 28 de febr. 2024 a les 13:59: > Thanks for your detailed answer! > > In the original email, you

Re: CachedStore for hive.metastore.rawstore.impl in Hive 3.0

2024-02-28 Thread Takanobu Asanuma
Thanks for your detailed answer! In the original email, you reported "the query compilation takes long" in Hive 3.0, but has this issue been resolved in your fork of Hive 3.1.3? Thank you for sharing the issue with CachedStore and the JIRA tickets. I will also try out

Re: CachedStore for hive.metastore.rawstore.impl in Hive 3.0

2024-02-28 Thread Sungwoo Park
Hello Takanobu, We did not test with vanilla Hive 3.1.3 and Metastore databases can be different, so I don't know why Metastore responses are very slow. I can only share some results of testing CachedStore in Metastore. Please note that we did not use vanilla Hive 3.1.3 and instead used our own