Skip to main content
← User Stories
Apache Doris · Global

Querying Fluss tables directly with SQL

The Fluss Catalog in Doris 5.0 connects SQL analytics to Fluss log and primary-key tables, including union reads over Fluss and Paimon.

About Apache Doris

Apache Doris is an open-source analytical database for real-time reporting, interactive SQL analytics, and data warehousing.

SQL access to streaming tables

The Fluss Catalog in Doris 5.0 exposes Fluss log and primary-key tables to SQL clients and BI tools without an intermediate ETL job. For primary-key tables, Doris combines snapshots with subsequent changes to return the latest state of each key.

Combining lake history with fresh updates

For tables tiered into Paimon, a union read combines historical lake data with the newer records still in Fluss. Doris scans lake files through its native readers and reads the remaining log tail through the Fluss client, preserving a unified view of the table.

Bringing Fluss into federated analytics

Queries can join Fluss tables with Doris internal tables or other catalogs, including Hive, Iceberg, Paimon, and JDBC sources. Column and partition pruning reduce unnecessary reads, while query profiles expose which read paths were used.

Further reading

Explore more user stories →