A set of string constants for the parameter options. More...

Public Attributes
const string	CREATE_TEMP_TABLE = "create_temp_table"
	If TRUE, a unique temporary table name will be generated in the sys_temp schema and used in place of join_table_name. More...

const string	TRUE = "true"

const string	FALSE = "false"

const string	COLLECTION_NAME = "collection_name"
	[DEPRECATED–please specify the containing schema for the join as part of join_table_name and use Kinetica.createSchema to create the schema if non-existent] Name of a schema for the join. More...

const string	MAX_QUERY_DIMENSIONS = "max_query_dimensions"
	No longer used. More...

const string	STRATEGY_DEFINITION = "strategy_definition"
	The tier strategy for the table and its columns. More...

const string	TTL = "ttl"
	Sets the TTL of the join table specified in join_table_name. More...

const string	VIEW_ID = "view_id"
	View this projection is part of. More...

const string	NO_COUNT = "no_count"
	Return a count of 0 for the join table for logging and for Kinetica.showTable; optimization needed for large overlapped equi-join stencils. More...

const string	CHUNK_SIZE = "chunk_size"
	Maximum number of records per joined-chunk for this table. More...

const string	ENABLE_VIRTUAL_CHUNKING = "enable_virtual_chunking"
	Collect chunks with accumulated size less than chunk_size into a single chunk. More...

const string	MAX_VIRTUAL_CHUNK_SIZE = "max_virtual_chunk_size"
	Maximum number of records per virtual-chunk. More...

const string	MIN_VIRTUAL_CHUNK_SIZE = "min_virtual_chunk_size"
	Minimum number of records per virtual-chunk. More...

const string	ENABLE_SPARSE_VIRTUAL_CHUNKING = "enable_sparse_virtual_chunking"
	Materialize virtual chunks with only non-deleted values. More...

const string	ENABLE_EQUI_JOIN_LAZY_RESULT_STORE = "enable_equi_join_lazy_result_store"
	Allow using the lazy result store to cache computation of one side of a multichunk equi-join. More...

const string	ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE = "enable_predicate_equi_join_lazy_result_store"
	Allow using the lazy result store to cache computation of one side of a multichunk predicate-equi-join. More...

const string	ENABLE_PK_EQUI_JOIN = "enable_pk_equi_join"
	Use equi-join to do primary key joins rather than using primary key index. More...

Detailed Description

A set of string constants for the parameter options.

Optional parameters.

Definition at line 24 of file CreateJoinTable.cs.

Member Data Documentation

◆ CHUNK_SIZE

const string CreateJoinTableRequest.Options.CHUNK_SIZE = "chunk_size"

Maximum number of records per joined-chunk for this table.

Defaults to the gpudb.conf file chunk size.

Definition at line 83 of file CreateJoinTable.cs.

◆ COLLECTION_NAME

const string CreateJoinTableRequest.Options.COLLECTION_NAME = "collection_name"

[DEPRECATED–please specify the containing schema for the join as part of join_table_name and use Kinetica.createSchema to create the schema if non-existent] Name of a schema for the join.

If the schema is non-existent, it will be automatically created. The default value is ''.

Definition at line 52 of file CreateJoinTable.cs.

◆ CREATE_TEMP_TABLE

const string CreateJoinTableRequest.Options.CREATE_TEMP_TABLE = "create_temp_table"

If TRUE, a unique temporary table name will be generated in the sys_temp schema and used in place of join_table_name.

Supported values:

TRUE
FALSE

The default value is FALSE.

Definition at line 40 of file CreateJoinTable.cs.

◆ ENABLE_EQUI_JOIN_LAZY_RESULT_STORE

const string CreateJoinTableRequest.Options.ENABLE_EQUI_JOIN_LAZY_RESULT_STORE = "enable_equi_join_lazy_result_store"

Allow using the lazy result store to cache computation of one side of a multichunk equi-join.

Reduces computation but also reduces parallelism to the number of chunks on the other side of the equi-join.

Definition at line 110 of file CreateJoinTable.cs.

◆ ENABLE_PK_EQUI_JOIN

const string CreateJoinTableRequest.Options.ENABLE_PK_EQUI_JOIN = "enable_pk_equi_join"

Use equi-join to do primary key joins rather than using primary key index.

Definition at line 121 of file CreateJoinTable.cs.

◆ ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE

const string CreateJoinTableRequest.Options.ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE = "enable_predicate_equi_join_lazy_result_store"

Allow using the lazy result store to cache computation of one side of a multichunk predicate-equi-join.

Reduces computation but also reduces parallelism to the number of chunks on the other side of the equi-join.

Definition at line 117 of file CreateJoinTable.cs.

◆ ENABLE_SPARSE_VIRTUAL_CHUNKING

const string CreateJoinTableRequest.Options.ENABLE_SPARSE_VIRTUAL_CHUNKING = "enable_sparse_virtual_chunking"

Materialize virtual chunks with only non-deleted values.

The default value is 'false'.

Definition at line 103 of file CreateJoinTable.cs.

◆ ENABLE_VIRTUAL_CHUNKING

const string CreateJoinTableRequest.Options.ENABLE_VIRTUAL_CHUNKING = "enable_virtual_chunking"

Collect chunks with accumulated size less than chunk_size into a single chunk.

The default value is 'false'.

Definition at line 88 of file CreateJoinTable.cs.

◆ FALSE

const string CreateJoinTableRequest.Options.FALSE = "false"

Definition at line 43 of file CreateJoinTable.cs.

◆ MAX_QUERY_DIMENSIONS

const string CreateJoinTableRequest.Options.MAX_QUERY_DIMENSIONS = "max_query_dimensions"

No longer used.

Definition at line 55 of file CreateJoinTable.cs.

◆ MAX_VIRTUAL_CHUNK_SIZE

const string CreateJoinTableRequest.Options.MAX_VIRTUAL_CHUNK_SIZE = "max_virtual_chunk_size"

Maximum number of records per virtual-chunk.

When set, enables virtual chunking. Defaults to chunk_size if virtual chunking otherwise enabled.

Definition at line 93 of file CreateJoinTable.cs.

◆ MIN_VIRTUAL_CHUNK_SIZE

const string CreateJoinTableRequest.Options.MIN_VIRTUAL_CHUNK_SIZE = "min_virtual_chunk_size"

Minimum number of records per virtual-chunk.

When set, enables virtual chunking. Defaults to chunk_size if virtual chunking otherwise enabled.

Definition at line 98 of file CreateJoinTable.cs.

◆ NO_COUNT

const string CreateJoinTableRequest.Options.NO_COUNT = "no_count"

Return a count of 0 for the join table for logging and for Kinetica.showTable; optimization needed for large overlapped equi-join stencils.

The default value is 'false'.

Definition at line 77 of file CreateJoinTable.cs.

◆ STRATEGY_DEFINITION

const string CreateJoinTableRequest.Options.STRATEGY_DEFINITION = "strategy_definition"

The tier strategy for the table and its columns.

Definition at line 60 of file CreateJoinTable.cs.

◆ TRUE

const string CreateJoinTableRequest.Options.TRUE = "true"

Definition at line 42 of file CreateJoinTable.cs.

◆ TTL

const string CreateJoinTableRequest.Options.TTL = "ttl"

Sets the TTL of the join table specified in join_table_name.

Definition at line 65 of file CreateJoinTable.cs.

◆ VIEW_ID

const string CreateJoinTableRequest.Options.VIEW_ID = "view_id"

View this projection is part of.

The default value is ''.

Definition at line 69 of file CreateJoinTable.cs.

The documentation for this struct was generated from the following file:

Kinetica/Protocol/CreateJoinTable.cs

Public Attributes

Detailed Description

Member Data Documentation

◆ CHUNK_SIZE

◆ COLLECTION_NAME

◆ CREATE_TEMP_TABLE

◆ ENABLE_EQUI_JOIN_LAZY_RESULT_STORE

◆ ENABLE_PK_EQUI_JOIN

◆ ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE

◆ ENABLE_SPARSE_VIRTUAL_CHUNKING

◆ ENABLE_VIRTUAL_CHUNKING

◆ FALSE

◆ MAX_QUERY_DIMENSIONS

◆ MAX_VIRTUAL_CHUNK_SIZE

◆ MIN_VIRTUAL_CHUNK_SIZE

◆ NO_COUNT

◆ STRATEGY_DEFINITION

◆ TRUE

◆ TTL

◆ VIEW_ID