[ https://issues.apache.org/jira/browse/FLINK-35195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated FLINK-35195: ----------------------------------- Labels: pull-request-available (was: ) > Support the execution of create materialized table in continuous refresh mode > ----------------------------------------------------------------------------- > > Key: FLINK-35195 > URL: https://issues.apache.org/jira/browse/FLINK-35195 > Project: Flink > Issue Type: Sub-task > Components: Table SQL / API, Table SQL / Gateway > Affects Versions: 1.20.0 > Reporter: dalongliu > Assignee: dalongliu > Priority: Major > Labels: pull-request-available > Fix For: 1.20.0 > > > In continuous refresh mode, support creates materialized table and its > background refresh job: > {code:SQL} > CREATE MATERIALIZED TABLE [catalog_name.][db_name.]table_name > > [ ([ <table_constraint> ]) ] > > [COMMENT table_comment] > > [PARTITIONED BY (partition_column_name1, partition_column_name2, ...)] > > [WITH (key1=val1, key2=val2, ...)] > > FRESHNESS = INTERVAL '<num>' { SECOND | MINUTE | HOUR | DAY } > > [REFRESH_MODE = { CONTINUOUS | FULL }] > > AS <select_statement> > > <table_constraint>: > [CONSTRAINT constraint_name] PRIMARY KEY (column_name, ...) NOT ENFORCED > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)