ALTER VIEW

You can use this SQL to change a view or a materialized view. Today only the settings can be changed. To change the SQL query behinds the view, you have to drop and re-create it.

MODIFY QUERY SETTING

info

This feature will be available in Timeplus Enterprise v2.5 (unreleased yet). Not available in Timeplus Proton.

By default, the checkpoint will be updated every 15 minutes for materialized views. You can change the checkpoint interval without recreating the materialized views.

ALTER VIEW mv_with_inner_stream MODIFY QUERY SETTING checkpoint_interval=600

RESET QUERY SETTING

info

This feature will be available in Timeplus Enterprise v2.5 (unreleased yet). Not available in Timeplus Proton.

By default, the checkpoint will be updated every 15 minutes for materialized views. After you change the interval you can reset it.

ALTER VIEW mv_with_inner_stream RESET QUERY SETTING checkpoint_interval

See also

• ALTER STREAM - Alter streams
• CREATE STREAM - Create streams
• CREATE MATERIALIZED VIEW - Create materialized views
• DROP STREAM - Drop streams
• DROP VIEW - Drop materialized views