How to add partition in presto?

@herminia_bruen 

To add a new partition in Presto, you can use the following SQL statement:

1

ALTER TABLE table_name ADD PARTITION (partition_column = 'partition_value');

Replace table_name with the name of the table you want to add a partition to, partition_column with the name of the column you want to partition by, and partition_value with the value of the new partition.

For example, if you have a table named employees and you want to add a new partition for employees in the sales department, you can use the following SQL statement:

1

ALTER TABLE employees ADD PARTITION (department = 'sales');

After executing this SQL statement, the new partition will be added to the table in Presto.