7 using System.Collections.Generic;
62 public const string TRUE =
"true";
63 public const string FALSE =
"false";
441 public IDictionary<string, string>
options {
get;
set; } =
new Dictionary<string, string>();
666 IDictionary<string, string>
options =
null)
685 public const string JOIN =
"JOIN";
695 public const string VIEW =
"VIEW";
746 public const string TRUE =
"true";
747 public const string FALSE =
"false";
799 public const string DISK =
"disk";
865 public const string RANGE =
"RANGE";
875 public const string LIST =
"LIST";
880 public const string HASH =
"HASH";
888 public const string NONE =
"NONE";
1185 public IList<string>
type_ids {
get;
set; } =
new List<string>();
1197 public IList<IDictionary<string, IList<string>>>
properties {
get;
set; } =
new List<IDictionary<string, IList<string>>>();
1669 public IList<IDictionary<string, string>>
additional_info {
get;
set; } =
new List<IDictionary<string, string>>();
1677 public IList<long>
sizes {
get;
set; } =
new List<long>();
1700 public IList<double>
join_sizes {
get;
set; } =
new List<double>();
1718 public IDictionary<string, string>
info {
get;
set; } =
new Dictionary<string, string>();
const string CREATED_BY
User that created this table or view.
IList< long > full_sizes
If GET_SIZES is TRUE, an array containing the number of records of each corresponding table in table_...
const string ALTERNATE_SHARD_KEYS
Semicolon-separated list of shard keys that were equated in joins (applicable for join tables).
const string PROTECTED
No longer used.
IList< IList< string > > table_descriptions
List of descriptions for the respective tables in table_names.
const string REFERENCING_MATERIALIZED_VIEWS
Include materialized views using this table as a source in the output.
const string READ_ONLY
Only read operations are allowed on this table.
IDictionary< string, string > info
Additional information.
const string REQUEST_AVRO_JSON
The JSON representation of request creating this table.
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 CREATE_PROJECTION
IList< string > type_ids
Type IDs of the respective tables in table_names.
const string WRITE_COUNT
Count of times this table was written.
const string USER_CHUNK_MAX_MEMORY
User-specified target max bytes for all columns in a chunk, if provided at table creation time.
const string COLUMN_INFO
JSON-encoded string representing a map of column name to information including memory usage if the GE...
const string MEMORY
In-memory primary key.
A set of string constants for the parameter additional_info.
ShowTableRequest(string table_name, IDictionary< string, string > options=null)
Constructs a ShowTableRequest object with the specified parameters.
const string PARTITION_KEYS
Comma-separated list of partition keys.
const string LAST_ALTER_TIME
Time (UTC) when this table or view was last altered.
const string CREATE_UNION
const string SHOW_CHILDREN
If table_name is a schema, then TRUE will return information about the tables and views in the schema...
KineticaData - class to help with Avro Encoding for Kinetica
const string REMAINING_TABLE_TTL
The remaining time-to-live, in minutes, before the respective table expires (-1 if it will never expi...
ShowTableRequest()
Constructs a ShowTableRequest object with default parameters.
string table_name
Name of the table for which to retrieve the information, in [schema_name.
const string READ_COUNT
Count of times this table or view was read.
const string LAST_READ_BY
User that last read this table or view.
IList< long > sizes
If GET_SIZES is TRUE, an array containing the number of records of each corresponding table in table_...
const string REFRESH_STOP_TIME
Time at which the periodic view refresh stops.
const string NULL_MODIFYING_COLUMNS
Comma-separated list of null modifying column names.
const string LAST_REFRESH_TIME
For materialized view the datetime string indicating the last time the view was refreshed.
IList< string > table_names
If table_name is a table or view, then the single element of the array is table_name.
const string ALTER_COUNT
Count of times this table or view was altered.
const string SKIP_ADDITIONAL_INFO
If TRUE then the response will not populate the additional_info field.
const string FORCE_SYNCHRONOUS
If TRUE then the table sizes will wait for read lock before returning.
const string IS_VIEW_PERSISTED
True if the view named view_table_name is persisted - reported for each view member.
const string SCHEMA_NAME
The name of the schema for the table.
const string USER_CHUNK_SIZE
User-specified number of records per chunk, if provided at table creation time.
const string IS_DIRTY
True if some input table of the materialized view that affects this member table has been modified si...
IList< IDictionary< string, IList< string > > > properties
Property maps of the respective tables in table_names.
const string LAST_WRITE_BY
User that last wrote to this table.
const string TOTAL_BYTES
The total size in bytes of all data stored in the table.
IDictionary< string, string > options
Optional parameters.
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 PRIMARY_KEY_TYPE
The primary key type of the table (if it has a primary key).
const string FOREIGN_KEYS
Semicolon-separated list of foreign keys, of the format 'source_column references target_table(primar...
IList< string > type_schemas
Type schemas of the respective tables in table_names.
const string USER_CHUNK_COLUMN_MAX_MEMORY
User-specified target max bytes per column in a chunk, if provided at table creation time.
A set of parameters for Kinetica.showTable.
const string IS_AUTOMATIC_PARTITION
True if partitions will be created for LIST VALUES which don't fall into existing partitions.
const string LOGICAL_EXTERNAL_TABLE
const string REFRESH_START_TIME
For materialized view with periodic refresh_method the initial datetime string that periodic refreshe...
const string DATASOURCE_SUBSCRIPTIONS
Semicolon-separated list of datasource names the table has subscribed to.
const string GET_ACCESS_DATA
If TRUE then data about the last read, write, alter and create will be returned.
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 LAST_READ_TIME
Time (UTC) when this table or view was last read.
const string READ_WRITE
All read/write operations are allowed on this table.
const string REFRESH_PERIOD
For materialized view with periodic refresh_method the current refresh period in seconds.
A set of results returned by Kinetica.showTable.
const string INTERVAL
Using interval partitioning.
const string ATTRIBUTE_INDEXES
Semicolon-separated list of indexes.
long total_full_size
If GET_SIZES is TRUE, the sum of the elements of full_sizes (same value as total_size).
const string MATERIALIZED_VIEW_MEMBER
const string RANGE
Using range partitioning.
const string LIST
Using manual list partitioning.
const string FOREIGN_SHARD_KEY
Foreign shard key description of the format: <fk_foreign_key> references <pk_column_name> from <pk_ta...
const string NO_ACCESS
No read/write operations are allowed on this table.
const string CREATE_TABLE
const string REFRESH_METHOD
For materialized view current refresh_method - one of manual, periodic, on_change.
const string TABLE_TTL
The value of the time-to-live setting.
const string GLOBAL_ACCESS_MODE
Returns the global access mode (i.e.
const string COLLECTION_NAMES
[DEPRECATED–use schema_name instead] This will now contain the name of the schema for the table.
const string LOGICAL_VIEW
const string GET_COLUMN_INFO
If TRUE then column info (memory usage, etc) will be returned.
const string REQUEST_AVRO_TYPE
Method by which this table was created.
const string WRITE_ONLY
Only write operations are allowed on this table.
const string DEPENDENCIES
Include view dependencies in the output.
A set of string constants for the parameter table_descriptions.
const string MATERIALIZED_VIEW_UNDER_CONSTRUCTION
const string CREATED_TIME
Time (UTC) when this table or view was created.
const string HASH
Using hash partitioning.
const string COMPRESSION_CODEC
Default compression codec for the table.
const string PARTITION_TYPE
Partitioning scheme used for this table.
const string NONE
Using no partitioning.
long total_size
If GET_SIZES is TRUE, the sum of the elements of sizes.
const string MATERIALIZED_EXTERNAL_TABLE
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 RESULT_TABLE
IList< IDictionary< string, string > > additional_info
Additional information about the respective tables in table_names.
const string DISK
On-disk primary key.
string table_name
Value of table_name.
const string NO_ERROR_IF_NOT_EXISTS
If FALSE will return an error if the provided table_name does not exist.
const string OWNER_RESOURCE_GROUP
Name of the owner resource group.
const string LAST_ALTER_BY
User that last altered this table or view.
const string PARTITION_DEFINITIONS
Comma-separated list of partition definitions, whose format depends on the partition_type.
const string SKIP_TEMP_SCHEMAS
If TRUE then the table list will not include tables from SYS_TEMP and other system temporary schemas.
const string NEXT_REFRESH_TIME
For materialized view with periodic refresh_method a datetime string indicating the next time the vie...
const string LAST_WRITE_TIME
Time (UTC) when this table was last written.
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 SERIES
Using series partitioning.
A set of string constants for the parameter options.
IList< string > type_labels
Type labels of the respective tables in table_names.
const string MATERIALIZED_VIEW