[ https://issues.apache.org/jira/browse/FLINK-35191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
dalongliu resolved FLINK-35191. ------------------------------- Resolution: Fixed > Support alter materialized table related syntaxes: suspend, resume, refresh, > set and reset > ------------------------------------------------------------------------------------------ > > Key: FLINK-35191 > URL: https://issues.apache.org/jira/browse/FLINK-35191 > Project: Flink > Issue Type: Sub-task > Components: Table SQL / API > Affects Versions: 1.20.0 > Reporter: dalongliu > Assignee: Feng Jin > Priority: Major > Labels: pull-request-available > Fix For: 1.20.0 > > > SQL statement as follows: > {code:SQL} > // 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'); > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)