7 using System.Collections.Generic;
172 public const string TRUE =
"true";
173 public const string FALSE =
"false";
364 public IDictionary<string, string>
options {
get; set; } =
new Dictionary<string, string>();
486 IDictionary<string, string>
options = null)
488 this.table_name = table_name ??
"";
489 this.options =
options ??
new Dictionary<string, string>();
544 public const string VIEW =
"VIEW";
546 public const string JOIN =
"JOIN";
604 public const string TRUE =
"true";
605 public const string FALSE =
"false";
678 public const string RANGE =
"RANGE";
688 public const string LIST =
"LIST";
691 public const string NONE =
"NONE";
844 public IList<string>
table_names {
get; set; } =
new List<string>();
887 public IList<string>
type_ids {
get; set; } =
new List<string>();
895 public IList<string>
type_labels {
get; set; } =
new List<string>();
899 public IList<IDictionary<string, IList<string>>>
properties {
get; set; } =
new List<IDictionary<string, IList<string>>>();
906 public IList<IDictionary<string, string>>
additional_info {
get; set; } =
new List<IDictionary<string, string>>();
911 public IList<long>
sizes {
get; set; } =
new List<long>();
917 public IList<long>
full_sizes {
get; set; } =
new List<long>();
927 public IList<double>
join_sizes {
get; set; } =
new List<double>();
939 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...
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
Semicolon-separated list of compressed columns with the corresponding compression type for each; e...
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 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_table_...
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 if the...
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 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.
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.
A set of results returned by Kinetica.showTable(string,IDictionary{string, string}).
const string SHOW_CHILDREN
If table_name is a collection, then true will return information about the children of the collection...
const string CREATE_PROJECTION
const string FOREIGN_KEYS
Semicolon-separated list of foreign keys, of the format 'source_column references target_table(primar...
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 columns that have indexes.
const string PROTECTED
Indicates whether the respective table is protected or not.
const string IS_AUTOMATIC_PARTITION
True if partitions will be created for LIST VALUES which don't fall into existing partitions...
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 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 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
The names of the collections this table is part of.
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.
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.