Delta Table: Drop column failure

[auser85]

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

[Kaniz · Accepted solution]

Hi @Andrew Fogarty​, What runtime are you using?

You can drop one or more columns or fields in a Delta Lake table since DBR runtime 11.0.

[Kaniz]

Hi @Andrew Fogarty​​, We haven’t heard from you on the last response from me, and I was checking back to see if you have a resolution yet. If you have any solution, please share it with the community as it can be helpful to others. Otherwise, we will respond with more details and try to help.

[auser85]

Yes DBR 11.0 Beta allows that functionality!

[Kaniz]

Awesome!

Thank you for your update @Andrew Fogarty​!