Replied Message ----
>> From Eugene Miretsky
>> Date 11/16/2023 02:21
>> To
>> Subject Slow Hive query with a lot of
>> 'get_materialized_views_for_rewriting'
>> Hey!
>>
>> We have a catalog with fairly a lot of databases and tables.
&g
L] Re: Slow Hive query with a lot of
'get_materialized_views_for_rewriting' |
May I ask when hive4 can be released?
Replied Message
| From | Butao Zhang |
| Date | 11/17/2023 12:24 |
| To | user@hive.apache.org |
| Cc | |
| Subject | Re: [EXTERNAL] Re: Slow Hive quer
May I ask when hive4 can be released?
Replied Message
| From | Butao Zhang |
| Date | 11/17/2023 12:24 |
| To | user@hive.apache.org |
| Cc | |
| Subject | Re: [EXTERNAL] Re: Slow Hive query with a lot of
'get_materialized_views_for_rewriting' |
Thanks for the info.
Iceberg integration, enhanced materialized view, etc.
Thanks,
Butao Zhang
Replied Message
| From | Eugene Miretsky |
| Date | 11/17/2023 09:06 |
| To | |
| Subject | Re: [EXTERNAL] Re: Slow Hive query with a lot of
'get_materialized_views_for_rewriting' |
Hey!
Hive versio
is called by mistake.
>
> Thanks,
>
> Butao Zhang
> Replied Message
> From Eugene Miretsky
> Date 11/16/2023 02:21
> To
> Subject Slow Hive query with a lot of
> 'get_materialized_views_for_rewriting'
> Hey!
>
> We have a catalog with fairl
etsky |
| Date | 11/16/2023 02:21 |
| To | |
| Subject | Slow Hive query with a lot of
'get_materialized_views_for_rewriting' |
Hey!
We have a catalog with fairly a lot of databases and tables.
Where we do a simple query (select * from table limit 5;) on an ideal cluster,
it takes a
Hey!
We have a catalog with fairly a lot of databases and tables.
Where we do a simple query (select * from table limit 5;) on an ideal
cluster, it takes around 20seconds, sometimes longer (usually first run
takes 40s+)
Looking at the hive-metastore logs during most of the query time the logs
sh
