KineticaColumnProperties

Marks this column as a primary key

Marks this column as a shard key

Marks this column as nullable

Marks this column as a timestamp

Marks this column as data (generic data property)

Marks this column as storing an IPv4 address

Marks this column as storing a WKT geometry

Marks this column with char(N) type: charN, for N of 1, 2, 4, 8, 16, 32, 64, 128 or 256. The server refuses another size when the type is created (“Unknown property: char3”).

Marks this column as int8 (1 byte signed integer)

Marks this column as int16 (2 byte signed integer)

Marks this column as a date

Marks this column as a time

Marks this column as a datetime

Marks this column as a decimal (SQL NUMERIC(19,4), the server default)

Marks this column as a decimal with the given precision and scale, i.e. decimal(P,S)

Written with no space after the comma: the form (decimal\((\d+),(\d+)\)) from which precision and scale are read back out of a type’s properties.

Marks this column as storing a UUID

Marks this column as an unsigned long (0 to 18446744073709551615)

Marks this column as a boolean (stored as int with 0/1 values)

Enables full text search on this (string) column

Marks this (string) column as holding JSON values

Marks this (string) column as an unbounded array of item_type (e.g. “int”, “long”, “double”, “string”), i.e. array(item_type)

Marks this (string) column as an array of item_type holding at most len items, i.e. array(item_type, len); a len of -1 means unbounded

Marks this (bytes) column as a vector of dimensions floats, i.e. vector(dimensions)

Marks this column as part of (or all of) the soft primary key

Compresses this column with the given codec and optional level, i.e. compress(codec); pass e.g. “snappy” or “zstd(7)“

Dictionary-encodes this column (charN, int, long or date columns)

Replaces empty or invalid date/time/datetime/timestamp values with NOW() on insert

Replaces empty or invalid UUID values with a random UUID on insert

Sets this date/time/datetime/timestamp column to NOW() on any update

Sets this charN or string column to the current user’s name on any update

Sets a default value expression, i.e. default(expr); pass e.g. “0”, “‘pending’” or “NOW()“

Sets the SQL-syntax default expression shown in generated DDL, i.e. default_sql(expr)

The parenthesised form here follows default(expr). Use property if a server expects something else.

Adds a custom property

Converts to the vector format expected by Kinetica