7 using System.Collections.Generic;
199 public const string TRUE =
"true";
200 public const string FALSE =
"false";
433 public IDictionary<string, string>
options {
get; set; } =
new Dictionary<string, string>();
578 IDictionary<string, string>
options = null)
580 this.table_name = table_name ??
"";
581 this.options =
options ??
new Dictionary<string, string>();
652 public const string JOIN =
"JOIN";
662 public const string VIEW =
"VIEW";
715 public const string TRUE =
"true";
716 public const string FALSE =
"false";
812 public const string RANGE =
"RANGE";
822 public const string LIST =
"LIST";
827 public const string HASH =
"HASH";
835 public const string NONE =
"NONE";
1060 public IList<string>
type_ids {
get; set; } =
new List<string>();
1072 public IList<IDictionary<string, IList<string>>>
properties {
get; set; } =
new List<IDictionary<string, IList<string>>>();
1079 public IList<IDictionary<string, string>>
additional_info {
get; set; } =
new List<IDictionary<string, string>>();
1084 public IList<long>
sizes {
get; set; } =
new List<long>();
1100 public IList<double>
join_sizes {
get; set; } =
new List<double>();
1112 public IDictionary<string, string>
info {
get; set; } =
new Dictionary<string, string>();
const string IS_DIRTY
True if some input table of the materialized view that affects this member table has been modified si...
const string LOGICAL_EXTERNAL_TABLE
IList< long > full_sizes
If get_sizes is true, an array containing the number of records of each corresponding table in <membe...
const string PARTITION_KEYS
Comma-separated list of partition keys.
IList< IList< string > > table_descriptions
List of descriptions for the respective tables in <member name="table_names">.
IList< long > sizes
If get_sizes is true, an array containing the number of records of each corresponding table in <membe...
const string IS_VIEW_PERSISTED
True if the view named view_table_name is persisted - reported for each view member.
const string COMPRESSED_COLUMNS
No longer supported.
const string NO_ERROR_IF_NOT_EXISTS
If false will return an error if the provided table_name does not exist.
Additional information about the respective tables in <member name="table_names">.
const string REFRESH_STOP_TIME
Time at which the periodic view refresh stops.
const string CREATE_UNION
const string RECORD_BYTES
The number of in-memory bytes per record which is the sum of the byte sizes of all columns with prope...
const string GET_SIZES
If true then the number of records in each table, along with a cumulative count, will be returned; bl...
const string NO_ACCESS
No read/write operations are allowed on this table.
const string ALTERNATE_SHARD_KEYS
Semicolon-separated list of shard keys that were equated in joins (applicable for join tables)...
IList< string > type_schemas
Type schemas of the respective tables in <member name="table_names">.
const string MATERIALIZED_VIEW_UNDER_CONSTRUCTION
IList< IDictionary< string, IList< string > > > properties
Property maps of the respective tables in <member name="table_names">.
IDictionary< string, string > options
Optional parameters.
IList< string > type_ids
Type ids of the respective tables in <member name="table_names">.
const string FOREIGN_SHARD_KEY
Foreign shard key description of the format: <fk_foreign_key> references <pk_column_name> from <pk_ta...
const string REQUEST_AVRO_JSON
The JSON representation of request creating this table.
const string FORCE_SYNCHRONOUS
If true then the table sizes will wait for read lock before returning.
const string COLUMN_INFO
JSON-encoded string representing a map of column name to information including memory usage if the ge...
const string REFRESH_START_TIME
For materialized view with periodic refresh_method the current intial datetime string that periodic r...
const string CREATE_TABLE
const string LOGICAL_VIEW
const string READ_WRITE
All read/write operations are allowed on this table.
IList< string > table_names
If is a table or view, then the single element of the array is .
const string GET_COLUMN_INFO
If true then column info (memory usage, etc) will be returned.
const string VIEW_TABLE_NAME
For materialized view the name of the view this member table is part of - if same as the table_name t...
const string TABLE_TTL
The value of the time-to-live setting.
const string REFRESH_PERIOD
For materialized view with periodic refresh_method the current refresh period in seconds.
const string SCHEMA_NAME
The name of the schema for the table.
ShowTableRequest(string table_name, IDictionary< string, string > options=null)
Constructs a ShowTableRequest object with the specified parameters.
const string MATERIALIZED_VIEW_MEMBER
ShowTableRequest()
Constructs a ShowTableRequest object with default parameters.
const string DATASOURCE_SUBSCRIPTIONS
Semicolon-separated list of datasource names the table has subscribed to.
A set of results returned by Kinetica.showTable(string,IDictionary{string, string}).
const string SHOW_CHILDREN
If table_name is a schema, then true will return information about the tables and views in the schema...
const string GET_CACHED_SIZES
If true then the number of records in each table, along with a cumulative count, will be returned; bl...
const string CREATE_PROJECTION
const string TOTAL_BYTES
The total size in bytes of all data stored in the table.
const string FOREIGN_KEYS
Semicolon-separated list of foreign keys, of the format 'source_column references target_table(primar...
const string MATERIALIZED_EXTERNAL_TABLE
const string NONE
Using no partitioning
const string RANGE
Using range partitioning
const string PARTITION_DEFINITIONS
Comma-separated list of partition definitions, whose format depends on the partition_type.
const string ATTRIBUTE_INDEXES
Semicolon-separated list of indexes.
const string PROTECTED
No longer used.
const string IS_AUTOMATIC_PARTITION
True if partitions will be created for LIST VALUES which don't fall into existing partitions...
const string OWNER_RESOURCE_GROUP
Name of the owner resource group.
const string GLOBAL_ACCESS_MODE
Returns the global access mode (i.e.
IList< double > join_sizes
If get_sizes is true, an array containing the number of unfiltered records in the cross product of th...
const string LAST_REFRESH_TIME
For materialized view the a datatime string indicating the last time the view was refreshed...
const string READ_ONLY
Only read operations are allowed on this table.
List of descriptions for the respective tables in <member name="table_names">.
A set of parameters for Kinetica.showTable(string,IDictionary{string, string}).
IDictionary< string, string > info
Additional information.
const string MATERIALIZED_VIEW
const string NEXT_REFRESH_TIME
For materialized view with periodic refresh_method a datetime string indicating the next time the vie...
const string SERIES
Using series partitioning.
const string REQUEST_AVRO_TYPE
Method by which this table was created.
const string REFRESH_METHOD
For materialized view current refresh_method - one of manual, periodic, on_change.
string table_name
Value of .
IList< string > type_labels
Type labels of the respective tables in <member name="table_names">.
IList< IDictionary< string, string > > additional_info
Additional information about the respective tables in <member name="table_names">.
const string PARTITION_TYPE
Partitioning scheme used for this table Supported values: RANGE: Using range partitioning INTERVAL: ...
const string RESULT_TABLE
const string HASH
Using hash partitioning.
const string REMAINING_TABLE_TTL
The remaining time-to-live, in minutes, before the respective table expires (-1 if it will never expi...
const string COLLECTION_NAMES
[DEPRECATED–use schema_name instead] This will now contain the name of the schema for the table...
KineticaData - class to help with Avro Encoding for Kinetica
long total_full_size
If get_sizes is true, the sum of the elements of <member name="full_sizes"> (same value as <member na...
long total_size
If get_sizes is true, the sum of the elements of <member name="sizes">.
const string WRITE_ONLY
Only write operations are allowed on this table.
const string INTERVAL
Using interval partitioning
string table_name
Name of the table for which to retrieve the information, in [schema_name.
const string LIST
Using manual list partitioning
const string USER_CHUNK_SIZE
User-specified number of records per chunk, if provided at table creation time.