3.3

CREATE BLOB TABLE

Define a new table for storing binary large objects.

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. For details and examples see Blobs.

The CLUSTERED and WITH clauses follow the same semantics described under CLUSTERED and WITH.

Additional to the storage parameter described at WITH, following parameters are supported here:

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.