search

chdb-io / chdb

chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse
https://clickhouse.com/chdb
Apache License 2.0
2.13k stars 75 forks source link

Feature Request: Iceberg Table Format support #119

Closed rakeshJn closed 1 year ago

rakeshJn commented 1 year ago

In Clickhouse, I can query an Iceberg table with a query like this: select * from iceberg('https://s3.us-east.cloud-object-storage.appdomain.cloud/lake-sales/tables/sales’, ‘aws_key####’, ‘aws_secret####’, Parquet) limit 2000

However, when I try the exact same query on chDB, I get this error:

Code: 46. DB::Exception: Unknown table function Iceberg: or incorrect parameterized view. (UNKNOWN_FUNCTION)

Seems like chDB doesn't know iceberg table function. P.S, I tried Iceberg also (uppercase 'I'), that doesn't work either.

lmangani commented 1 year ago

You can see all the supported functions with SELECT * FROM system.table_functions ORDER BY name or here

Iceberg support is indeed not currently compiled into chdb. From what I can see the avro dependency must be enabled. We'll sure add the dependencies to support the Iceberg table function in the next releases.

lmangani commented 1 year ago

Implemented in v0.15.0

rakeshJn commented 1 year ago

Thanks!