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

Instead of creating on the fly an Iceberg table with Trino and run queries against it, use static resources for setting up an Iceberg test environment which can be used to read Iceberg v1 / v2 tables and guard trino-iceberg plugin against regresssions.

Related discussion: trinodb/trino#11642 (comment)

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