Package com.gpudb.protocol

Class CreateMaterializedViewRequest.Options

    • 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

      • 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

      • 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: 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

      • 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

      • 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