Skip to main content Link Menu Expand (external link) Document Search Copy Copied

STRING data type

DDL Syntax

STRING

Arguments

Argument Description
STRING Used for STRING, CHAR and VARCHAR data.

Additional information

The STRING data type:

  • has a keyed mutex internal data type
  • works best when:
    • Looking for discrete values,
    • group by where cardinality is low

Use single quotes to contain string values in INSERT, REPLACE or SELECT statements.

If data has high cardinality:

  • performance can decrease
  • storage will increase

Examples

CREATE products and sales tables and columns with string datatypes

create table products
  (_id id, prodlist string, price decimal(2) stock int);
create table services
  (_id id, servicelist string, price decimal(2));

SELECT FROM string column

SELECT * FROM products WHERE prodlist LIKE '%pen%';

CREATE TABLE with all data types

create table allcoltypes
  (
    _id id,
    intcol int min 0 max 10000,
    boolcol bool,
    timestampcol timestamp timeunit 'ms',
    decimalcol decimal(2),
    stringcol string,
    stringsetcol stringset,
    stringsetcolq stringsetq timequantum 'YMD' ttl '24h',
    idcol id,
    idsetcol idset,
    idsetcolq idsetq timequantum 'YMD' ttl '24h'
  )
  comment 'table containing all column types';