com.gpudb.protocol

Class CreateMaterializedViewRequest.Options

java.lang.Object

com.gpudb.protocol.CreateMaterializedViewRequest.Options

Enclosing class:

CreateMaterializedViewRequest

public static final class CreateMaterializedViewRequest.Options
extends Object

Optional parameters.

• COLLECTION_NAME: [DEPRECATED--please specify the containing schema for the materialized view as part of tableName and use GPUdb.createSchema(CreateSchemaRequest) to create the schema if non-existent] Name of a schema which is to contain the newly created view. If the schema provided is non-existent, it will be automatically created.
• EXECUTE_AS: User name to use to run the refresh job
• PERSIST: If true, then the materialized view specified in tableName will be persisted and will not expire unless a ttl is specified. If false, then the materialized view will be an in-memory table and will expire unless a ttl is specified otherwise. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.
• REFRESH_SPAN: Sets the future time-offset(in seconds) at which periodic refresh stops
• REFRESH_STOP_TIME: When refresh_method is periodic, specifies the time at which a periodic refresh is stopped. Value is a datetime string with format 'YYYY-MM-DD HH:MM:SS'.
• REFRESH_METHOD: Method by which the join can be refreshed when the data in underlying member tables have changed. Supported values:
  • MANUAL: Refresh only occurs when manually requested by calling GPUdb.alterTable(AlterTableRequest) with an 'action' of 'refresh'
  • ON_QUERY: Refresh any time the view is queried.
  • ON_CHANGE: If possible, incrementally refresh (refresh just those records added) whenever an insert, update, delete or refresh of input table is done. A full refresh is done if an incremental refresh is not possible.
  • PERIODIC: Refresh table periodically at rate specified by refresh_period
  The default value is MANUAL.
• REFRESH_PERIOD: When refresh_method is periodic, specifies the period in seconds at which refresh occurs
• REFRESH_START_TIME: When refresh_method is periodic, specifies the first time at which a refresh is to be done. Value is a datetime string with format 'YYYY-MM-DD HH:MM:SS'.
• TTL: Sets the TTL of the table specified in tableName.

The default value is an empty Map. A set of string constants for the parameter options.

Field Summary

Fields

Modifier and Type	Field and Description
static String	COLLECTION_NAME [DEPRECATED--please specify the containing schema for the materialized view as part of tableName and use GPUdb.createSchema(CreateSchemaRequest) to create the schema if non-existent] Name of a schema which is to contain the newly created view.
static String	EXECUTE_AS User name to use to run the refresh job
static String	FALSE
static String	MANUAL Refresh only occurs when manually requested by calling GPUdb.alterTable(AlterTableRequest) with an 'action' of 'refresh'
static String	ON_CHANGE If possible, incrementally refresh (refresh just those records added) whenever an insert, update, delete or refresh of input table is done.
static String	ON_QUERY Refresh any time the view is queried.
static String	PERIODIC Refresh table periodically at rate specified by refresh_period
static String	PERSIST If true, then the materialized view specified in tableName will be persisted and will not expire unless a ttl is specified.
static String	REFRESH_METHOD Method by which the join can be refreshed when the data in underlying member tables have changed.
static String	REFRESH_PERIOD When refresh_method is periodic, specifies the period in seconds at which refresh occurs
static String	REFRESH_SPAN Sets the future time-offset(in seconds) at which periodic refresh stops
static String	REFRESH_START_TIME When refresh_method is periodic, specifies the first time at which a refresh is to be done.
static String	REFRESH_STOP_TIME When refresh_method is periodic, specifies the time at which a periodic refresh is stopped.
static String	TRUE
static String	TTL Sets the Method Summary Methods inherited from class java.lang.Object clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait Field Detail COLLECTION_NAME public static final String COLLECTION_NAME [DEPRECATED--please specify the containing schema for the materialized view as part of tableName and use GPUdb.createSchema(CreateSchemaRequest) to create the schema if non-existent] Name of a schema which is to contain the newly created view. If the schema provided is non-existent, it will be automatically created. See Also: Constant Field Values EXECUTE_AS public static final String EXECUTE_AS User name to use to run the refresh job See Also: Constant Field Values PERSIST public static final String PERSIST If true, then the materialized view specified in tableName will be persisted and will not expire unless a ttl is specified. If false, then the materialized view will be an in-memory table and will expire unless a ttl is specified otherwise. Supported values: TRUE FALSE The default value is 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 REFRESH_SPAN public static final String REFRESH_SPAN Sets the future time-offset(in seconds) at which periodic refresh stops See Also: Constant Field Values REFRESH_STOP_TIME public static final String REFRESH_STOP_TIME When refresh_method is periodic, specifies the time at which a periodic refresh is stopped. Value is a datetime string with format 'YYYY-MM-DD HH:MM:SS'. See Also: Constant Field Values REFRESH_METHOD public static final String REFRESH_METHOD Method by which the join can be refreshed when the data in underlying member tables have changed. Supported values: MANUAL: Refresh only occurs when manually requested by calling GPUdb.alterTable(AlterTableRequest) with an 'action' of 'refresh' ON_QUERY: Refresh any time the view is queried. ON_CHANGE: If possible, incrementally refresh (refresh just those records added) whenever an insert, update, delete or refresh of input table is done. A full refresh is done if an incremental refresh is not possible. PERIODIC: Refresh table periodically at rate specified by refresh_period The default value is MANUAL. See Also: Constant Field Values MANUAL public static final String MANUAL Refresh only occurs when manually requested by calling GPUdb.alterTable(AlterTableRequest) with an 'action' of 'refresh' See Also: Constant Field Values ON_QUERY public static final String ON_QUERY Refresh any time the view is queried. See Also: Constant Field Values ON_CHANGE public static final String ON_CHANGE If possible, incrementally refresh (refresh just those records added) whenever an insert, update, delete or refresh of input table is done. A full refresh is done if an incremental refresh is not possible. See Also: Constant Field Values PERIODIC public static final String PERIODIC Refresh table periodically at rate specified by refresh_period See Also: Constant Field Values REFRESH_PERIOD public static final String REFRESH_PERIOD When refresh_method is periodic, specifies the period in seconds at which refresh occurs See Also: Constant Field Values REFRESH_START_TIME public static final String REFRESH_START_TIME When refresh_method is periodic, specifies the first time at which a refresh is to be done. Value is a datetime string with format 'YYYY-MM-DD HH:MM:SS'. See Also: Constant Field Values TTL public static final String TTL Sets the TTL of the table specified in tableName. See Also: Constant Field Values Skip navigation links Overview Package Class Use Tree Deprecated Index Help Prev Class Next Class Frames No Frames All Classes Summary: Nested | Field | Constr | Method Detail: Field | Constr | Method Copyright © 2024. All rights reserved.