Column properties used for Kinetica types. More...

Static Public Attributes
const string	DATA = "data"
	Default property for all numeric and string type columns; makes the column available for GPU queries.

const string	TEXT\_SEARCH = "text\_search"
	Valid only for select 'string' columns.

const string	TIMESTAMP = "timestamp"
	Valid only for 'long' columns.

const string	ULONG = "ulong"
	Valid only for 'string' columns.

const string	UUID = "uuid"
	Valid only for 'string' columns.

const string	DECIMAL = "decimal"
	Valid only for 'string' columns.

const string	DATE = "date"
	Valid only for 'string' columns.

const string	TIME = "time"
	Valid only for 'string' columns.

const string	DATETIME = "datetime"
	Valid only for 'string' columns.

const string	CHAR1 = "char1"
	This property provides optimized memory, disk and query performance for string columns.

const string	CHAR2 = "char2"
	This property provides optimized memory, disk and query performance for string columns.

const string	CHAR4 = "char4"
	This property provides optimized memory, disk and query performance for string columns.

const string	CHAR8 = "char8"
	This property provides optimized memory, disk and query performance for string columns.

const string	CHAR16 = "char16"
	This property provides optimized memory, disk and query performance for string columns.

const string	CHAR32 = "char32"
	This property provides optimized memory, disk and query performance for string columns.

const string	CHAR64 = "char64"
	This property provides optimized memory, disk and query performance for string columns.

const string	CHAR128 = "char128"
	This property provides optimized memory, disk and query performance for string columns.

const string	CHAR256 = "char256"
	This property provides optimized memory, disk and query performance for string columns.

const string	BOOLEAN = "boolean"
	This property provides optimized memory and query performance for int columns.

const string	INT8 = "int8"
	This property provides optimized memory and query performance for int columns.

const string	INT16 = "int16"
	This property provides optimized memory and query performance for int columns.

const string	IPV4 = "ipv4"
	This property provides optimized memory, disk and query performance for string columns representing IPv4 addresses (i.e.

const string	ARRAY = "array"
	Valid only for 'string' columns.

const string	JSON = "json"
	Valid only for 'string' columns.

const string	VECTOR = "vector"
	Valid only for 'bytes' columns.

const string	WKT = "wkt"
	Valid only for 'string' and 'bytes' columns.

const string	PRIMARY\_KEY = "primary\_key"
	This property indicates that this column will be part of (or the entire) primary key.

const string	SOFT\_PRIMARY\_KEY = "soft\_primary\_key"
	This property indicates that this column will be part of (or the entire) soft primary key.

const string	SHARD\_KEY = "shard\_key"
	This property indicates that this column will be part of (or the entire) shard key.

const string	NULLABLE = "nullable"
	This property indicates that this column is nullable.

const string	COMPRESS = "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 string	DICT = "dict"
	This property indicates that this column should be dictionary encoded.

const string	INIT\_WITH\_NOW = "init\_with\_now"
	For 'date', 'time', 'datetime', or 'timestamp' column types, replace empty strings and invalid timestamps with 'NOW()' upon insert.

const string	INIT\_WITH\_UUID = "init\_with\_uuid"
	For 'uuid' type, replace empty strings and invalid UUID values with randomly-generated UUIDs upon insert.

const string	UPDATE\_WITH\_NOW = "update\_with\_now"
	For 'date', 'time', 'datetime', or 'timestamp' column types, update the field with 'NOW()' upon any update.

const string	UPDATE\_WITH\_USER = "update\_with\_user"
	For 'charN' or 'string' column types, update the field with the current user's name upon any update.

const string	DEFAULT = "default"
	Sets a default value expression for this column, e.g.

const string	DEFAULT\_SQL = "default\_sql"
	Sets a default value expression for this column with SQL syntax, e.g.

Detailed Description

Column properties used for Kinetica types.

Definition at line 10 of file ColumnProperty.cs.

Member Data Documentation

◆ ARRAY

const string kinetica.ColumnProperty.ARRAY = "array"

static

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.

Definition at line 159 of file ColumnProperty.cs.

◆ BOOLEAN

const string kinetica.ColumnProperty.BOOLEAN = "boolean"

static

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

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

Definition at line 131 of file ColumnProperty.cs.