You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "dalongliu (Jira)" <ji...@apache.org> on 2024/04/26 01:56:00 UTC

[jira] [Resolved] (FLINK-35190) Support create materialized table syntax

     [ https://issues.apache.org/jira/browse/FLINK-35190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

dalongliu resolved FLINK-35190.
-------------------------------
    Resolution: Fixed

> Support create materialized table syntax
> ----------------------------------------
>
>                 Key: FLINK-35190
>                 URL: https://issues.apache.org/jira/browse/FLINK-35190
>             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
>
>
> Create materialized table syntax:
> {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)