Hey All,
I was reading the duck-db code and working with it IIUC iceberg views are not supported, It would be really nice if we can add iceberg views support for duckdb, presently the iceberg views are multi-dialect which means each engine can store the SQLQuery it in a dialect the engine understands and update and retrive it accordingly. https://iceberg.apache.org/view-spec/#iceberg-view-spec
Engine like Trino / Spark what they do is they call loadView Api which will return back all the view representation of the view and they selectively choose their own dialect and then plumb it to the view resolution framework engine already has, please ref here :
[1] Trino - https://github.com/trinodb/trino/blob/master/plugin/trino-iceberg/src/main/java/io/trino/plugin/iceberg/catalog/rest/TrinoRestCatalog.java#L688
[2] Spark - https://github.com/apache/iceberg/blob/main/spark/v4.0/spark/src/main/java/org/apache/iceberg/spark/source/SparkView.java#L62
and integrate it E2E. Would love to know if you have this planned already
Hey All,
I was reading the duck-db code and working with it IIUC iceberg views are not supported, It would be really nice if we can add iceberg views support for duckdb, presently the iceberg views are multi-dialect which means each engine can store the SQLQuery it in a dialect the engine understands and update and retrive it accordingly. https://iceberg.apache.org/view-spec/#iceberg-view-spec
Engine like Trino / Spark what they do is they call loadView Api which will return back all the view representation of the view and they selectively choose their own dialect and then plumb it to the view resolution framework engine already has, please ref here :
[1] Trino - https://github.com/trinodb/trino/blob/master/plugin/trino-iceberg/src/main/java/io/trino/plugin/iceberg/catalog/rest/TrinoRestCatalog.java#L688
[2] Spark - https://github.com/apache/iceberg/blob/main/spark/v4.0/spark/src/main/java/org/apache/iceberg/spark/source/SparkView.java#L62
and integrate it E2E. Would love to know if you have this planned already