Drop Field

Remove a field from a table.

For most tables, dropping a field is safe to read afterward — Magpie just stops selecting that column. The exception is a table whose persistence mapping is a SQL query (create table ... from sql(...)), or a generic Spark source that determines its own schema (usesSchema: false). For those two mapping types, Magpie validates the query or connector's actual output schema against the table's declared schema on every read — so if the dropped field is still produced by the underlying query or connector, the next read fails with a schema-mismatch error instead of succeeding.

Syntax

alter table <table reference> drop field [if exists] <field name>

Parameters

table reference

String — Name of the table to remove a field from, optionally qualified by schema.

field name

String — Name of the field to remove.

Options

if exists

Do not raise an error if field name does not already exist on the table.