A set of parameters for Kinetica.createType. More...

Inheritance diagram for kinetica.CreateTypeRequest:

Collaboration diagram for kinetica.CreateTypeRequest:

Classes
struct	Options
	A set of string constants for the parameter CreateTypeRequest.options. More...

struct	Properties
	A set of string constants for the parameter CreateTypeRequest.properties. More...

Public Member Functions
	CreateTypeRequest ()
	Constructs a CreateTypeRequest object with default parameters.

	CreateTypeRequest (string type\_definition, string label, IDictionary\< string, IList\< string > > properties=null, IDictionary\< string, string > options=null)
	Constructs a CreateTypeRequest object with the specified parameters.

	CreateTypeRequest ()
	Constructs a CreateTypeRequest object with default parameters.

	CreateTypeRequest (string type\_definition, string label, IDictionary\< string, IList\< string > > properties=null, IDictionary\< string, string > options=null)
	Constructs a CreateTypeRequest object with the specified parameters.

Public Member Functions inherited from kinetica.KineticaData
	KineticaData (KineticaType type)
	Constructor from Kinetica Type.

	KineticaData (System.Type type=null)
	Default constructor, with optional System.Type.

object	Get (int fieldPos)
	Retrieve a specific property from this object.

void	Put (int fieldPos, object fieldValue)
	Write a specific property to this object.

	KineticaData (KineticaType type)
	Constructor from Kinetica Type.

	KineticaData (System.Type type=null)
	Default constructor, with optional System.Type.

object	Get (int fieldPos)
	Retrieve a specific property from this object.

void	Put (int fieldPos, object fieldValue)
	Write a specific property to this object.

Properties
string	type\_definition `\[get, set]`
	JSON string defining the columns of the type to be registered, as described above.

string	label `\[get, set]`
	A user-defined description string which can be used to differentiate between tables and types with otherwise identical schemas.

IDictionary\< string, IList\< string > >	properties = new Dictionary\>() `\[get, set]`
	\[DEPRECATED–please use these property values in the CreateTypeRequest.type\_definition directly, as described at the top, instead] Each key-value pair specifies the properties to use for a given column where the key is the column name.

IDictionary\< string, string >	options = new Dictionary\() `\[get, set]`
	Optional parameters.

Properties inherited from kinetica.KineticaData
Schema	Schema `\[get]`
	Avro Schema for this class.

Additional Inherited Members
Static Public Member Functions inherited from kinetica.KineticaData
static ? RecordSchema	SchemaFromType (System.Type t, KineticaType? ktype=null)
	Create an Avro Schema from a System.Type and a KineticaType.

static ? RecordSchema	SchemaFromType (System.Type t, KineticaType? ktype=null)
	Create an Avro Schema from a System.Type and a KineticaType.

Detailed Description

A set of parameters for Kinetica.createType.

Creates a new type describing the columns of a table. The type definition is specified as a list of columns, each specified as a list of the column name, data type, and any column attributes.

Example of a type definition with some parameters:

\["id", "int8", "primary\_key"],

\["dept\_id", "int8", "primary\_key", "shard\_key"],

\["manager\_id", "int8", "nullable"],

\["first\_name", "char32"],

\["last\_name", "char64"],

\["salary", "decimal"],

\["hire\_date", "date"]

]

Each column definition consists of the column name (which should meet the standard column naming criteria), the column's specific type (int, long, float, double, string, bytes, or any of the possible values for CreateTypeRequest.properties), and any data handling, data key, or data replacement properties.

Note that some properties are mutually exclusive–i.e. they cannot be specified for any given column simultaneously. One example of mutually exclusive properties are PRIMARY\_KEY and NULLABLE.

A single primary key and/or single shard key can be set across one or more columns. If a primary key is specified, then a uniqueness constraint is enforced, in that only a single object can exist with a given primary key column value (or set of values for the key columns, if using a composite primary key). When inserting data into a table with a primary key, depending on the parameters in the request, incoming objects with primary key values that match existing objects will either overwrite (i.e. update) the existing object or will be skipped and not added into the set.

Definition at line 57 of file CreateType.cs.

Constructor & Destructor Documentation

◆ CreateTypeRequest() \[1/4]

kinetica.CreateTypeRequest.CreateTypeRequest

(

)

inline

Constructs a CreateTypeRequest object with default parameters.

Definition at line 712 of file CreateType.cs.

◆ CreateTypeRequest() \[2/4]

kinetica.CreateTypeRequest.CreateTypeRequest	(	string	type\_definition,
		string	label,
		IDictionary\< string, IList\< string > >	properties = null,
		IDictionary\< string, string >	options = null )

inline

Constructs a CreateTypeRequest object with the specified parameters.

Parameters

type\_definition	JSON string defining the columns of the type to be registered, as described above.
label	A user-defined description string which can be used to differentiate between tables and types with otherwise identical schemas.
properties	\[DEPRECATED–please use these property values in the type\_definition directly, as described at the top, instead] Each key-value pair specifies the properties to use for a given column where the key is the column name. All keys used must be relevant column names for the given table. Specifying any property overrides the default properties for that column (which is based on the column's data type). Valid values are: DATA: Default property for all numeric and string type columns; makes the column available for GPU queries. TEXT\_SEARCH: Valid only for select 'string' columns. Enables full text search–see Full Text Search for details and applicable string column types. TIMESTAMP: Valid only for 'long' columns. Indicates that this field represents a timestamp and will be provided in milliseconds since the Unix epoch: 00:00:00 Jan 1 1970. Dates represented by a timestamp must fall between the year 1000 and the year 2900. ULONG: Valid only for 'string' columns. It represents an unsigned long integer data type. The string can only be interpreted as an unsigned long data type with minimum value of zero, and maximum value of 18446744073709551615. UUID: Valid only for 'string' columns. It represents an uuid data type. Internally, it is stored as a 128-bit integer. DECIMAL: Valid only for 'string' columns. It represents a SQL type NUMERIC(19, 4) data type. There can be up to 15 digits before the decimal point and up to four digits in the fractional part. The value can be positive or negative (indicated by a minus sign at the beginning). This property is mutually exclusive with the TEXT\_SEARCH property. DATE: Valid only for 'string' columns. Indicates that this field represents a date and will be provided in the format 'YYYY-MM-DD'. The allowable range is 1000-01-01 through 2900-01-01. This property is mutually exclusive with the TEXT\_SEARCH property. TIME: Valid only for 'string' columns. Indicates that this field represents a time-of-day and will be provided in the format 'HH:MM:SS.mmm'. The allowable range is 00:00:00.000 through 23:59:59.999. This property is mutually exclusive with the TEXT\_SEARCH property. DATETIME: Valid only for 'string' columns. Indicates that this field represents a datetime and will be provided in the format 'YYYY-MM-DD HH:MM:SS.mmm'. The allowable range is 1000-01-01 00:00:00.000 through 2900-01-01 23:59:59.999. This property is mutually exclusive with the TEXT\_SEARCH property. CHAR1: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 1 character. CHAR2: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 2 characters. CHAR4: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 4 characters. CHAR8: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 8 characters. CHAR16: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 16 characters. CHAR32: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 32 characters. CHAR64: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 64 characters. CHAR128: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 128 characters. CHAR256: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 256 characters. BOOLEAN: This property provides optimized memory and query performance for int columns. Ints with this property must be between 0 and 1(inclusive) INT8: This property provides optimized memory and query performance for int columns. Ints with this property must be between -128 and +127 (inclusive) INT16: This property provides optimized memory and query performance for int columns. Ints with this property must be between -32768 and +32767 (inclusive) IPV4: This property provides optimized memory, disk and query performance for string columns representing IPv4 addresses (i.e. 192.168.1.1). Strings with this property must be of the form: A.B.C.D where A, B, C and D are in the range of 0-255. ARRAY: 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. JSON: Valid only for 'string' columns. Indicates that this field contains values in JSON format. VECTOR: Valid only for 'bytes' columns. Indicates that this field contains a vector of floats. The length should be specified in parenthesis, e.g., 'vector(1000)'. WKT: Valid only for 'string' and 'bytes' columns. Indicates that this field contains geospatial geometry objects in Well-Known Text (WKT) or Well-Known Binary (WKB) format. PRIMARY\_KEY: This property indicates that this column will be part of (or the entire) primary key. SOFT\_PRIMARY\_KEY: This property indicates that this column will be part of (or the entire) soft primary key. SHARD\_KEY: This property indicates that this column will be part of (or the entire) shard key. NULLABLE: This property indicates that this column is nullable. However, setting this property is insufficient for making the column nullable. The user must declare the type of the column as a union between its regular type and 'null' in the Avro schema for the record type in type\_definition . For example, if a column is of type integer and is nullable, then the entry for the column in the Avro schema must be: \['int', 'null']. The C++, C#, Java, and Python APIs have built-in convenience for bypassing setting the Avro schema by hand. For those languages, one can use this property as usual and not have to worry about the Avro schema for the record. 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. This property is primarily used in order to save disk space. DICT: This property indicates that this column should be dictionary encoded. It can only be used in conjunction with restricted string (charN), int, long or date columns. Dictionary encoding is best for columns where the cardinality (the number of unique values) is expected to be low. This property can save a large amount of memory. INIT\_WITH\_NOW: For 'date', 'time', 'datetime', or 'timestamp' column types, replace empty strings and invalid timestamps with 'NOW()' upon insert. INIT\_WITH\_UUID: For 'uuid' type, replace empty strings and invalid UUID values with randomly-generated UUIDs upon insert. UPDATE\_WITH\_NOW: For 'date', 'time', 'datetime', or 'timestamp' column types, update the field with 'NOW()' upon any update. UPDATE\_WITH\_USER: For 'charN' or 'string' column types, update the field with the current user's name upon any update. DEFAULT: Sets a default value expression for this column, e.g. 'default(0)', 'default(''pending'')', or 'default(NOW())'. When the column is omitted from an insert via request\_schema\_str, the expression is evaluated and the result is used as the column value. DEFAULT\_SQL: Sets a default value expression for this column with SQL syntax, e.g. 'default(0)', 'default(''pending'')', or 'default(NOW())'. Only used for showing the expression when generating SQL DDL. The default value is an empty Dictionary.
options	Optional parameters. COMPRESSION\_CODEC: The default compression codec for this type's columns. The default value is an empty Dictionary.

Definition at line 1081 of file CreateType.cs.

◆ CreateTypeRequest() \[3/4]

kinetica.CreateTypeRequest.CreateTypeRequest

(

)

inline

Constructs a CreateTypeRequest object with default parameters.

Definition at line 712 of file CreateType.cs.

◆ CreateTypeRequest() \[4/4]

kinetica.CreateTypeRequest.CreateTypeRequest	(	string	type\_definition,
		string	label,
		IDictionary\< string, IList\< string > >	properties = null,
		IDictionary\< string, string >	options = null )

inline

Constructs a CreateTypeRequest object with the specified parameters.

Parameters

type\_definition	JSON string defining the columns of the type to be registered, as described above.
label	A user-defined description string which can be used to differentiate between tables and types with otherwise identical schemas.
properties	\[DEPRECATED–please use these property values in the type\_definition directly, as described at the top, instead] Each key-value pair specifies the properties to use for a given column where the key is the column name. All keys used must be relevant column names for the given table. Specifying any property overrides the default properties for that column (which is based on the column's data type). Valid values are: DATA: Default property for all numeric and string type columns; makes the column available for GPU queries. TEXT\_SEARCH: Valid only for select 'string' columns. Enables full text search–see Full Text Search for details and applicable string column types. TIMESTAMP: Valid only for 'long' columns. Indicates that this field represents a timestamp and will be provided in milliseconds since the Unix epoch: 00:00:00 Jan 1 1970. Dates represented by a timestamp must fall between the year 1000 and the year 2900. ULONG: Valid only for 'string' columns. It represents an unsigned long integer data type. The string can only be interpreted as an unsigned long data type with minimum value of zero, and maximum value of 18446744073709551615. UUID: Valid only for 'string' columns. It represents an uuid data type. Internally, it is stored as a 128-bit integer. DECIMAL: Valid only for 'string' columns. It represents a SQL type NUMERIC(19, 4) data type. There can be up to 15 digits before the decimal point and up to four digits in the fractional part. The value can be positive or negative (indicated by a minus sign at the beginning). This property is mutually exclusive with the TEXT\_SEARCH property. DATE: Valid only for 'string' columns. Indicates that this field represents a date and will be provided in the format 'YYYY-MM-DD'. The allowable range is 1000-01-01 through 2900-01-01. This property is mutually exclusive with the TEXT\_SEARCH property. TIME: Valid only for 'string' columns. Indicates that this field represents a time-of-day and will be provided in the format 'HH:MM:SS.mmm'. The allowable range is 00:00:00.000 through 23:59:59.999. This property is mutually exclusive with the TEXT\_SEARCH property. DATETIME: Valid only for 'string' columns. Indicates that this field represents a datetime and will be provided in the format 'YYYY-MM-DD HH:MM:SS.mmm'. The allowable range is 1000-01-01 00:00:00.000 through 2900-01-01 23:59:59.999. This property is mutually exclusive with the TEXT\_SEARCH property. CHAR1: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 1 character. CHAR2: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 2 characters. CHAR4: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 4 characters. CHAR8: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 8 characters. CHAR16: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 16 characters. CHAR32: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 32 characters. CHAR64: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 64 characters. CHAR128: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 128 characters. CHAR256: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 256 characters. BOOLEAN: This property provides optimized memory and query performance for int columns. Ints with this property must be between 0 and 1(inclusive) INT8: This property provides optimized memory and query performance for int columns. Ints with this property must be between -128 and +127 (inclusive) INT16: This property provides optimized memory and query performance for int columns. Ints with this property must be between -32768 and +32767 (inclusive) IPV4: This property provides optimized memory, disk and query performance for string columns representing IPv4 addresses (i.e. 192.168.1.1). Strings with this property must be of the form: A.B.C.D where A, B, C and D are in the range of 0-255. ARRAY: 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. JSON: Valid only for 'string' columns. Indicates that this field contains values in JSON format. VECTOR: Valid only for 'bytes' columns. Indicates that this field contains a vector of floats. The length should be specified in parenthesis, e.g., 'vector(1000)'. WKT: Valid only for 'string' and 'bytes' columns. Indicates that this field contains geospatial geometry objects in Well-Known Text (WKT) or Well-Known Binary (WKB) format. PRIMARY\_KEY: This property indicates that this column will be part of (or the entire) primary key. SOFT\_PRIMARY\_KEY: This property indicates that this column will be part of (or the entire) soft primary key. SHARD\_KEY: This property indicates that this column will be part of (or the entire) shard key. NULLABLE: This property indicates that this column is nullable. However, setting this property is insufficient for making the column nullable. The user must declare the type of the column as a union between its regular type and 'null' in the Avro schema for the record type in type\_definition . For example, if a column is of type integer and is nullable, then the entry for the column in the Avro schema must be: \['int', 'null']. The C++, C#, Java, and Python APIs have built-in convenience for bypassing setting the Avro schema by hand. For those languages, one can use this property as usual and not have to worry about the Avro schema for the record. 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. This property is primarily used in order to save disk space. DICT: This property indicates that this column should be dictionary encoded. It can only be used in conjunction with restricted string (charN), int, long or date columns. Dictionary encoding is best for columns where the cardinality (the number of unique values) is expected to be low. This property can save a large amount of memory. INIT\_WITH\_NOW: For 'date', 'time', 'datetime', or 'timestamp' column types, replace empty strings and invalid timestamps with 'NOW()' upon insert. INIT\_WITH\_UUID: For 'uuid' type, replace empty strings and invalid UUID values with randomly-generated UUIDs upon insert. UPDATE\_WITH\_NOW: For 'date', 'time', 'datetime', or 'timestamp' column types, update the field with 'NOW()' upon any update. UPDATE\_WITH\_USER: For 'charN' or 'string' column types, update the field with the current user's name upon any update. DEFAULT: Sets a default value expression for this column, e.g. 'default(0)', 'default(''pending'')', or 'default(NOW())'. When the column is omitted from an insert via request\_schema\_str, the expression is evaluated and the result is used as the column value. DEFAULT\_SQL: Sets a default value expression for this column with SQL syntax, e.g. 'default(0)', 'default(''pending'')', or 'default(NOW())'. Only used for showing the expression when generating SQL DDL. The default value is an empty Dictionary.
options	Optional parameters. COMPRESSION\_CODEC: The default compression codec for this type's columns. The default value is an empty Dictionary.

Definition at line 1081 of file CreateType.cs.

Property Documentation

◆ label

string kinetica.CreateTypeRequest.label

getset

A user-defined description string which can be used to differentiate between tables and types with otherwise identical schemas.

Definition at line 345 of file CreateType.cs.

◆ options

IDictionary\< string, string > kinetica.CreateTypeRequest.options = new Dictionary\()

getset

Optional parameters.

COMPRESSION\_CODEC: The default compression codec for this type's columns.

The default value is an empty Dictionary.

Definition at line 708 of file CreateType.cs.

◆ properties

IDictionary\< string, IList\< string > > kinetica.CreateTypeRequest.properties = new Dictionary\>()

getset

\[DEPRECATED–please use these property values in the CreateTypeRequest.type\_definition directly, as described at the top, instead] Each key-value pair specifies the properties to use for a given column where the key is the column name.

All keys used must be relevant column names for the given table. Specifying any property overrides the default properties for that column (which is based on the column's data type). Valid values are:

DATA: Default property for all numeric and string type columns; makes the column available for GPU queries.
TEXT\_SEARCH: Valid only for select 'string' columns. Enables full text search–see Full Text Search for details and applicable string column types.
TIMESTAMP: Valid only for 'long' columns. Indicates that this field represents a timestamp and will be provided in milliseconds since the Unix epoch: 00:00:00 Jan 1 1970. Dates represented by a timestamp must fall between the year 1000 and the year 2900.
ULONG: Valid only for 'string' columns. It represents an unsigned long integer data type. The string can only be interpreted as an unsigned long data type with minimum value of zero, and maximum value of 18446744073709551615.
UUID: Valid only for 'string' columns. It represents an uuid data type. Internally, it is stored as a 128-bit integer.
DECIMAL: Valid only for 'string' columns. It represents a SQL type NUMERIC(19, 4) data type. There can be up to 15 digits before the decimal point and up to four digits in the fractional part. The value can be positive or negative (indicated by a minus sign at the beginning). This property is mutually exclusive with the TEXT\_SEARCH property.
DATE: Valid only for 'string' columns. Indicates that this field represents a date and will be provided in the format 'YYYY-MM-DD'. The allowable range is 1000-01-01 through 2900-01-01. This property is mutually exclusive with the TEXT\_SEARCH property.
TIME: Valid only for 'string' columns. Indicates that this field represents a time-of-day and will be provided in the format 'HH:MM:SS.mmm'. The allowable range is 00:00:00.000 through 23:59:59.999. This property is mutually exclusive with the TEXT\_SEARCH property.
DATETIME: Valid only for 'string' columns. Indicates that this field represents a datetime and will be provided in the format 'YYYY-MM-DD HH:MM:SS.mmm'. The allowable range is 1000-01-01 00:00:00.000 through 2900-01-01 23:59:59.999. This property is mutually exclusive with the TEXT\_SEARCH property.
CHAR1: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 1 character.
CHAR2: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 2 characters.
CHAR4: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 4 characters.
CHAR8: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 8 characters.
CHAR16: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 16 characters.
CHAR32: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 32 characters.
CHAR64: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 64 characters.
CHAR128: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 128 characters.
CHAR256: This property provides optimized memory, disk and query performance for string columns. Strings with this property must be no longer than 256 characters.
BOOLEAN: This property provides optimized memory and query performance for int columns. Ints with this property must be between 0 and 1(inclusive)
INT8: This property provides optimized memory and query performance for int columns. Ints with this property must be between -128 and +127 (inclusive)
INT16: This property provides optimized memory and query performance for int columns. Ints with this property must be between -32768 and +32767 (inclusive)
IPV4: This property provides optimized memory, disk and query performance for string columns representing IPv4 addresses (i.e. 192.168.1.1). Strings with this property must be of the form: A.B.C.D where A, B, C and D are in the range of 0-255.
ARRAY: 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.
JSON: Valid only for 'string' columns. Indicates that this field contains values in JSON format.
VECTOR: Valid only for 'bytes' columns. Indicates that this field contains a vector of floats. The length should be specified in parenthesis, e.g., 'vector(1000)'.
WKT: Valid only for 'string' and 'bytes' columns. Indicates that this field contains geospatial geometry objects in Well-Known Text (WKT) or Well-Known Binary (WKB) format.
PRIMARY\_KEY: This property indicates that this column will be part of (or the entire) primary key.
SOFT\_PRIMARY\_KEY: This property indicates that this column will be part of (or the entire) soft primary key.
SHARD\_KEY: This property indicates that this column will be part of (or the entire) shard key.
NULLABLE: This property indicates that this column is nullable. However, setting this property is insufficient for making the column nullable. The user must declare the type of the column as a union between its regular type and 'null' in the Avro schema for the record type in CreateTypeRequest.type\_definition. For example, if a column is of type integer and is nullable, then the entry for the column in the Avro schema must be: \['int', 'null']. The C++, C#, Java, and Python APIs have built-in convenience for bypassing setting the Avro schema by hand. For those languages, one can use this property as usual and not have to worry about the Avro schema for the record.
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. This property is primarily used in order to save disk space.
DICT: This property indicates that this column should be dictionary encoded. It can only be used in conjunction with restricted string (charN), int, long or date columns. Dictionary encoding is best for columns where the cardinality (the number of unique values) is expected to be low. This property can save a large amount of memory.
INIT\_WITH\_NOW: For 'date', 'time', 'datetime', or 'timestamp' column types, replace empty strings and invalid timestamps with 'NOW()' upon insert.
INIT\_WITH\_UUID: For 'uuid' type, replace empty strings and invalid UUID values with randomly-generated UUIDs upon insert.
UPDATE\_WITH\_NOW: For 'date', 'time', 'datetime', or 'timestamp' column types, update the field with 'NOW()' upon any update.
UPDATE\_WITH\_USER: For 'charN' or 'string' column types, update the field with the current user's name upon any update.
DEFAULT: Sets a default value expression for this column, e.g. 'default(0)', 'default(''pending'')', or 'default(NOW())'. When the column is omitted from an insert via request\_schema\_str, the expression is evaluated and the result is used as the column value.
DEFAULT\_SQL: Sets a default value expression for this column with SQL syntax, e.g. 'default(0)', 'default(''pending'')', or 'default(NOW())'. Only used for showing the expression when generating SQL DDL.

The default value is an empty Dictionary.

Definition at line 693 of file CreateType.cs.

◆ type\_definition

string kinetica.CreateTypeRequest.type\_definition

getset

JSON string defining the columns of the type to be registered, as described above.

Definition at line 340 of file CreateType.cs.

The documentation for this class was generated from the following files:

\_build/public-os\_ubuntu24.04-arch\_amd64-cc\_gcc\_13.3.0/install/Kinetica/Protocol/CreateType.cs
Kinetica/Protocol/CreateType.cs

Classes

Public Member Functions

Properties

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ CreateTypeRequest() \[1/4]

◆ CreateTypeRequest() \[2/4]

◆ CreateTypeRequest() \[3/4]

◆ CreateTypeRequest() \[4/4]

Property Documentation

◆ label

◆ options

◆ properties

◆ type\_definition