​

Method Details

• ​

  getClassSchema

  public static org.apache.avro.Schema getClassSchema()

  This method supports the Avro framework and is not intended to be called directly by the user.

  Returns:

  The schema for the class.

• ​

  getTableName

  public String getTableName()

  Name of the table to be created that is the top-level table of the materialized view, in [schema_name.]table_name format, using standard name resolution rules and meeting table naming criteria.

  Returns:

  The current value of tableName.

• ​

  setTableName

  public CreateMaterializedViewRequest setTableName(String tableName)

  Name of the table to be created that is the top-level table of the materialized view, in [schema_name.]table_name format, using standard name resolution rules and meeting table naming criteria.

  Parameters:

  tableName - The new value for tableName.

  Returns:

  this to mimic the builder pattern.

• ​

  getOptions

  public Map<String,String> getOptions()

  Optional parameters.

  • 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.
  • EXECUTE_AS: User name to use to run the refresh job.
  • 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.
  • 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.
  • 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.
  • 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 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.

  Returns:

  The current value of options.

• ​

  setOptions

  public CreateMaterializedViewRequest setOptions(Map<String,String> options)

  Optional parameters.

  • 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.
  • EXECUTE_AS: User name to use to run the refresh job.
  • 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.
  • 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.
  • 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.
  • 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 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.

  Parameters:

  options - The new value for options.

  Returns:

  this to mimic the builder pattern.

• ​

  getSchema

  public org.apache.avro.Schema getSchema()

  This method supports the Avro framework and is not intended to be called directly by the user.

  Specified by:

  getSchema in interface org.apache.avro.generic.GenericContainer

  Returns:

  The schema object describing this class.

• ​

  get

  public Object get(int index)

  This method supports the Avro framework and is not intended to be called directly by the user.

  Specified by:

  get in interface org.apache.avro.generic.IndexedRecord

  Parameters:

  index - the position of the field to get

  Returns:

  value of the field with the given index.

  Throws:

  IndexOutOfBoundsException

• ​

  put

  public void put(int index, Object value)

  This method supports the Avro framework and is not intended to be called directly by the user.

  Specified by:

  put in interface org.apache.avro.generic.IndexedRecord

  Parameters:

  index - the position of the field to set

  value - the value to set

  Throws:

  IndexOutOfBoundsException

• ​

  equals

  public boolean equals(Object obj)

  Overrides:

  equals in class Object

• ​

  toString

  public String toString()

  Overrides:

  toString in class Object

• ​

  hashCode

  public int hashCode()

  Overrides:

  hashCode in class Object