DROP TABLE "blob"."mytable"
DROP BLOB TABLE "blob"."mytable"
Also tried modifying settings:
ALTER TABLE "blob"."document" SET ("blocks.read_only_allow_delete" = FALSE)
ALTER BLOB TABLE "blob"."document" SET ("blocks.read_only_allow_delete" = FALSE)
But get errors:
SQLActionException[OperationOnInaccessibleRelationException: The relation "blob.mytable" doesn't support or allow ALTER operations.]
SQLActionException[SQLParseException: Invalid property "blocks.read_only_allow_delete" passed to [ALTER | CREATE] TABLE statement]
I would like to update a cluster to the latest release (from 4.2.6) but Crate warns me that a BLOB table needs to be recreated (and I cannot drop it…). Will this be an issue if an update is attempted ?
@rps-v Can you share the warning you see regarding BLOB tables needs to be recreated?
We believe this warning is only relevant for major version upgrades (i.e. upgrading to 5.x) and upgrading to 4.7 or 4.8 should work fine. Before upgrading I recommend to create a backup just in case something does not work as expected.
Potentially it’s also worth first restoring this blob table and some sample data on a cloned testing system for a update test-run before updating your production system.