CREATE BLOB TABLE¶
Create a new table for storing Binary Large OBjects (BLOBS).
Synopsis¶
CREATE BLOB TABLE table_name
[CLUSTERED INTO num_shards SHARDS]
[ WITH ( storage_parameter [= value] [, ... ] ) ]
Description¶
CREATE BLOB TABLE will create a new table for holding BLOBS.
See also
Clauses¶
CLUSTERED¶
Follows the same syntax as the CREATE TABLE … CLUSTERED clause, except for what concerns the definition of the sharding key which is not applicable as blob tables are always sharded by the blobs’ digests.
WITH¶
Follows the same syntax as the CREATE TABLE … WITH clause with the following additional parameter.
blobs_path¶
Specifies a custom path for storing blob data of a blob table.
- blobs_path:
The custom path for storing blob data as a string literal value or string parameter.
The path can be either absolute or relative and must be creatable/writable by the user CrateDB is running as. A relative path value is relative to CRATE_HOME. This path take precedence over any global configured value.