Can you share any example of creating an external table in trino with projection partition enabled.
When we tried running the following query it fails with
SQL Error [18]: Query failed (#): Catalog ‘hive’ table property ‘projection_partkey_format’ does not exist
CREATE TABLE hive.myschema.mytable(
c1 varchar(10)
,c2 int
,partkey int
)
WITH (
format = ‘parquet’,
external_location = ‘s3://my-bkt/my-table/’,
partitioned_by = ARRAY[‘partkey’],
projection_partkey_format=‘yyyyMMddHH’,
projection_partkey_interval=‘1’ ,
projection_partkey_interval_unit=‘HOURS’ ,
projection_partkey_range=‘NOW-13MONTHS,NOW+1DAY’,
projection_partkey_type=‘date’,
projection_enabled=‘true’
)