[I] [PERFORMANCE] Presto read Paimon Table very slow [incubator-paimon-presto]

["lfyzjck (via GitHub)" <gi...@apache.org>]

lfyzjck opened a new issue, #15:
URL: https://github.com/apache/incubator-paimon-presto/issues/15

   reproduce:
   
   A cdc table 
   
   ```sql
   > select * from paimon_table where id = ? limit 1;
   
   Query 20231115_063347_02385_ga6ya, FINISHED, 33 nodes
   Splits: 49 total, 49 done (100.00%)
   [Latency: client-side: 4:48, server-side: 4:48] [0 rows, 0B] [0 rows/s, 0B/s]
   ```
   
   we expected the query finished in 1s but actual we spent about 2 mins. Since parquet/orc footer already contains min/max stats about `id`, we only need read at most 1 compacted file.
   
   flamegraph:
   
   <img width="1500" alt="image" src="https://github.com/apache/incubator-paimon-presto/assets/800042/13f8279c-9c49-4ec5-8d31-73ec2713a59d">
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@paimon.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org