... | ... | @@ -46,4 +46,6 @@ A table can be erased with the command: `DROP TABLE "mtcarouge"."etdevice"` |
|
|
|
|
|
A table can be created like this: `CREATE TABLE "mtcarouge"."etwaterqualityobserved" (entity_id string, entity_type STRING);`
|
|
|
|
|
|
If the error `crate.client.exceptions.ProgrammingError: SQLActionException[ClusterBlockException: blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];]` appears, use the following command: `ALTER TABLE <tablename> SET ("blocks.read_only_allow_delete" = FALSE);` |
|
|
\ No newline at end of file |
|
|
If the error `crate.client.exceptions.ProgrammingError: SQLActionException[ClusterBlockException: blocked by: [FORBIDDEN/12/index read-only / allow delete (api)];]` appears, use the following command: `ALTER TABLE <tablename> SET ("blocks.read_only_allow_delete" = FALSE);`
|
|
|
|
|
|
You can inspect the Docker volume with the command: `docker volume inspect naiades-platform-poc_crate-storage` (Reference:[https://docs.docker.com/engine/reference/commandline/volume_inspect/](https://docs.docker.com/engine/reference/commandline/volume_inspect/)) |
|
|
\ No newline at end of file |