gpudb::ColumnProperty - Kinetica Docs

Variables
const std::string	DATA
	Default property for all numeric and string type columns; makes the column available for GPU queries.

const std::string	TEXT_SEARCH
	Valid only for select ‘string’ columns.

const std::string	TIMESTAMP
	Valid only for ‘long’ columns.

const std::string	ULONG
	Valid only for ‘string’ columns.

const std::string	UUID
	Valid only for ‘string’ columns.

const std::string	DECIMAL
	Valid only for ‘string’ columns.

const std::string	DATE
	Valid only for ‘string’ columns.

const std::string	TIME
	Valid only for ‘string’ columns.

const std::string	DATETIME
	Valid only for ‘string’ columns.

const std::string	CHAR1
	This property provides optimized memory, disk and query performance for string columns.

const std::string	CHAR2
	This property provides optimized memory, disk and query performance for string columns.

const std::string	CHAR4
	This property provides optimized memory, disk and query performance for string columns.

const std::string	CHAR8
	This property provides optimized memory, disk and query performance for string columns.

const std::string	CHAR16
	This property provides optimized memory, disk and query performance for string columns.

const std::string	CHAR32
	This property provides optimized memory, disk and query performance for string columns.

const std::string	CHAR64
	This property provides optimized memory, disk and query performance for string columns.

const std::string	CHAR128
	This property provides optimized memory, disk and query performance for string columns.

const std::string	CHAR256
	This property provides optimized memory, disk and query performance for string columns.

const std::string	BOOLEAN
	This property provides optimized memory and query performance for int columns.

const std::string	INT8
	This property provides optimized memory and query performance for int columns.

const std::string	INT16
	This property provides optimized memory and query performance for int columns.

const std::string	IPV4
	This property provides optimized memory, disk and query performance for string columns representing IPv4 addresses (i.e. 192.168.1.1).

const std::string	ARRAY
	Valid only for ‘string’ columns.

const std::string	JSON
	Valid only for ‘string’ columns.

const std::string	VECTOR
	Valid only for ‘bytes’ columns.

const std::string	WKT
	Valid only for ‘string’ and ‘bytes’ columns.

const std::string	PRIMARY_KEY
	This property indicates that this column will be part of (or the entire) primary key.

const std::string	SOFT_PRIMARY_KEY
	This property indicates that this column will be part of (or the entire) soft primary key.

const std::string	SHARD_KEY
	This property indicates that this column will be part of (or the entire) shard key.

const std::string	NULLABLE
	This property indicates that this column is nullable.

const std::string	COMPRESS
	This property indicates that this column should be compressed with the given codec and optional level; e.g., ‘compress(snappy)’ for Snappy compression and ‘compress(zstd(7))’ for zstd level 7 compression.

const std::string	DICT
	This property indicates that this column should be dictionary encoded.

const std::string	INIT_WITH_NOW
	For ‘date’, ‘time’, ‘datetime’, or ‘timestamp’ column types, replace empty strings and invalid timestamps with ‘NOW()’ upon insert.

const std::string	INIT_WITH_UUID
	For ‘uuid’ type, replace empty strings and invalid UUID values with randomly-generated UUIDs upon insert.

const std::string	UPDATE_WITH_NOW
	For ‘date’, ‘time’, ‘datetime’, or ‘timestamp’ column types, update the field with ‘NOW()’ upon any update.

const std::string	UPDATE_WITH_USER
	For ‘charN’ or ‘string’ column types, update the field with the current user’s name upon any update.

const std::string	DEFAULT
	Sets a default value expression for this column, e.g. ‘default(0)’, ‘default(”pending”)’, or ‘default(NOW())’.

const std::string	DEFAULT_SQL
	Sets a default value expression for this column with SQL syntax, e.g. ‘default(0)’, ‘default(”pending”)’, or ‘default(NOW())’.

Variable Documentation

◆ ARRAY

const std::string gpudb::ColumnProperty::ARRAY

extern

Valid only for ‘string’ columns.

Indicates that this field contains an array. The value type and (optionally) the item count should be specified in parenthesis; e.g., ‘array(int, 10)’ for a 10-integer array. Both ‘array(int)’ and ‘array(int, -1)’ will designate an unlimited-length integer array, though no bounds checking is performed on arrays of any length.

◆ BOOLEAN

const std::string gpudb::ColumnProperty::BOOLEAN

extern

This property provides optimized memory and query performance for int columns.

Ints with this property must be between 0 and 1(inclusive)