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	OPTIMIZE_LOOKUPS = "optimize_lookups"
	Use more memory to speed up the joining of tables. 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	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 25 of file CreateJoinTable.cs.

Member Data Documentation

◆ CHUNK_SIZE

const string kinetica.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 100 of file CreateJoinTable.cs.

◆ COLLECTION_NAME

const string kinetica.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 54 of file CreateJoinTable.cs.

◆ CREATE_TEMP_TABLE

const string kinetica.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 41 of file CreateJoinTable.cs.

◆ ENABLE_PK_EQUI_JOIN

const string kinetica.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 109 of file CreateJoinTable.cs.

◆ ENABLE_VIRTUAL_CHUNKING

const string kinetica.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 105 of file CreateJoinTable.cs.

◆ FALSE

const string kinetica.CreateJoinTableRequest.Options.FALSE = "false"

Definition at line 44 of file CreateJoinTable.cs.

◆ MAX_QUERY_DIMENSIONS

const string kinetica.CreateJoinTableRequest.Options.MAX_QUERY_DIMENSIONS = "max_query_dimensions"

No longer used.

Definition at line 57 of file CreateJoinTable.cs.

◆ NO_COUNT

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

◆ OPTIMIZE_LOOKUPS

const string kinetica.CreateJoinTableRequest.Options.OPTIMIZE_LOOKUPS = "optimize_lookups"

Use more memory to speed up the joining of tables.

Supported values:

TRUE
FALSE

The default value is FALSE.

Definition at line 72 of file CreateJoinTable.cs.

◆ STRATEGY_DEFINITION

const string kinetica.CreateJoinTableRequest.Options.STRATEGY_DEFINITION = "strategy_definition"

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"

Definition at line 43 of file CreateJoinTable.cs.

◆ TTL

const string kinetica.CreateJoinTableRequest.Options.TTL = "ttl"

Sets the TTL of the join table specified in join_table_name.

Definition at line 82 of file CreateJoinTable.cs.

◆ VIEW_ID

const string kinetica.CreateJoinTableRequest.Options.VIEW_ID = "view_id"

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 file:

Kinetica/Protocol/CreateJoinTable.cs

Public Attributes