Skip to main content

Compatibility with Query Engines

You can query OLake Iceberg tables from multiple engines. The table below shows catalog compatibility at a glance, with links to setup guides.

Query ToolAWS GlueHive MetastoreJDBCRESTDocs
Amazon Athenaβœ…βŒβŒβŒAWS Docs
Apache Spark (v3.3+)βœ…βœ…βœ…βœ…Spark Docs
Apache Flink (v1.18+)βœ…βœ…βœ…βœ…Flink Docs
Trino (v475 +)βœ…βœ…βœ…βœ…Trino Docs
Starburst Enterpriseβœ…βœ…βœ…βœ…Starburst Docs
Presto (v0.288 +)βœ…βœ…βœ…βœ…Presto Guide
Apache Hive (v4.0)βœ…βœ…βŒβœ…Hive Docs
Apache Impala (v4.4)βŒβœ…βŒβŒImpala Docs
Dremio (v25/26)βœ…βœ…βŒβœ…Dremio Docs
DuckDB (v1.2.1)βŒβŒβŒβœ…DuckDB Docs
ClickHouse (v24.3 +)βŒβŒβŒβœ…ClickHouse Docs
StarRocks (v3.2 +)βŒβœ…βŒβœ…StarRocks Docs
Apache Doris (v2.1 +)βœ…βœ…βŒβœ…Doris Docs
BigQuery (BigLake)❌❌❌❌BigQuery Docs
Snowflake (GA)βŒβŒβŒβœ…Snowflake Docs
Databricks (Unity)βŒβŒβŒβœ…Databricks Docs

Important Notes​

  • Amazon Athena β†’ Supports Iceberg v2 tables only when registered in Glue.
  • Presto β†’ REST catalog supported from v0.288+; Glue requires the AWS SDK fat-jar.
  • Apache Hive v4.0 β†’ Glue requires adding the AWS bundle.
  • Impala β†’ Works with Hive Metastore; Glue/REST only via Hive federation.
  • Dremio β†’ Supports Polaris/REST/Nessie natively; JDBC not supported.
  • DuckDB β†’ Supports REST catalogs (Nessie, Tabular); Glue/Hive not yet supported.
  • ClickHouse β†’ Iceberg tables are read-only; REST support stable from v24.12+.
  • BigQuery β†’ Reads Iceberg manifests directly, without a catalog.
  • Snowflake β†’ Can read external REST catalogs, but they are read-only.
  • Databricks Unity Catalog β†’ REST endpoint allows federation with Glue, Hive, and Snowflake catalogs.


πŸ’‘ Join the OLake Community!

Got questions, ideas, or just want to connect with other data engineers?
πŸ‘‰ Join our Slack Community to get real-time support, share feedback, and shape the future of OLake together. πŸš€

Your success with OLake is our priority. Don’t hesitate to contact us if you need any help or further clarification!