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

Enclosing class:

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

Field Summary

Fields
Modifier and Type	Field	Description
`static String`	`ALTER_COUNT`	Count of times this table or view was altered.
`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 indexes.
`static String`	`COLLECTION_NAMES`	[DEPRECATED--use schema_name instead] This will now contain the name of the schema for the table.
`static String`	`COLUMN_INFO`	JSON-encoded string representing a map of column name to information including memory usage if the `GET_COLUMN_INFO` option is `TRUE`.
`static String`	`COMPRESSION_CODEC`	Default compression codec for the table.
`static String`	`CREATE_PROJECTION`
`static String`	`CREATE_TABLE`
`static String`	`CREATE_UNION`
`static String`	`CREATED_BY`	User that created this table or view.
`static String`	`CREATED_TIME`	Time (UTC) when this table or view was created.
`static String`	`DATASOURCE_SUBSCRIPTIONS`	Semicolon-separated list of datasource names the table has subscribed to.
`static String`	`DISK`	On-disk primary key
`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. lock status) for the table.
`static String`	`HASH`	Using hash partitioning.
`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_ALTER_BY`	User that last altered this table or view.
`static String`	`LAST_ALTER_TIME`	Time (UTC) when this table or view was last altered.
`static String`	`LAST_READ_BY`	User that last read this table or view.
`static String`	`LAST_READ_TIME`	Time (UTC) when this table or view was last read.
`static String`	`LAST_REFRESH_TIME`	For materialized view the datetime string indicating the last time the view was refreshed.
`static String`	`LAST_WRITE_BY`	User that last wrote to this table.
`static String`	`LAST_WRITE_TIME`	Time (UTC) when this table was last written.
`static String`	`LIST`	Using manual list partitioning
`static String`	`MEMORY`	In-memory primary key
`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`	`NULL_MODIFYING_COLUMNS`	Comma-separated list of null modifying column names.
`static String`	`OWNER_RESOURCE_GROUP`	Name of the owner resource group.
`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.
`static String`	`PRIMARY_KEY_TYPE`	The primary key type of the table (if it has a primary key).
`static String`	`PROTECTED`	No longer used.
`static String`	`RANGE`	Using range partitioning
`static String`	`READ_COUNT`	Count of times this table or view was read.
`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 initial datetime string that periodic refreshes began.
`static String`	`REFRESH_STOP_TIME`	Time at which the periodic view refresh stops.
`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`	`SCHEMA_NAME`	The name of the schema for the table.
`static String`	`SERIES`	Using series partitioning.
`static String`	`TABLE_TTL`	The value of the time-to-live setting.
`static String`	`TOTAL_BYTES`	The total size in bytes of all data stored in the table.
`static String`	`TRUE`
`static String`	`USER_CHUNK_COLUMN_MAX_MEMORY`	User-specified target max bytes per column in a chunk, if provided at table creation time.
`static String`	`USER_CHUNK_MAX_MEMORY`	User-specified target max bytes for all columns in a chunk, if provided at table creation time.
`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_COUNT`	Count of times this table was written.
`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:
    
    CREATE_TABLE
    CREATE_PROJECTION
    CREATE_UNION
    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
```
    No longer used. Indicated whether the respective table was 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
  - TOTAL_BYTES
```
public static final String TOTAL_BYTES
```
    The total size in bytes of all data stored in the table.
    
    See Also:
    
    Constant Field Values
  - COLLECTION_NAMES
```
public static final String 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.
    
    See Also:
    
    Constant Field Values
  - SCHEMA_NAME
```
public static final String SCHEMA_NAME
```
    The name of the schema for the table. There can only be one schema for a table.
    
    See Also:
    
    Constant Field Values
  - TABLE_TTL
```
public static final String TABLE_TTL
```
    The value of the time-to-live setting. Not present for schemas.
    
    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 schemas.
    
    See Also:
    
    Constant Field Values
  - PRIMARY_KEY_TYPE
```
public static final String PRIMARY_KEY_TYPE
```
    The primary key type of the table (if it has a primary key). Supported values:
    
    MEMORY: In-memory primary key
    DISK: On-disk primary key
    See Also:
    
    Constant Field Values
  - MEMORY
```
public static final String MEMORY
```
    In-memory primary key
    
    See Also:
    
    Constant Field Values
  - DISK
```
public static final String DISK
```
    On-disk primary key
    
    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 schemas. 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 schemas. 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
    HASH: Using hash partitioning.
    SERIES: Using series 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
  - HASH
```
public static final String HASH
```
    Using hash partitioning.
    
    See Also:
    
    Constant Field Values
  - SERIES
```
public static final String SERIES
```
    Using series 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 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) and the comma-delimited index option(s) using the form: <index_type>@<column_list>@<column_options>. Not present for schemas. 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 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 initial datetime string that periodic refreshes began. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - REFRESH_STOP_TIME
```
public static final String REFRESH_STOP_TIME
```
    Time at which the periodic view refresh stops. 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 datetime 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
  - USER_CHUNK_COLUMN_MAX_MEMORY
```
public static final String USER_CHUNK_COLUMN_MAX_MEMORY
```
    User-specified target max bytes per column in a chunk, if provided at table creation time. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - USER_CHUNK_MAX_MEMORY
```
public static final String USER_CHUNK_MAX_MEMORY
```
    User-specified target max bytes for all columns in a chunk, if provided at table creation time. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - OWNER_RESOURCE_GROUP
```
public static final String OWNER_RESOURCE_GROUP
```
    Name of the owner resource group. 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
  - DATASOURCE_SUBSCRIPTIONS
```
public static final String DATASOURCE_SUBSCRIPTIONS
```
    Semicolon-separated list of datasource names the table has subscribed to. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - NULL_MODIFYING_COLUMNS
```
public static final String NULL_MODIFYING_COLUMNS
```
    Comma-separated list of null modifying column names. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - COMPRESSION_CODEC
```
public static final String COMPRESSION_CODEC
```
    Default compression codec for the table. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - CREATED_BY
```
public static final String CREATED_BY
```
    User that created this table or view. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - CREATED_TIME
```
public static final String CREATED_TIME
```
    Time (UTC) when this table or view was created. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - LAST_READ_BY
```
public static final String LAST_READ_BY
```
    User that last read this table or view. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - LAST_READ_TIME
```
public static final String LAST_READ_TIME
```
    Time (UTC) when this table or view was last read. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - READ_COUNT
```
public static final String READ_COUNT
```
    Count of times this table or view was read. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - LAST_WRITE_BY
```
public static final String LAST_WRITE_BY
```
    User that last wrote to this table. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - LAST_WRITE_TIME
```
public static final String LAST_WRITE_TIME
```
    Time (UTC) when this table was last written. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - WRITE_COUNT
```
public static final String WRITE_COUNT
```
    Count of times this table was written. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - LAST_ALTER_BY
```
public static final String LAST_ALTER_BY
```
    User that last altered this table or view. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - LAST_ALTER_TIME
```
public static final String LAST_ALTER_TIME
```
    Time (UTC) when this table or view was last altered. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - ALTER_COUNT
```
public static final String ALTER_COUNT
```
    Count of times this table or view was altered. 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

TOTAL_BYTES

COLLECTION_NAMES

SCHEMA_NAME

TABLE_TTL

REMAINING_TABLE_TTL

PRIMARY_KEY_TYPE

MEMORY

DISK

FOREIGN_KEYS

FOREIGN_SHARD_KEY

PARTITION_TYPE

RANGE

INTERVAL

LIST

HASH

SERIES

NONE

PARTITION_KEYS

PARTITION_DEFINITIONS

IS_AUTOMATIC_PARTITION

ATTRIBUTE_INDEXES

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_STOP_TIME

REFRESH_PERIOD

LAST_REFRESH_TIME

NEXT_REFRESH_TIME

USER_CHUNK_SIZE

USER_CHUNK_COLUMN_MAX_MEMORY

USER_CHUNK_MAX_MEMORY

OWNER_RESOURCE_GROUP

ALTERNATE_SHARD_KEYS

DATASOURCE_SUBSCRIPTIONS

NULL_MODIFYING_COLUMNS

COMPRESSION_CODEC

CREATED_BY

CREATED_TIME

LAST_READ_BY

LAST_READ_TIME

READ_COUNT

LAST_WRITE_BY

LAST_WRITE_TIME

WRITE_COUNT

LAST_ALTER_BY

LAST_ALTER_TIME

ALTER_COUNT