Presto: Can not add partitions for existing data to external table in presto ?

[qli-aa]

Presto-0.206

1.CREATE table with partitioned_by, then insert data, queries partitions works

2.CREATE table with external_location and partitioned_by (map to existing data with partitions), then queries partitions does not work, I checked the hive metastore, there is no partitions meta for external table. How can I add it automatically or manually ?

Like HiveSQL, ALTER TABLE ADD PARTITION (p='xxx') LOCATION 'xxx';

[dain]

There is no equivalent of that in Presto yet. We could add a stored procedure for to add partitions (this would be similar to the procedure for creating new empty partitions https://github.com/prestodb/presto/blob/master/presto-hive/src/main/java/com/facebook/presto/hive/CreateEmptyPartitionProcedure.java)

[ddrinka]

This would be super helpful for us. We're using Athena to create our partitions in AWS Glue, but it introduces race conditions with the metastore cache. It would be really great to have this functionality in Presto directly.

[ddrinka]

Also see #11174

[dain]

Presto doesn't have a metastore cache enabled by default anymore, so there shouldn't be any problems on our side. That said, I agree we should have a way to do this in Presto directly.

[stale[bot]]

This issue has been automatically marked as stale because it has not had any activity in the last 2 years. If you feel that this issue is important, just comment and the stale tag will be removed; otherwise it will be closed in 7 days. This is an attempt to ensure that our open issues remain valuable and relevant so that we can keep track of what needs to be done and prioritize the right things.