Skip to main content

Class ShowTableResponse.AdditionalInfo

java.lang.Object
com.gpudb.protocol.ShowTableResponse.AdditionalInfo
Enclosing class:

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 Details

    • REQUEST_AVRO_TYPE

      public static final String REQUEST_AVRO_TYPE
      Method by which this table was created. Supported values:
    • CREATE_TABLE

      public static final String CREATE_TABLE
    • CREATE_PROJECTION

      public static final String CREATE_PROJECTION
    • CREATE_UNION

      public static final String CREATE_UNION
    • REQUEST_AVRO_JSON

      public static final String REQUEST_AVRO_JSON
      The JSON representation of request creating this table. The default value is ”.
    • PROTECTED

      public static final String PROTECTED
      No longer used. Indicated whether the respective table was protected or not. Supported values:
    • TRUE

      public static final String TRUE
    • FALSE

      public static final String FALSE
    • 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’.
    • TOTAL_BYTES

      public static final String TOTAL_BYTES
      The total size in bytes of all data stored in the table.
    • 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.
    • 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.
    • TABLE_TTL

      public static final String TABLE_TTL
      The value of the time-to-live setting. Not present for schemas.
    • 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.
    • 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.
    • MEMORY

      public static final String MEMORY
      In-memory primary key.
    • DISK

      public static final String DISK
      On-disk primary key.
    • 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 ”.
    • 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 ”.
    • PARTITION_TYPE

      public static final String PARTITION_TYPE
      Partitioning scheme used for this table. Supported values:The default value is NONE.
    • RANGE

      public static final String RANGE
    • INTERVAL

      public static final String INTERVAL
    • LIST

      public static final String LIST
    • HASH

      public static final String HASH
    • SERIES

      public static final String SERIES
    • NONE

      public static final String NONE
      Using no partitioning.
    • PARTITION_KEYS

      public static final String PARTITION_KEYS
      Comma-separated list of partition keys. The default value is ”.
    • 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 ”.
    • 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 ”.
    • 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 ”.
    • 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 ”.
    • 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.
    • NO_ACCESS

      public static final String NO_ACCESS
      No read/write operations are allowed on this table.
    • READ_ONLY

      public static final String READ_ONLY
      Only read operations are allowed on this table.
    • WRITE_ONLY

      public static final String WRITE_ONLY
      Only write operations are allowed on this table.
    • READ_WRITE

      public static final String READ_WRITE
      All read/write operations are allowed on this table.
    • 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 ”.
    • 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 ”.
    • 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 ”.
    • REFRESH_METHOD

      public static final String REFRESH_METHOD
      For materialized view current refresh_method - one of manual, periodic, on_change. The default value is ”.
    • 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 ”.
    • REFRESH_STOP_TIME

      public static final String REFRESH_STOP_TIME
      Time at which the periodic view refresh stops. The default value is ”.
    • 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 ”.
    • 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 ”.
    • 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 ”.
    • 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 ”.
    • 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 ”.
    • 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 ”.
    • OWNER_RESOURCE_GROUP

      public static final String OWNER_RESOURCE_GROUP
      Name of the owner resource group. The default value is ”.
    • 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 ”.
    • DATASOURCE_SUBSCRIPTIONS

      public static final String DATASOURCE_SUBSCRIPTIONS
      Semicolon-separated list of datasource names the table has subscribed to. The default value is ”.
    • NULL_MODIFYING_COLUMNS

      public static final String NULL_MODIFYING_COLUMNS
      Comma-separated list of null modifying column names. The default value is ”.
    • COMPRESSION_CODEC

      public static final String COMPRESSION_CODEC
      Default compression codec for the table. The default value is ”.
    • CREATED_BY

      public static final String CREATED_BY
      User that created this table or view. The default value is ”.
    • CREATED_TIME

      public static final String CREATED_TIME
      Time (UTC) when this table or view was created. The default value is ”.
    • LAST_READ_BY

      public static final String LAST_READ_BY
      User that last read this table or view. The default value is ”.
    • LAST_READ_TIME

      public static final String LAST_READ_TIME
      Time (UTC) when this table or view was last read. The default value is ”.
    • READ_COUNT

      public static final String READ_COUNT
      Count of times this table or view was read. The default value is ”.
    • LAST_WRITE_BY

      public static final String LAST_WRITE_BY
      User that last wrote to this table. The default value is ”.
    • LAST_WRITE_TIME

      public static final String LAST_WRITE_TIME
      Time (UTC) when this table was last written. The default value is ”.
    • WRITE_COUNT

      public static final String WRITE_COUNT
      Count of times this table was written. The default value is ”.
    • LAST_ALTER_BY

      public static final String LAST_ALTER_BY
      User that last altered this table or view. The default value is ”.
    • LAST_ALTER_TIME

      public static final String LAST_ALTER_TIME
      Time (UTC) when this table or view was last altered. The default value is ”.
    • ALTER_COUNT

      public static final String ALTER_COUNT
      Count of times this table or view was altered. The default value is ”.