[FLINK-35195] Support the execution of create materialized table in continuous refresh mode

• 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, Table SQL / Gateway
• Labels: pull-request-available
• Assignee: dalongliu
• Reporter: dalongliu
• Created: 22/Apr/24 08:04
• Updated: 07/May/24 12:29
• Resolved: 07/May/24 12:29

Description

In continuous refresh mode, support creates materialized table and its background refresh job:

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

Issue Links

• links to: GitHub Pull Request #24750