Kinetica C# API  Version 7.1.10.0
 All Classes Namespaces Files Functions Variables Enumerations Enumerator Properties Pages
CreateProjection.cs
Go to the documentation of this file.
1 /*
2  * This file was autogenerated by the Kinetica schema processor.
3  *
4  * DO NOT EDIT DIRECTLY.
5  */
6 
7 using System.Collections.Generic;
8 
9 
10 
11 namespace kinetica
12 {
13 
57  {
58 
346  public struct Options
347  {
348 
368  public const string CREATE_TEMP_TABLE = "create_temp_table";
369  public const string TRUE = "true";
370  public const string FALSE = "false";
371 
379  public const string COLLECTION_NAME = "collection_name";
380 
385  public const string EXPRESSION = "expression";
386 
402  public const string IS_REPLICATED = "is_replicated";
403 
407  public const string OFFSET = "offset";
408 
411  public const string LIMIT = "limit";
412 
418  public const string ORDER_BY = "order_by";
419 
422  public const string CHUNK_SIZE = "chunk_size";
423 
429  public const string CREATE_INDEXES = "create_indexes";
430 
434  public const string TTL = "ttl";
435 
441  public const string SHARD_KEY = "shard_key";
442 
461  public const string PERSIST = "persist";
462 
478  public const string PRESERVE_DICT_ENCODING = "preserve_dict_encoding";
479 
495  public const string RETAIN_PARTITIONS = "retain_partitions";
496 
537  public const string PARTITION_TYPE = "partition_type";
538 
542  public const string RANGE = "RANGE";
543 
547  public const string INTERVAL = "INTERVAL";
548 
552  public const string LIST = "LIST";
553 
557  public const string HASH = "HASH";
558 
562  public const string SERIES = "SERIES";
563 
568  public const string PARTITION_KEYS = "partition_keys";
569 
583  public const string PARTITION_DEFINITIONS = "partition_definitions";
584 
603  public const string IS_AUTOMATIC_PARTITION = "is_automatic_partition";
604 
607  public const string VIEW_ID = "view_id";
608 
612  public const string STRATEGY_DEFINITION = "strategy_definition";
613  } // end struct Options
614 
615 
622  public string table_name { get; set; }
623 
630  public string projection_name { get; set; }
631 
636  public IList<string> column_names { get; set; } = new List<string>();
637 
923  public IDictionary<string, string> options { get; set; } = new Dictionary<string, string>();
924 
925 
929 
1237  string projection_name,
1238  IList<string> column_names,
1239  IDictionary<string, string> options = null)
1240  {
1241  this.table_name = table_name ?? "";
1242  this.projection_name = projection_name ?? "";
1243  this.column_names = column_names ?? new List<string>();
1244  this.options = options ?? new Dictionary<string, string>();
1245  } // end constructor
1246 
1247  } // end class CreateProjectionRequest
1248 
1249 
1250 
1255  {
1256 
1275  public struct Info
1276  {
1277 
1279  public const string COUNT = "count";
1280 
1283  public const string QUALIFIED_PROJECTION_NAME = "qualified_projection_name";
1284  } // end struct Info
1285 
1286 
1289  public string projection_name { get; set; }
1290 
1307  public IDictionary<string, string> info { get; set; } = new Dictionary<string, string>();
1308 
1309  } // end class CreateProjectionResponse
1310 
1311 
1312 
1313 
1314 } // end namespace kinetica
const string ORDER_BY
Comma-separated list of the columns to be sorted by; e.g.
CreateProjectionRequest(string table_name, string projection_name, IList< string > column_names, IDictionary< string, string > options=null)
Constructs a CreateProjectionRequest object with the specified parameters.
const string PERSIST
If true, then the projection specified in projection_name will be persisted and will not expire unles...
const string EXPRESSION
An optional filter expression to be applied to the source table prior to the projection.
const string STRATEGY_DEFINITION
The tier strategy for the table and its columns.
const string SERIES
Use series partitioning.
const string HASH
Use hash partitioning.
string projection_name
Name of the projection to be created, in [schema_name.
IList< string > column_names
List of columns from to be included in the projection.
const string PARTITION_DEFINITIONS
Comma-separated list of partition definitions, whose format depends on the choice of partition_type...
const string LIMIT
The number of records to keep.
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 ...
IDictionary< string, string > options
Optional parameters.
IDictionary< string, string > info
Additional information.
const string PARTITION_TYPE
Partitioning scheme to use.
const string RANGE
Use range partitioning.
const string INTERVAL
Use interval partitioning.
const string COUNT
Number of records in the final table
A set of results returned by Kinetica.createProjection(string,string,IList{string},IDictionary{string, string}).
const string OFFSET
The number of initial results to skip (this can be useful for paging through the results).
CreateProjectionRequest()
Constructs a CreateProjectionRequest object with default parameters.
const string SHARD_KEY
Comma-separated list of the columns to be sharded on; e.g.
const string PARTITION_KEYS
Comma-separated list of partition keys, which are the columns or column expressions by which records ...
A set of parameters for Kinetica.createProjection(string,string,IList{string},IDictionary{string, string}).
const string QUALIFIED_PROJECTION_NAME
The fully qualified name of the projection (i.e.
const string IS_AUTOMATIC_PARTITION
If true, a new partition will be created for values which don&#39;t fall into an existing partition...
const string LIST
Use list partitioning.
const string TTL
Sets the TTL of the projection specified in projection_name.
const string COLLECTION_NAME
[DEPRECATED–please specify the containing schema for the projection as part of projection_name and us...
KineticaData - class to help with Avro Encoding for Kinetica
Definition: KineticaData.cs:14
const string CHUNK_SIZE
Indicates the number of records per chunk to be used for this projection.
const string PRESERVE_DICT_ENCODING
If true, then columns that were dict encoded in the source table will be dict encoded in the projecti...
string table_name
Name of the existing table on which the projection is to be applied, in [schema_name.
const string VIEW_ID
ID of view of which this projection is a member.
const string RETAIN_PARTITIONS
Determines whether the created projection will retain the partitioning scheme from the source table...
const string CREATE_INDEXES
Comma-separated list of columns on which to create indexes on the projection.
const string IS_REPLICATED
If true then the projection will be replicated even if the source table is not.