Re: What DDL and DML features does Delta Lake not ... - 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

🚀 Announcing the Databricks Data Intelligence Platform Cheat Sheet

Find Sensitive Data at Scale with Data Classification in Unity Catalog

Solution Accelerator Series | #6 - Adverse Drug Event Detection

Announcing Backfill Runs in Lakeflow Jobs for Higher Quality Downstream Data

🚀 New: Databricks Interactive Architecture Design Workshops