ShowTableResponse.AdditionalInfo (Kinetica Java API 7.0.19.0 API)

java.lang.Object
- com.gpudb.protocol.ShowTableResponse.AdditionalInfo

Enclosing class:

ShowTableResponse
```
public static final class ShowTableResponse.AdditionalInfo
extends Object
```
Additional information about the respective tables in tableNames. Supported values:
A set of string constants for the parameter additionalInfo.

Field Summary

Fields
Modifier and Type	Field and Description
`static String`	`ALTERNATE_SHARD_KEYS` Semicolon-separated list of shard keys that were equated in joins (applicable for join tables).
`static String`	`ATTRIBUTE_INDEXES` Semicolon-separated list of columns that have indexes.
`static String`	`COLLECTION_NAMES` The names of the collections this table is part of.
`static String`	`COLUMN_INFO` JSON-encoded string representing a map of column name to information including memory usage if if the `get_column_info` option is `true`.
`static String`	`COMPRESSED_COLUMNS` Semicolon-separated list of compressed columns with the corresponding compression type for each; e.g.: {first_name,snappy};{last_name,lz4hc}.
`static String`	`CREATE_PROJECTION`
`static String`	`CREATE_TABLE`
`static String`	`CREATE_UNION`
`static String`	`FALSE`
`static String`	`FOREIGN_KEYS` Semicolon-separated list of foreign keys, of the format 'source_column references target_table(primary_key_column)'.
`static String`	`FOREIGN_SHARD_KEY` Foreign shard key description of the format: 'fk_foreign_key references pk_column_name from pk_table_name(pk_primary_key)'.
`static String`	`GLOBAL_ACCESS_MODE` Returns the global access mode (i.e.
`static String`	`INTERVAL` Using interval partitioning
`static String`	`IS_AUTOMATIC_PARTITION` True if partitions will be created for LIST VALUES which don't fall into existing partitions.
`static String`	`IS_DIRTY` True if some input table of the materialized view that affects this member table has been modified since the last refresh.
`static String`	`IS_VIEW_PERSISTED` True if the view named view_table_name is persisted - reported for each view member.
`static String`	`LAST_REFRESH_TIME` For materialized view the a datatime string indicating the last time the view was refreshed.
`static String`	`LIST` Using manual list partitioning
`static String`	`NEXT_REFRESH_TIME` For materialized view with periodic refresh_method a datetime string indicating the next time the view is to be refreshed.
`static String`	`NO_ACCESS` No read/write operations are allowed on this table.
`static String`	`NONE` Using no partitioning
`static String`	`PARTITION_DEFINITIONS` Comma-separated list of partition definitions, whose format depends on the partition_type.
`static String`	`PARTITION_KEYS` Comma-separated list of partition keys.
`static String`	`PARTITION_TYPE` Partitioning scheme used for this table Supported values: `RANGE`: Using range partitioning `INTERVAL`: Using interval partitioning `LIST`: Using manual list partitioning `NONE`: Using no partitioning The default value is `NONE`.
`static String`	`PROTECTED` Indicates whether the respective table is protected or not.
`static String`	`RANGE` Using range partitioning
`static String`	`READ_ONLY` Only read operations are allowed on this table.
`static String`	`READ_WRITE` All read/write operations are allowed on this table.
`static String`	`RECORD_BYTES` The number of in-memory bytes per record which is the sum of the byte sizes of all columns with property 'data'.
`static String`	`REFRESH_METHOD` For materialized view current refresh_method - one of manual, periodic, on_change.
`static String`	`REFRESH_PERIOD` For materialized view with periodic refresh_method the current refresh period in seconds.
`static String`	`REFRESH_START_TIME` For materialized view with periodic refresh_method the current intial datetime string that periodic refreshes began.
`static String`	`REMAINING_TABLE_TTL` The remaining time-to-live, in minutes, before the respective table expires (-1 if it will never expire).
`static String`	`REQUEST_AVRO_JSON` The JSON representation of request creating this table.
`static String`	`REQUEST_AVRO_TYPE` Method by which this table was created.
`static String`	`TABLE_TTL` The value of the time-to-live setting.
`static String`	`TRUE`
`static String`	`USER_CHUNK_SIZE` User-specified number of records per chunk, if provided at table creation time.
`static String`	`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.
`static String`	`WRITE_ONLY` Only write operations are allowed on this table.

Method Summary
- Methods inherited from class java.lang.Object
  clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - REQUEST_AVRO_TYPE
```
public static final String REQUEST_AVRO_TYPE
```
    Method by which this table was created. Supported values:
    See Also:
    
    Constant Field Values
  - CREATE_TABLE
```
public static final String CREATE_TABLE
```
    See Also:
    
    Constant Field Values
  - CREATE_PROJECTION
```
public static final String CREATE_PROJECTION
```
    See Also:
    
    Constant Field Values
  - CREATE_UNION
```
public static final String CREATE_UNION
```
    See Also:
    
    Constant Field Values
  - REQUEST_AVRO_JSON
```
public static final String REQUEST_AVRO_JSON
```
    The JSON representation of request creating this table. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - PROTECTED
```
public static final String PROTECTED
```
    Indicates whether the respective table is protected or not. Supported values:
    - TRUE
    - FALSE
    See Also:
    
    Constant Field Values
  - TRUE
```
public static final String TRUE
```
    See Also:
    
    Constant Field Values
  - FALSE
```
public static final String FALSE
```
    See Also:
    
    Constant Field Values
  - RECORD_BYTES
```
public static final String RECORD_BYTES
```
    The number of in-memory bytes per record which is the sum of the byte sizes of all columns with property 'data'.
    
    See Also:
    
    Constant Field Values
  - COLLECTION_NAMES
```
public static final String COLLECTION_NAMES
```
    The names of the collections this table is part of. Only set if table is part of a collection
    
    See Also:
    
    Constant Field Values
  - TABLE_TTL
```
public static final String TABLE_TTL
```
    The value of the time-to-live setting. Not present for collections.
    
    See Also:
    
    Constant Field Values
  - REMAINING_TABLE_TTL
```
public static final String REMAINING_TABLE_TTL
```
    The remaining time-to-live, in minutes, before the respective table expires (-1 if it will never expire). Not present for collections.
    
    See Also:
    
    Constant Field Values
  - FOREIGN_KEYS
```
public static final String FOREIGN_KEYS
```
    Semicolon-separated list of foreign keys, of the format 'source_column references target_table(primary_key_column)'. Not present for collections. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - FOREIGN_SHARD_KEY
```
public static final String 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 collections. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - PARTITION_TYPE
```
public static final String PARTITION_TYPE
```
    Partitioning scheme used for this table Supported values:
    - RANGE: Using range partitioning
    - INTERVAL: Using interval partitioning
    - LIST: Using manual list partitioning
    - NONE: Using no partitioning
    The default value is NONE.
    See Also:
    
    Constant Field Values
  - RANGE
```
public static final String RANGE
```
    Using range partitioning
    
    See Also:
    
    Constant Field Values
  - INTERVAL
```
public static final String INTERVAL
```
    Using interval partitioning
    
    See Also:
    
    Constant Field Values
  - LIST
```
public static final String LIST
```
    Using manual list partitioning
    
    See Also:
    
    Constant Field Values
  - NONE
```
public static final String NONE
```
    Using no partitioning
    
    See Also:
    
    Constant Field Values
  - PARTITION_KEYS
```
public static final String PARTITION_KEYS
```
    Comma-separated list of partition keys. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - PARTITION_DEFINITIONS
```
public static final String PARTITION_DEFINITIONS
```
    Comma-separated list of partition definitions, whose format depends on the partition_type. See partitioning documentation for details. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - IS_AUTOMATIC_PARTITION
```
public static final String IS_AUTOMATIC_PARTITION
```
    True if partitions will be created for LIST VALUES which don't fall into existing partitions. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - ATTRIBUTE_INDEXES
```
public static final String ATTRIBUTE_INDEXES
```
    Semicolon-separated list of columns that have indexes. Not present for collections. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - COMPRESSED_COLUMNS
```
public static final String COMPRESSED_COLUMNS
```
    Semicolon-separated list of compressed columns with the corresponding compression type for each; e.g.: {first_name,snappy};{last_name,lz4hc}. Not present for collections. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - COLUMN_INFO
```
public static final String COLUMN_INFO
```
    JSON-encoded string representing a map of column name to information including memory usage if if the get_column_info option is true. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - GLOBAL_ACCESS_MODE
```
public static final String GLOBAL_ACCESS_MODE
```
    Returns the global access mode (i.e. lock status) for the table. Supported values:
    - NO_ACCESS: No read/write operations are allowed on this table.
    - READ_ONLY: Only read operations are allowed on this table.
    - WRITE_ONLY: Only write operations are allowed on this table.
    - READ_WRITE: All read/write operations are allowed on this table.
    See Also:
    
    Constant Field Values
  - NO_ACCESS
```
public static final String NO_ACCESS
```
    No read/write operations are allowed on this table.
    
    See Also:
    
    Constant Field Values
  - READ_ONLY
```
public static final String READ_ONLY
```
    Only read operations are allowed on this table.
    
    See Also:
    
    Constant Field Values
  - WRITE_ONLY
```
public static final String WRITE_ONLY
```
    Only write operations are allowed on this table.
    
    See Also:
    
    Constant Field Values
  - READ_WRITE
```
public static final String READ_WRITE
```
    All read/write operations are allowed on this table.
    
    See Also:
    
    Constant Field Values
  - VIEW_TABLE_NAME
```
public static final String 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 ''.
    
    See Also:
    
    Constant Field Values
  - IS_VIEW_PERSISTED
```
public static final String 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 ''.
    
    See Also:
    
    Constant Field Values
  - IS_DIRTY
```
public static final String 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 ''.
    
    See Also:
    
    Constant Field Values
  - REFRESH_METHOD
```
public static final String REFRESH_METHOD
```
    For materialized view current refresh_method - one of manual, periodic, on_change. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - REFRESH_START_TIME
```
public static final String REFRESH_START_TIME
```
    For materialized view with periodic refresh_method the current intial datetime string that periodic refreshes began. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - REFRESH_PERIOD
```
public static final String REFRESH_PERIOD
```
    For materialized view with periodic refresh_method the current refresh period in seconds. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - LAST_REFRESH_TIME
```
public static final String LAST_REFRESH_TIME
```
    For materialized view the a datatime string indicating the last time the view was refreshed. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - NEXT_REFRESH_TIME
```
public static final String 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 ''.
    
    See Also:
    
    Constant Field Values
  - USER_CHUNK_SIZE
```
public static final String USER_CHUNK_SIZE
```
    User-specified number of records per chunk, if provided at table creation time. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - ALTERNATE_SHARD_KEYS
```
public static final String ALTERNATE_SHARD_KEYS
```
    Semicolon-separated list of shard keys that were equated in joins (applicable for join tables). The default value is ''.
    
    See Also:
    
    Constant Field Values

Class ShowTableResponse.AdditionalInfo

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

REQUEST_AVRO_TYPE

CREATE_TABLE

CREATE_PROJECTION

CREATE_UNION

REQUEST_AVRO_JSON

PROTECTED

TRUE

FALSE

RECORD_BYTES

COLLECTION_NAMES

TABLE_TTL

REMAINING_TABLE_TTL

FOREIGN_KEYS

FOREIGN_SHARD_KEY

PARTITION_TYPE

RANGE

INTERVAL

LIST

NONE

PARTITION_KEYS

PARTITION_DEFINITIONS

IS_AUTOMATIC_PARTITION

ATTRIBUTE_INDEXES

COMPRESSED_COLUMNS

COLUMN_INFO

GLOBAL_ACCESS_MODE

NO_ACCESS

READ_ONLY

WRITE_ONLY

READ_WRITE

VIEW_TABLE_NAME

IS_VIEW_PERSISTED

IS_DIRTY

REFRESH_METHOD

REFRESH_START_TIME

REFRESH_PERIOD

LAST_REFRESH_TIME

NEXT_REFRESH_TIME

USER_CHUNK_SIZE

ALTERNATE_SHARD_KEYS