Limit

Delta Lake does not support multi-table transactions and foreign keys.

Unsupported DDL features:

• ANALYZE TABLE PARTITION
• ALTER TABLE [ADD|DROP] PARTITION
• ALTER TABLE RECOVER PARTITIONS
• ALTER TABLE SET SERDEPROPERTIES
• CREATE TABLE LIKE
• INSERT OVERWRITE DIRECTORY
• LOAD DATA
• Changing a column’s type or dropping a column requires rewriting the table

Unsupported DML features:

• INSERT INTO [OVERWRITE] table with static partitions
• INSERT OVERWRITE TABLE for table with dynamic partitions
• Bucketing
• Specifying a schema when reading from a table
• Specifying target partitions using PARTITION (part_spec) in TRUNCATE TABLE