alesapin-workstation :) set optimize_trivial_count_query=0                                                                                                                                                                                                    
                                                                                                                                                                                                                                                              
SET optimize_trivial_count_query = 0                                                                                                                                                                                                                          
                                                                                                                                                                                                                                                              
Query id: 0a170f59-66ef-4805-9a1e-ad5241de2bd4                                                                                                                                                                                                                
                                                                                                                                                                                                                                                              
Ok.                                                                                                                                                                                                                                                           
                                                                                                                                                                                                                                                              
0 rows in set. Elapsed: 0.001 sec.                                                                                                                                                                                                                            

alesapin-workstation :) select count() from test.`iceberg-benchmark.hitsiceberg`                                                                                                                                                                              
                                                                                                                                                                                                                                                              
SELECT count()                                                                                                                                                                                                                                                
FROM test.`iceberg-benchmark.hitsiceberg`                                                                                                                                                                                                                     
                                                                                                                                                                                                                                                              
Query id: ac327a15-953f-4d79-b1a9-d42b8f3c9e12                                                                                                                                                                                                                
                                                                                                                                                                                                                                                              
   ┌──count()─┐                                                                                                                                                                                                                                               
1. │ 99997497 │ -- 100.00 million                                                                                                                                                                                                                             
   └──────────┘                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                              
1 row in set. Elapsed: 7.964 sec. Processed 100.00 million rows, 10.01 GB (12.56 million rows/s., 1.26 GB/s.)                                                                                                                                                 
Peak memory usage: 38.78 MiB.                                                                                                                                                                                                                                 

alesapin-workstation :) set optimize_trivial_count_query=1      

SET optimize_trivial_count_query = 1

Query id: 9b079198-188d-47a1-98f7-edaa71c5a25d

Ok.

0 rows in set. Elapsed: 0.001 sec. 

alesapin-workstation :) select count() from test.`iceberg-benchmark.hitsiceberg`

SELECT count()
FROM test.`iceberg-benchmark.hitsiceberg`

Query id: 4a5e6911-ed94-48bb-8b00-829614ce22df

   ┌──count()─┐
1. │ 99997497 │ -- 100.00 million
   └──────────┘

1 row in set. Elapsed: 1.839 sec.