CREATE BLOB TABLE

Create a new table for storing Binary Large OBjects (BLOBS).

Table of contents

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

BLOB support

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.