What DDL and DML features does Delta Lake not supp... - Databricks Community - 24444

Register to join the community

Data Engineering

Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.

What DDL and DML features does Delta Lake not support?

1 REPLY 1

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

Unsupported DML features:
INSERT INTO [OVERWRITE]
- table with static partitions
INSERT OVERWRITE TABLE
- for table with dynamic partitions
Specifying target partitions using
PARTITION (part_spec)

never-displayed

You must be signed in to add attachments

never-displayed

Announcements

Databricks Learning Festival (Virtual): 10 October - 31 October

Databricks Hybrid Learning Day - New York City

Databricks Migration Strategy: Lessons Learned

What’s New With Databricks Assistant?

Introducing Simple, Fast, and Scalable Batch LLM Inference on Mosaic AI Model Serving