CREATE BLOB TABLE
¶
Create a new table for storing Binary Large OBjects (BLOBS).
Table of contents
Synopsis¶
CREATE BLOB TABLE table_name
[CUSTERED [ BY (routing_column) ] 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.
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.