​

Field Details

• ​

  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

• ​

  ENABLE_MV_INPUT_WRAPPERS

  public static final String ENABLE_MV_INPUT_WRAPPERS

  If TRUE, each base table the view reads is accessed through a wrapper view so an in-progress out-of-place update cannot make a record momentarily disappear from the view, and a long refresh does not block updates to the base tables. Overrides the gaia.enable_mv_input_wrappers configuration default when set. Supported values:

  • TRUE
  • FALSE

  The default value is 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