nwong
New Contributor II

‎02-03-2025 04:12 PM

I just tried manually adding a partition

 

ALTER TABLE prod.reporting.send_date_summary
ADD PARTITION (year = 2022, month=12, day=05)
LOCATION 's3://bucket_name/send_date_summary/report/2022/12/05/';
 
and got an error 
[UC_COMMAND_NOT_SUPPORTED.WITHOUT_RECOMMENDATION] The command(s): ALTER TABLE (add partition) are not supported in Unity Catalog. SQLSTATE: 0AKUC
 
and I can't use MSCK REPAIR TABLE because the folders are not in Hive-style partitioning.