Support views (CREATE VIEW) in Iceberg connector

[esemeniuc]

Hi all, when using iceberg catalog and creating a view, I see this:

presto:partition_demo_iceberg> create OR REPLACE view sfms_cpustats as (SELECT * FROM sfms_cpustats_daily);
Query 20210607_203635_03250_hfqhn failed: This connector does not support creating views

I noticed this line about view support:

trino/plugin/trino-iceberg/src/main/java/io/trino/plugin/iceberg/IcebergMetadata.java

Line 1035 in e4cae79

// Iceberg does not support VIEWs

Can view support be added, or is there a fundamental issue with views and iceberg?

[raunaqmorarka]

You can simply use MATERIALIZED VIEW. It behaves like a VIEW if you don't run REFRESH MATERIALIZED VIEW query on it.
@electrum might have more thoughts about explicit support of VIEW in iceberg.

[findepi]

You can simply use MATERIALIZED VIEW. It behaves like a VIEW if you don't run REFRESH MATERIALIZED VIEW query on it.

nice workaround, thanks @raunaqmorarka for sharing.

Another workaround is to define a view via Hive connector, but reference Iceberg catalog in the view body. Not as useful, but may be helpful in some cases.

We should just add support for views ("trino views") in Iceberg. This is pretty straightforward, and Hive connector can be used as an example.

[gorthitk]

@findepi : Its been a while since I contributed, may I help with adding the support for views ?

[findepi]

@jetsasank sure!

[gorthitk]

Great, I will assign this issue to myself and start working on a solution.

[losipiuk]

Hi @jetsasank are you still working on this issue? I wanted to dig into that, but if you have in flight it would be great to not duplicate work.

[ebyhr]

Closing as #8540