CREATE BLOB TABLE

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

Table of contents

• Synopsis

• Description

• Clauses

  • CLUSTERED

  • WITH

    • blobs_path

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

BLOB support

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.