Skip to content
AI News HubLIVE
More
Summary only

Benchmark demonstrates 5-37x improved performance for query on Iceberg tables

StarTree's benchmark shows that using Apache Pinot with Iceberg tables delivers 5-37x faster query performance and up to 15x lower costs compared to Trino and ClickHouse OSS on the same 12.2 billion row dataset stored in Parquet on S3. Pinot's purpose-built indexes allow sub-second queries while other systems take seconds to tens of seconds.

SourceHacker News AIAuthor: dashdoesdata
Benchmark demonstrates 5-37x improved performance for query on Iceberg tables
Report an error

The correction channel is not available yet. You can copy the article reference below for later.

Correction instructions

Summary only

Under the source content permission, this page provides an editorial summary, key points, and a link to the original article.

Key points and analysis

Article intelligence

EngineersAdvanced

Key points

  • Pinot was 9-39x faster than ClickHouse and 4-21x faster than Trino without caching.
  • With caching, Pinot maintained 5-37x and 4-17x speed advantages.
  • Cost per query: $0.0012 for Pinot vs $0.009 for Trino and $0.018 for ClickHouse.
  • Pinot achieves sub-650ms latency on all queries using index pinning.

Highlights and analysis are generated automatically and may contain errors. Check the original source.

More recent stories on this topic · Research

Benchmark demonstrates 5-37x improved performance for query on Iceberg tables | AI News Hub