CODEWITHSUNDEEP
cratedb
The Coder
The Coder

Reputation: 343

CrateDB drop column not working and throwing an error

Hello stackoverflow so I have a cratedb database instance with about 3 million records in my table. I am trying to run the following command.

ALTER TABLE "transactions_v2" DROP COLUMN "itemPrices";

However I end up with this error

Error!

SQLParseException[line 1:62: mismatched input 'COLUMN' expecting {'.', 'PARTITION', 'DROP'}]

Any ideas why I can't seem to drop the column?

Upvotes: 0

Views: 176

Answers (1)

The Coder
The Coder

Reputation: 343

So cratedb does not support DROP COLUMN which is why I was getting the error.

Upvotes: 0

Related Questions