CrateDB drop column not working and throwing an error

CrateDB
1

Hello 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?

2

Hi @arafaraf

CrateDB currently does not support dropping columns from a table.

Also see:

3

Just read through the docs. Thank you for your answer.