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: Name of a collection which is to contain the newly created view. If the collection provided is non-existent, the collection will be automatically created. If empty, then the newly created table will be a top-level table.
• TTL: Sets the TTL of the table specified in tableName.
• 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_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: For future use.
  • 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'.

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 Name of a collection which is to contain the newly created view.
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 For future use.
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_START_TIME When refresh_method is periodic, specifies the first time at which a refresh is to be done.
static String	TRUE
static String	TTL Sets the TTL of the table specified in tableName.

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

Name of a collection which is to contain the newly created view. If the collection provided is non-existent, the collection will be automatically created. If empty, then the newly created table will be a top-level table.

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

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_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: For future use.
• 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

For future use.

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