System.create_empty_partition

Trino
1

We are creating a partitioned table with s3 as external_location.
table location has many partition folders already created.
hive allows us to add selected partitions using
ALTER TABLE my_table ADD
PARTITION (partkey=keyval1)
PARTITION (partkey=keyval2)
PARTITION (partkey=keyval3)

similar to this how can I use create_empty_partition to add multiple partitions ?
we are able to use this for one partition using
call system.create_empty_partition('myschema, ‘my_table’, ‘partkey’, ‘keyval1’)
we are not using call system.sync_partition_metadata as it takes time to sync all partitions when the list of partitions is too big and for the use case we are not interested in all partitions .

looking for ways to do this for multiple partitions.
Appreciate any pointers.

2

There is no direct way to do this in one query. But you can easily write a little script that uses the Trino CLI and submits these calls one after the other.

A separate question I have would be … why do you even want to create those empty partitions. They will be automatically created when relevant data is inserted.