Delta Table: Drop column failure

auser85 — Wed, 08 Jun 2022 17:41:19 GMT

DBR 10.5, Spark 3.2.1

```

%sql

CREATE TABLE testing (

name string,

counter int

)

USING DELTA

OPTIONS (PATH "/mnt/general/testingtbl/")

```

%sql

insert into testing (name, counter) values ('a', 1)

```

%sql

ALTER TABLE testing SET TBLPROPERTIES (

'delta.minReaderVersion' = '2',

'delta.minWriterVersion' = '5',

'delta.columnMapping.mode' = 'name'

)

```

%sql alter table testing drop column counter

```

Returns this error: Unrecognized column change class org.apache.spark.sql.connector.catalog.TableChange$DeleteColumn. You may be running an out of date Delta Lake version

Re: Delta Table: Drop column failure

auser85 — Mon, 13 Jun 2022 12:23:49 GMT

Yes DBR 11.0 Beta allows that functionality!

topic Re: Delta Table: Drop column failure in Data Engineering

Delta Table: Drop column failure

Re: Delta Table: Drop column failure