Nested Parquet data?

This question was originally asked on Hacker News, and to provide this information to the PartiQL community, I am duplicating it here, lightly edited.

Question

I wonder how this deals with nested parquet data, and whether it’s able to optimise on the things parquet provides.

Answer 1

It would be possible to integrate parquet data with PartiQL.

Here is an example of integrating PartiQL with CSV files. https://github.com/partiql/partiql-lang-kotlin/blob/master/examples/src/java/org/partiql/examples/CSVJavaExample.java#L36.. Integrating with Parquet would of course be more complex then that.

Answer 2

AWS Redshift Spectrum supports PartiQL on parquet since last year. Except that the language had not had a name yet and was referred to as “SQL extensions for nested data.”

Source: original comment and answers on HN