Re: Re: Hive's performance for querying the Iceberg table is very poor.

2023-11-10 Thread Simhadri G
Please ensure hive.stats.autogather is enabled as well. On Fri, Nov 10, 2023, 2:57 PM Denys Kuzmenko wrote: > `hive.iceberg.stats.source` controls where the stats should be sourced > from. When it's set to iceberg (default), we should go directly to iceberg > and bypass HMS. >

Re: Re: Hive's performance for querying the Iceberg table is very poor.

2023-11-10 Thread Denys Kuzmenko
`hive.iceberg.stats.source` controls where the stats should be sourced from. When it's set to iceberg (default), we should go directly to iceberg and bypass HMS.

Re: Re: Hive's performance for querying the Iceberg table is very poor.

2023-11-09 Thread Butao Zhang
this location_based_table table in hive. Does it also launch the tez task to scan table? Thanks, Butao Zhang Replied Message | From | lisoda | | Date | 11/9/2023 15:50 | | To | | | Subject | Re:Re: Re: Hive's performance for querying the Iceberg table is very poor. | STEP1: CREATE TABLE US

Re:Re: Re: Hive's performance for querying the Iceberg table is very poor.

2023-11-08 Thread lisoda
3-11-09 15:36:50,"Butao Zhang" 写道: Could you please provide detailed steps to reproduce this issue? e.g. how do you create the table? Thanks, Butao Zhang Replied Message | From | lisoda | | Date | 11/9/2023 14:25 | | To | | | Subject | Re:Re: Re: Hive's performance for

Re: Re: Hive's performance for querying the Iceberg table is very poor.

2023-11-08 Thread Butao Zhang
Could you please provide detailed steps to reproduce this issue? e.g. how do you create the table? Thanks, Butao Zhang Replied Message | From | lisoda | | Date | 11/9/2023 14:25 | | To | | | Subject | Re:Re: Re: Hive's performance for querying the Iceberg table is very

Re:Re: Re: Hive's performance for querying the Iceberg table is very poor.

2023-11-08 Thread lisoda
x27;t take effect if having delete files. Thanks, Butao Zhang Replied Message | From | lisoda | | Date | 11/9/2023 10:43 | | To | | | Subject | Re:Re: Re: Hive's performance for querying the Iceberg table is very poor. | HI. I am testing with HIVE-4.0.0-BETA

Re: Re: Hive's performance for querying the Iceberg table is very poor.

2023-11-08 Thread Butao Zhang
10:43 | | To | | | Subject | Re:Re: Re: Hive's performance for querying the Iceberg table is very poor. | HI. I am testing with HIVE-4.0.0-BETA-1 version and I am using location_based_table. So far I found that HIVE still can't push some queries down to METADATA, e.g. COUNT(*). Is HI

Re:Re: Re: Hive's performance for querying the Iceberg table is very poor.

2023-11-08 Thread lisoda
g to use starrocks. mpp architecture databases have natural limitations, and starrocks does not necessarily perform better than hive llap. Replied Message | From | Albert Wong | | Date | 10/24/2023 01:39 | | To | user@hive.apache.org | | Cc | | | Subject | Re: Hive's performance

Re: Re: Hive's performance for querying the Iceberg table is very poor.

2023-10-24 Thread Ayush Saxena
tarrocks does >>> not necessarily perform better than hive llap. >>> >>> >>> Replied Message >>> From Albert Wong >>> Date 10/24/2023 01:39 >>> To user@hive.apache.org >>> Cc >>> Subject Re: Hive's perfor

Re: Hive's performance for querying the Iceberg table is very poor.

2023-10-23 Thread Ayush Saxena
Message >> From Albert Wong >> Date 10/24/2023 01:39 >> To user@hive.apache.org >> Cc >> Subject Re: Hive's performance for querying the Iceberg table is very >> poor. >> I would try http://starrocks.io. StarRocks is an MPP OLAP database &

Re: Hive's performance for querying the Iceberg table is very poor.

2023-10-23 Thread Albert Wong
cks. > mpp architecture databases have natural limitations, and starrocks does > not necessarily perform better than hive llap. > > > Replied Message > From Albert Wong > Date 10/24/2023 01:39 > To user@hive.apache.org > Cc > Subject Re: Hive's performance

Re: Hive's performance for querying the Iceberg table is very poor.

2023-10-23 Thread lisoda
x27;s performance for querying the Iceberg table is very poor. | I would try http://starrocks.io. StarRocks is an MPP OLAP database that can query Apache Iceberg and we can cache the data for faster performance. We also have additional features like building materialized views that span a

Re: Hive's performance for querying the Iceberg table is very poor.

2023-10-23 Thread Albert Wong
I would try http://starrocks.io. StarRocks is an MPP OLAP database that can query Apache Iceberg and we can cache the data for faster performance. We also have additional features like building materialized views that span across Apache Iceberg, Apache Hudi and Apache Hive. Here is a video of c