Limit

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

• solution (preview): Coordinated Commits 支持多表和多语句transaction

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
  • Solution: Type Widening 解决 Changing a column’s type requires rewriting 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