Delta Table: Drop column failure
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2022 10:41 AM
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