[FLINK-35191] Support alter materialized table related syntaxes: suspend, resume, refresh, set and reset

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.20.0
• Fix Version/s: 1.20.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Feng Jin
• Reporter: dalongliu
• Created: 22/Apr/24 07:59
• Updated: 30/Apr/24 01:32
• Resolved: 30/Apr/24 01:32

Description

SQL statement as follows:

// suspend
ALTER MATERIALIZED TABLE [catalog_name.][db_name.]table_name SUSPEND

// resume
ALTER MATERIALIZED TABLE [catalog_name.][db_name.]table_name RESUME
 
[WITH('key1' = 'val1', 'key2' = 'val2')]

// refresh
ALTER MATERIALIZED TABLE [catalog_name.][db_name.]table_name REFRESH
 
[PARTITION (key1=val1, key2=val2, ...)]

// set freshness
ALTER MATERIALIZED TABLE [catalog_name.][db_name.]table_name 
 
  SET FRESHNESS = INTERVAL '<num>' { SECOND | MINUTE | HOUR | DAY }

// set refresh mode

ALTER MATERIALIZED TABLE  [catalog_name.][db_name.]table_name 
 
  SET REFRESH_MODE = { FULL | CONTINUOUS }

// set options
ALTER MATERIALIZED TABLE [catalog_name.][db_name.]table_name  SET ('key' = 'val');

// reset options
ALTER MATERIALIZED TABLE [catalog_name.][db_name.]table_name RESET ('key');

Issue Links

• links to: GitHub Pull Request #24737