Skip to main content

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

​
Static 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 CreateJoinTableRequest.join_table_name.
 
const string TRUE = “true”
 A boolean constant for the CreateJoinTableRequest.Options options.
 
const string FALSE = “false”
 A boolean constant for the CreateJoinTableRequest.Options options.
 
const string COLLECTION_NAME = “collection_name”
 [DEPRECATED–please specify the containing schema for the join as part of CreateJoinTableRequest.join_table_name and use Kinetica.createSchema to create the schema if non-existent] Name of a schema for the join.
 
const string MAX_QUERY_DIMENSIONS = “max_query_dimensions”
 No longer used.
 
const string STRATEGY_DEFINITION = “strategy_definition”
 The tier strategy for the table and its columns.
 
const string TTL = “ttl”
 Sets the TTL of the join table specified in CreateJoinTableRequest.join_table_name.
 
const string VIEW_ID = “view_id”
 View this projection is part of.
 
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.
 
const string CHUNK_SIZE = “chunk_size”
 Maximum number of records per joined-chunk for this table.
 
const string ENABLE_VIRTUAL_CHUNKING = “enable_virtual_chunking”
 Collect chunks with accumulated size less than chunk_size into a single chunk.
 
const string MAX_VIRTUAL_CHUNK_SIZE = “max_virtual_chunk_size”
 Maximum number of records per virtual-chunk.
 
const string MIN_VIRTUAL_CHUNK_SIZE = “min_virtual_chunk_size”
 Minimum number of records per virtual-chunk.
 
const string ENABLE_SPARSE_VIRTUAL_CHUNKING = “enable_sparse_virtual_chunking”
 Materialize virtual chunks with only non-deleted values.
 
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.
 
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.
 
const string ENABLE_PK_EQUI_JOIN = “enable_pk_equi_join”
 Use equi-join to do primary key joins rather than using primary key index.
 

​
Detailed Description

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

Optional parameters.

Definition at line 24 of file CreateJoinTable.cs.

​
Member Data Documentation

​
◆ CHUNK_SIZE

const string kinetica.CreateJoinTableRequest.Options.CHUNK_SIZE = “chunk_size”
 static

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

Defaults to the gpudb.conf file chunk size.

Definition at line 100 of file CreateJoinTable.cs.

​
◆ COLLECTION_NAME

const string kinetica.CreateJoinTableRequest.Options.COLLECTION_NAME = “collection_name”
 static

[DEPRECATED–please specify the containing schema for the join as part of CreateJoinTableRequest.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 69 of file CreateJoinTable.cs.

​
◆ CREATE_TEMP_TABLE

const string kinetica.CreateJoinTableRequest.Options.CREATE_TEMP_TABLE = “create_temp_table”
 static

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

This is always allowed even if the caller does not have permission to create tables. The generated name is returned in QUALIFIED_JOIN_TABLE_NAME. Supported values:

The default value is FALSE.

Definition at line 51 of file CreateJoinTable.cs.

​
◆ ENABLE_EQUI_JOIN_LAZY_RESULT_STORE

const string kinetica.CreateJoinTableRequest.Options.ENABLE_EQUI_JOIN_LAZY_RESULT_STORE = “enable_equi_join_lazy_result_store”
 static

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 127 of file CreateJoinTable.cs.

​
◆ ENABLE_PK_EQUI_JOIN

const string kinetica.CreateJoinTableRequest.Options.ENABLE_PK_EQUI_JOIN = “enable_pk_equi_join”
 static

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

Definition at line 138 of file CreateJoinTable.cs.

​
◆ ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE

const string kinetica.CreateJoinTableRequest.Options.ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE = “enable_predicate_equi_join_lazy_result_store”
 static

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 134 of file CreateJoinTable.cs.

​
◆ ENABLE_SPARSE_VIRTUAL_CHUNKING

const string kinetica.CreateJoinTableRequest.Options.ENABLE_SPARSE_VIRTUAL_CHUNKING = “enable_sparse_virtual_chunking”
 static

Materialize virtual chunks with only non-deleted values.

The default value is ‘false’.

Definition at line 120 of file CreateJoinTable.cs.

​
◆ ENABLE_VIRTUAL_CHUNKING

const string kinetica.CreateJoinTableRequest.Options.ENABLE_VIRTUAL_CHUNKING = “enable_virtual_chunking”
 static

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

The default value is ‘false’.

Definition at line 105 of file CreateJoinTable.cs.

​
◆ FALSE

const string kinetica.CreateJoinTableRequest.Options.FALSE = “false”
 static

A boolean constant for the CreateJoinTableRequest.Options options.

Definition at line 59 of file CreateJoinTable.cs.

​
◆ MAX_QUERY_DIMENSIONS

const string kinetica.CreateJoinTableRequest.Options.MAX_QUERY_DIMENSIONS = “max_query_dimensions”
 static

No longer used.

Definition at line 72 of file CreateJoinTable.cs.

​
◆ MAX_VIRTUAL_CHUNK_SIZE

const string kinetica.CreateJoinTableRequest.Options.MAX_VIRTUAL_CHUNK_SIZE = “max_virtual_chunk_size”
 static

Maximum number of records per virtual-chunk.

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

Definition at line 110 of file CreateJoinTable.cs.

​
◆ MIN_VIRTUAL_CHUNK_SIZE

const string kinetica.CreateJoinTableRequest.Options.MIN_VIRTUAL_CHUNK_SIZE = “min_virtual_chunk_size”
 static

Minimum number of records per virtual-chunk.

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

Definition at line 115 of file CreateJoinTable.cs.

​
◆ NO_COUNT

const string kinetica.CreateJoinTableRequest.Options.NO_COUNT = “no_count”
 static

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 94 of file CreateJoinTable.cs.

​
◆ STRATEGY_DEFINITION

const string kinetica.CreateJoinTableRequest.Options.STRATEGY_DEFINITION = “strategy_definition”
 static

The tier strategy for the table and its columns.

Definition at line 77 of file CreateJoinTable.cs.

​
◆ TRUE

const string kinetica.CreateJoinTableRequest.Options.TRUE = “true”
 static

A boolean constant for the CreateJoinTableRequest.Options options.

Definition at line 55 of file CreateJoinTable.cs.

​
◆ TTL

const string kinetica.CreateJoinTableRequest.Options.TTL = “ttl”
 static

Sets the TTL of the join table specified in CreateJoinTableRequest.join_table_name.

Definition at line 82 of file CreateJoinTable.cs.

​
◆ VIEW_ID

const string kinetica.CreateJoinTableRequest.Options.VIEW_ID = “view_id”
 static

View this projection is part of.

The default value is ”.

Definition at line 86 of file CreateJoinTable.cs.

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