Kinetica C# API  Version 7.1.10.0
 All Classes Namespaces Files Functions Variables Enumerations Enumerator Properties Pages
kinetica.CreateJoinTableRequest.Options Struct Reference

Optional parameters. 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(string,IDictionary{string, string}) 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(string,IDictionary{string, string}); 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...
 

Detailed Description

Optional parameters.

  • CREATE_TEMP_TABLE: If true, a unique temporary table name will be generated in the sys_temp schema and used in place of . 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.
  • COLLECTION_NAME: [DEPRECATED–please specify the containing schema for the join as part of and use /create/schema 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 ''.
  • MAX_QUERY_DIMENSIONS: No longer used.
  • OPTIMIZE_LOOKUPS: Use more memory to speed up the joining of tables. Supported values: The default value is FALSE.
  • STRATEGY_DEFINITION: The tier strategy for the table and its columns.
  • TTL: Sets the TTL of the join table specified in .
  • VIEW_ID: view this projection is part of. The default value is ''.
  • NO_COUNT: Return a count of 0 for the join table for logging and for /show/table; optimization needed for large overlapped equi-join stencils. The default value is 'false'.
  • CHUNK_SIZE: Maximum number of records per joined-chunk for this table. Defaults to the gpudb.conf file chunk size

The default value is an empty Dictionary. A set of string constants for the parameter options.

Definition at line 125 of file CreateJoinTable.cs.

Member Data Documentation

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

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(string,IDictionary{string, string}) 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 156 of file CreateJoinTable.cs.

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.

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

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

Definition at line 148 of file CreateJoinTable.cs.

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

No longer used.

Definition at line 159 of file CreateJoinTable.cs.

const string kinetica.CreateJoinTableRequest.Options.NO_COUNT = "no_count"

Return a count of 0 for the join table for logging and for Kinetica.showTable(string,IDictionary{string, string}); optimization needed for large overlapped equi-join stencils.

The default value is 'false'.

Definition at line 196 of file CreateJoinTable.cs.

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

Use more memory to speed up the joining of tables.

Supported values:

The default value is FALSE.

Definition at line 175 of file CreateJoinTable.cs.

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

The tier strategy for the table and its columns.

Definition at line 180 of file CreateJoinTable.cs.

const string kinetica.CreateJoinTableRequest.Options.TRUE = "true"

Definition at line 147 of file CreateJoinTable.cs.

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

Sets the TTL of the join table specified in join_table_name.

Definition at line 185 of file CreateJoinTable.cs.

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

view this projection is part of.

The default value is ''.

Definition at line 189 of file CreateJoinTable.cs.


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