7 using System.Collections.Generic;
20 public class CreateJoinTableRequest : KineticaData
43 public const string TRUE =
"true";
44 public const string FALSE =
"false";
82 public const string TTL =
"ttl";
86 public const string VIEW_ID =
"view_id";
94 public const string NO_COUNT =
"no_count";
100 public const string CHUNK_SIZE =
"chunk_size";
157 public IList<string>
table_names {
get;
set; } =
new List<string>();
169 public IList<string>
column_names {
get;
set; } =
new List<string>();
177 public IList<string>
expressions {
get;
set; } =
new List<string>();
336 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
532 IDictionary<string, string>
options =
null)
535 this.table_names =
table_names ??
new List<string>();
545 public class CreateJoinTableResponse : KineticaData
564 public long count {
get;
set; }
577 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
const string MAX_QUERY_DIMENSIONS
No longer used.
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
const string 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 MAX_VIRTUAL_CHUNK_SIZE
Maximum number of records per virtual-chunk.
const string MIN_VIRTUAL_CHUNK_SIZE
Minimum number of records per virtual-chunk.
IList< string > expressions
An optional list of expressions to combine and filter the joined tables.
CreateJoinTableRequest()
Constructs a CreateJoinTableRequest object with default parameters.
long count
The number of records in the join table filtered by the given select expression.
const string TTL
Sets the TTL of the join table specified in join_table_name.
IList< string > table_names
The list of table names composing the join, each in [schema_name.
const string NO_COUNT
Return a count of 0 for the join table for logging and for Kinetica.showTable; optimization needed fo...
IList< string > column_names
List of member table columns or column expressions to be included in the join.
IDictionary< string, string > info
Additional information.
const string ENABLE_PK_EQUI_JOIN
Use equi-join to do primary key joins rather than using primary-key-index
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema for the join as part of join_table_name and use Kine...
const string CREATE_TEMP_TABLE
If TRUE, a unique temporary table name will be generated in the sys_temp schema and used in place of ...
const string OPTIMIZE_LOOKUPS
Use more memory to speed up the joining of tables.
const string ENABLE_VIRTUAL_CHUNKING
Collect chunks with accumulated size less than chunk_size into a single chunk.
IDictionary< string, string > options
Optional parameters.
string join_table_name
Value of join_table_name.
const string CHUNK_SIZE
Maximum number of records per joined-chunk for this table.
const string ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE
Allow using the lazy result store to cache computation of one side of a multichunk predicate-equi-joi...
const string ENABLE_SPARSE_VIRTUAL_CHUNKING
materialize virtual chunks with only non-deleted values.
CreateJoinTableRequest(string join_table_name, IList< string > table_names, IList< string > column_names, IList< string > expressions=null, IDictionary< string, string > options=null)
Constructs a CreateJoinTableRequest object with the specified parameters.
const string VIEW_ID
view this projection is part of.
string join_table_name
Name of the join table to be created, in [schema_name.
const string QUALIFIED_JOIN_TABLE_NAME
The fully qualified name of the join table (i.e.