Kinetica C# API
Version 7.1.10.0
|
Additional information about the respective tables in <member name="table_names">. More...
Public Attributes | |
const string | REQUEST_AVRO_TYPE = "request_avro_type" |
Method by which this table was created. More... | |
const string | CREATE_TABLE = "create_table" |
const string | CREATE_PROJECTION = "create_projection" |
const string | CREATE_UNION = "create_union" |
const string | REQUEST_AVRO_JSON = "request_avro_json" |
The JSON representation of request creating this table. More... | |
const string | PROTECTED = "protected" |
No longer used. More... | |
const string | TRUE = "true" |
const string | FALSE = "false" |
const string | RECORD_BYTES = "record_bytes" |
The number of in-memory bytes per record which is the sum of the byte sizes of all columns with property 'data'. More... | |
const string | TOTAL_BYTES = "total_bytes" |
The total size in bytes of all data stored in the table. More... | |
const string | COLLECTION_NAMES = "collection_names" |
[DEPRECATED–use schema_name instead] This will now contain the name of the schema for the table. More... | |
const string | SCHEMA_NAME = "schema_name" |
The name of the schema for the table. More... | |
const string | TABLE_TTL = "table_ttl" |
The value of the time-to-live setting. More... | |
const string | REMAINING_TABLE_TTL = "remaining_table_ttl" |
The remaining time-to-live, in minutes, before the respective table expires (-1 if it will never expire). More... | |
const string | FOREIGN_KEYS = "foreign_keys" |
Semicolon-separated list of foreign keys, of the format 'source_column references target_table(primary_key_column)'. More... | |
const string | FOREIGN_SHARD_KEY = "foreign_shard_key" |
Foreign shard key description of the format: <fk_foreign_key> references <pk_column_name> from <pk_table_name>(<pk_primary_key>). More... | |
const string | PARTITION_TYPE = "partition_type" |
Partitioning scheme used for this table Supported values:
| |
const string | RANGE = "RANGE" |
Using range partitioning More... | |
const string | INTERVAL = "INTERVAL" |
Using interval partitioning More... | |
const string | LIST = "LIST" |
Using manual list partitioning More... | |
const string | HASH = "HASH" |
Using hash partitioning. More... | |
const string | SERIES = "SERIES" |
Using series partitioning. More... | |
const string | NONE = "NONE" |
Using no partitioning More... | |
const string | PARTITION_KEYS = "partition_keys" |
Comma-separated list of partition keys. More... | |
const string | PARTITION_DEFINITIONS = "partition_definitions" |
Comma-separated list of partition definitions, whose format depends on the partition_type. More... | |
const string | IS_AUTOMATIC_PARTITION = "is_automatic_partition" |
True if partitions will be created for LIST VALUES which don't fall into existing partitions. More... | |
const string | ATTRIBUTE_INDEXES = "attribute_indexes" |
Semicolon-separated list of indexes. More... | |
const string | COMPRESSED_COLUMNS = "compressed_columns" |
No longer supported. More... | |
const string | COLUMN_INFO = "column_info" |
JSON-encoded string representing a map of column name to information including memory usage if the get_column_info option is true. More... | |
const string | GLOBAL_ACCESS_MODE = "global_access_mode" |
Returns the global access mode (i.e. More... | |
const string | NO_ACCESS = "no_access" |
No read/write operations are allowed on this table. More... | |
const string | READ_ONLY = "read_only" |
Only read operations are allowed on this table. More... | |
const string | WRITE_ONLY = "write_only" |
Only write operations are allowed on this table. More... | |
const string | READ_WRITE = "read_write" |
All read/write operations are allowed on this table. More... | |
const string | VIEW_TABLE_NAME = "view_table_name" |
For materialized view the name of the view this member table is part of - if same as the table_name then this is the root of the view. More... | |
const string | IS_VIEW_PERSISTED = "is_view_persisted" |
True if the view named view_table_name is persisted - reported for each view member. More... | |
const string | IS_DIRTY = "is_dirty" |
True if some input table of the materialized view that affects this member table has been modified since the last refresh. More... | |
const string | REFRESH_METHOD = "refresh_method" |
For materialized view current refresh_method - one of manual, periodic, on_change. More... | |
const string | REFRESH_START_TIME = "refresh_start_time" |
For materialized view with periodic refresh_method the current intial datetime string that periodic refreshes began. More... | |
const string | REFRESH_STOP_TIME = "refresh_stop_time" |
Time at which the periodic view refresh stops. More... | |
const string | REFRESH_PERIOD = "refresh_period" |
For materialized view with periodic refresh_method the current refresh period in seconds. More... | |
const string | LAST_REFRESH_TIME = "last_refresh_time" |
For materialized view the a datatime string indicating the last time the view was refreshed. More... | |
const string | NEXT_REFRESH_TIME = "next_refresh_time" |
For materialized view with periodic refresh_method a datetime string indicating the next time the view is to be refreshed. More... | |
const string | USER_CHUNK_SIZE = "user_chunk_size" |
User-specified number of records per chunk, if provided at table creation time. More... | |
const string | OWNER_RESOURCE_GROUP = "owner_resource_group" |
Name of the owner resource group. More... | |
const string | ALTERNATE_SHARD_KEYS = "alternate_shard_keys" |
Semicolon-separated list of shard keys that were equated in joins (applicable for join tables). More... | |
const string | DATASOURCE_SUBSCRIPTIONS = "datasource_subscriptions" |
Semicolon-separated list of datasource names the table has subscribed to. More... | |
Additional information about the respective tables in <member name="table_names">.
Supported values:
set of string constants for the parameter <member name="additional_info">.
Definition at line 673 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.ALTERNATE_SHARD_KEYS = "alternate_shard_keys" |
Semicolon-separated list of shard keys that were equated in joins (applicable for join tables).
The default value is ''.
Definition at line 977 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.ATTRIBUTE_INDEXES = "attribute_indexes" |
Semicolon-separated list of indexes.
For column (attribute) indexes, only the indexed column name will be listed. For other index types, the index type will be listed with the colon-delimited indexed column(s) using the form: <index_type><column_list>. Not present for schemas. The default value is ''.
Definition at line 861 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.COLLECTION_NAMES = "collection_names" |
[DEPRECATED–use schema_name instead] This will now contain the name of the schema for the table.
There can only be one schema for a table.
Definition at line 730 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.COLUMN_INFO = "column_info" |
JSON-encoded string representing a map of column name to information including memory usage if the get_column_info option is true.
The default value is ''.
Definition at line 871 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.COMPRESSED_COLUMNS = "compressed_columns" |
const string kinetica.ShowTableResponse.AdditionalInfo.CREATE_PROJECTION = "create_projection" |
Definition at line 694 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.CREATE_TABLE = "create_table" |
Definition at line 693 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.CREATE_UNION = "create_union" |
Definition at line 695 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.DATASOURCE_SUBSCRIPTIONS = "datasource_subscriptions" |
Semicolon-separated list of datasource names the table has subscribed to.
The default value is ''.
Definition at line 981 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.FALSE = "false" |
Definition at line 716 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.FOREIGN_KEYS = "foreign_keys" |
Semicolon-separated list of foreign keys, of the format 'source_column references target_table(primary_key_column)'.
Not present for schemas. The default value is ''.
Definition at line 752 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.FOREIGN_SHARD_KEY = "foreign_shard_key" |
Foreign shard key description of the format: <fk_foreign_key> references <pk_column_name> from <pk_table_name>(<pk_primary_key>).
Not present for schemas. The default value is ''.
Definition at line 758 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.GLOBAL_ACCESS_MODE = "global_access_mode" |
Returns the global access mode (i.e.
lock status) for the table. Supported values:
Definition at line 902 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.HASH = "HASH" |
Using hash partitioning.
Definition at line 827 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.INTERVAL = "INTERVAL" |
Using interval partitioning
Definition at line 817 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.IS_AUTOMATIC_PARTITION = "is_automatic_partition" |
True if partitions will be created for LIST VALUES which don't fall into existing partitions.
The default value is ''.
Definition at line 851 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.IS_DIRTY = "is_dirty" |
True if some input table of the materialized view that affects this member table has been modified since the last refresh.
The default value is ''.
Definition at line 934 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.IS_VIEW_PERSISTED = "is_view_persisted" |
True if the view named view_table_name is persisted - reported for each view member.
Means method of recreating this member is saved - not the members data. The default value is ''.
Definition at line 929 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.LAST_REFRESH_TIME = "last_refresh_time" |
For materialized view the a datatime string indicating the last time the view was refreshed.
The default value is ''.
Definition at line 958 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.LIST = "LIST" |
Using manual list partitioning
Definition at line 822 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.NEXT_REFRESH_TIME = "next_refresh_time" |
For materialized view with periodic refresh_method a datetime string indicating the next time the view is to be refreshed.
The default value is ''.
Definition at line 963 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.NO_ACCESS = "no_access" |
No read/write operations are allowed on this table.
Definition at line 906 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.NONE = "NONE" |
Using no partitioning
Definition at line 835 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.OWNER_RESOURCE_GROUP = "owner_resource_group" |
Name of the owner resource group.
The default value is ''.
Definition at line 972 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.PARTITION_DEFINITIONS = "partition_definitions" |
Comma-separated list of partition definitions, whose format depends on the partition_type.
See partitioning documentation for details. The default value is ''.
Definition at line 846 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.PARTITION_KEYS = "partition_keys" |
Comma-separated list of partition keys.
The default value is ''.
Definition at line 839 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.PARTITION_TYPE = "partition_type" |
Partitioning scheme used for this table Supported values:
SERIES: Using series partitioning. NONE: Using no partitioning
The default value is NONE.
Definition at line 807 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.PROTECTED = "protected" |
No longer used.
Indicated whether the respective table was protected or not. Supported values:
Definition at line 714 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.RANGE = "RANGE" |
Using range partitioning
Definition at line 812 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.READ_ONLY = "read_only" |
Only read operations are allowed on this table.
Definition at line 910 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.READ_WRITE = "read_write" |
All read/write operations are allowed on this table.
Definition at line 918 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.RECORD_BYTES = "record_bytes" |
The number of in-memory bytes per record which is the sum of the byte sizes of all columns with property 'data'.
Definition at line 721 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.REFRESH_METHOD = "refresh_method" |
For materialized view current refresh_method - one of manual, periodic, on_change.
The default value is ''.
Definition at line 939 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.REFRESH_PERIOD = "refresh_period" |
For materialized view with periodic refresh_method the current refresh period in seconds.
The default value is ''.
Definition at line 953 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.REFRESH_START_TIME = "refresh_start_time" |
For materialized view with periodic refresh_method the current intial datetime string that periodic refreshes began.
The default value is ''.
Definition at line 944 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.REFRESH_STOP_TIME = "refresh_stop_time" |
Time at which the periodic view refresh stops.
The default value is ''.
Definition at line 948 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.REMAINING_TABLE_TTL = "remaining_table_ttl" |
The remaining time-to-live, in minutes, before the respective table expires (-1 if it will never expire).
Not present for schemas.
Definition at line 745 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.REQUEST_AVRO_JSON = "request_avro_json" |
The JSON representation of request creating this table.
The default value is ''.
Definition at line 699 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.REQUEST_AVRO_TYPE = "request_avro_type" |
Method by which this table was created.
Supported values:
Definition at line 692 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.SCHEMA_NAME = "schema_name" |
The name of the schema for the table.
There can only be one schema for a table.
Definition at line 734 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.SERIES = "SERIES" |
Using series partitioning.
Definition at line 832 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.TABLE_TTL = "table_ttl" |
The value of the time-to-live setting.
Not present for schemas.
Definition at line 739 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.TOTAL_BYTES = "total_bytes" |
The total size in bytes of all data stored in the table.
Definition at line 725 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.TRUE = "true" |
Definition at line 715 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.USER_CHUNK_SIZE = "user_chunk_size" |
User-specified number of records per chunk, if provided at table creation time.
The default value is ''.
Definition at line 968 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.VIEW_TABLE_NAME = "view_table_name" |
For materialized view the name of the view this member table is part of - if same as the table_name then this is the root of the view.
The default value is ''.
Definition at line 923 of file ShowTable.cs.
const string kinetica.ShowTableResponse.AdditionalInfo.WRITE_ONLY = "write_only" |
Only write operations are allowed on this table.
Definition at line 914 of file ShowTable.cs.