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

A set of string constants for the CreateMaterializedViewRequest parameter options.

Optional parameters.

Field Summary

Fields

Modifier and Type	Field and Description
static String	ALWAYS Rebuild as many materialized views as possible before accepting requests.
static String	BUILD_MATERIALIZED_VIEW_POLICY Sets startup materialized view rebuild scheme.
static String	COLLECTION_NAME [DEPRECATED--please specify the containing schema for the materialized view as part of tableName and use GPUdb.createSchema 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	LAZY Rebuild the necessary materialized views at start, and load the remainder lazily.
static String	MANUAL Refresh only occurs when manually requested by calling GPUdb.alterTable 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_DEMAND Rebuild materialized views as requests use them.
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	SYSTEM Rebuild materialized views using the system-configured default.
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 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 BUILD_MATERIALIZED_VIEW_POLICY public static final String BUILD_MATERIALIZED_VIEW_POLICY Sets startup materialized view rebuild scheme. Supported values: ALWAYS: Rebuild as many materialized views as possible before accepting requests. LAZY: Rebuild the necessary materialized views at start, and load the remainder lazily. ON_DEMAND: Rebuild materialized views as requests use them. SYSTEM: Rebuild materialized views using the system-configured default. The default value is SYSTEM. See Also: Constant Field Values ALWAYS public static final String ALWAYS Rebuild as many materialized views as possible before accepting requests. See Also: Constant Field Values LAZY public static final String LAZY Rebuild the necessary materialized views at start, and load the remainder lazily. See Also: Constant Field Values ON_DEMAND public static final String ON_DEMAND Rebuild materialized views as requests use them. See Also: Constant Field Values SYSTEM public static final String SYSTEM Rebuild materialized views using the system-configured default. 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 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 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 © 2025. All rights reserved.