presto

Describe the bug
Using a time dimension on a runningTotal measure on Snowflake mixes quoted and unquoted columns in the query. This fails the query, because Snowflake has specific rules about quoted columns. Specifically:

• All unquoted column names are treated as upper case
• Quoted column names are case sensitive.

So "date_from" <> date_from

To Reproduce
Steps to reproduce

Syntax for changing Iceberg table properties

ALTER TABLE an-iceberg-table SET PROPERTIES a-property-name = 'a-value'

Implementation tips

Implement the method io.trino.spi.connector.ConnectorMetadata#setTableProperties in io.trino.plugin.iceberg.IcebergMetadata.

Use org.apache.iceberg.BaseTable#updateProperties for updating table properties.

Test tips

Add

1 issue description
2. fix bug, enhance....
3. git commit -m "issue name (#issue number)"

It would be great to do a somewhat rigorous analysis of whether there are performance issues when query is written in Logica vs SQL.

As a user i would like a command to aid in debugging parquet files. For instance I would like to obtain the following file stats in a single command:

• compression algorithm
• page type v1/v2?
• row group size
• author / created by
• version
• metadata
• page size
• total records /row count
• any internal info that could help too