Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

NK/FLIP-303%3A+Support+REPLACE+TABLE+AS+SELECT+statement Best regards, Yuxia - 原始邮件 - 发件人: "Timo Walther" 收件人: "dev" 发送时间: 星期三, 2024年 6 月 12日 下午 10:19:14 主题: Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement I just noticed the CREATE TABLE

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

Looking forward for this feature. >> > > > >> > > > Regards, >> > > > Jeyhun >> > > > >> > > > On Thu, Jun 13, 2024 at 4:48 PM Sergio Pena >> > > > > > >> > > > wrote: >> > > > >&g

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

> > > > > wrote: > > > > > > > > > Sure Yuxia, I just added the support for RTAS statements too. > > > > > > > > > > - Sergio > > > > > > > > > > On Wed, Jun 12, 2024 at 8:22 PM yuxia > > &

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

> > > > > > Hi, Sergio. > > > > > Thanks for driving the FLIP. Given we also has REPLACE TABLE AS > > > > > Statement[1] and it's almost same with CREATE TABLE AS Statement, > > > > > would you mind also support

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

> Statement > > > > to CREATE TABLE AS Statement > > > > > > > > > > > > [1] > > > > > > > > > > https://cwiki.apache.org/confluence/display/FLINK/FLIP-303%3A+Support+REPLACE+TABLE+AS+SELECT+statement >

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

; > > > > [1] > > > > > > https://cwiki.apache.org/confluence/display/FLINK/FLIP-303%3A+Support+REPLACE+TABLE+AS+SELECT+statement > > > > > > Best regards, > > > Yuxia > > > > > > - 原始邮件 - > > > 发件人: "

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

> Yuxia > > > > ----- 原始邮件 ----- > > 发件人: "Timo Walther" > > 收件人: "dev" > > 发送时间: 星期三, 2024年 6 月 12日 下午 10:19:14 > > 主题: Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS > Statement > > > > > I just noticed t

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

LECT+statement > > Best regards, > Yuxia > > - 原始邮件 - > 发件人: "Timo Walther" > 收件人: "dev" > 发送时间: 星期三, 2024年 6 月 12日 下午 10:19:14 > 主题: Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement > > > I just noticed the CREATE T

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

t; aggregate, windowed? >>>>>> >>>>>> I notice Azure [2] supports ISNULL. Is there a thought to change the >>>>>>> nullability for the CTAS? >>>>>> >>>>>> Amazon [4] ignores ordered by clauses ? is that

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

erations-limitations.html#ctas-considerations-limitations-queries-vs-views [4] https://docs.aws.amazon.com/athena/latest/ug/ctas-considerations-limitations.html#ctas-considerations-limitations-order-by-ignored Kind regards, David. From: Sergio Pena Date: Friday, 7 June 2024 at 16:13 To: dev

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

> nullability for the CTAS? > > >> >> > > >> >> Amazon [4] ignores ordered by clauses ? is that the same for this > > >> proposal? > > >> >> > > >> >> I suppose all of this is already supported by FLIP-218. I d

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

>> [2] > >> >> > >> >> > >> > https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sql/create/#as-select_statement > >> >> > >> >> On Mon, Jun 10, 2024 at 3:10 AM David Radley < > david_rad...@uk.ibm.com> > &

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

;> >>> would use each of these. >> >>> >> >>> - I assume the table will be kept up to date as the source data >> changes >> >>> like a view. >> >>> - Are there any restrictions on the select ? Can the select be a join,

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

generated columns are allowed? > >>> - is the table read-only, or can we insert/ delete / update into it. If > >> it > >>> is read only how will the inserts , deletes updates fail. > >>> - I notice Azure [2] supports ISNULL. Is there a thought to chang

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

ions-limitations.html#ctas-considerations-limitations-order-by-ignored Kind regards, David. From: Sergio Pena Date: Friday, 7 June 2024 at 16:13 To: dev@flink.apache.org Subject: [EXTERNAL] [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement HI All, I'd like to start a dis

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

-warehouse-develop-ctas#selectinto-vs-ctas > > [3] > > > https://docs.aws.amazon.com/athena/latest/ug/ctas-considerations-limitations.html#ctas-considerations-limitations-queries-vs-views > > [4] > > > https://docs.aws.amazon.com/athena/latest/ug/ctas-considerations-limitati

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

://docs.aws.amazon.com/athena/latest/ug/ctas-considerations-limitations.html#ctas-considerations-limitations-order-by-ignored > > > Kind regards, David. > > From: Sergio Pena > Date: Friday, 7 June 2024 at 16:13 > To: dev@flink.apache.org > Subject: [EXTERNAL] [DISC

Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

: Sergio Pena Date: Friday, 7 June 2024 at 16:13 To: dev@flink.apache.org Subject: [EXTERNAL] [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement HI All, I'd like to start a discussion on FLIP-463: Schema Definition in CREATE TABLE AS Statement [1] The proposal extends the

[DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS Statement

HI All, I'd like to start a discussion on FLIP-463: Schema Definition in CREATE TABLE AS Statement [1] The proposal extends the CTAS statement to allow users to define their own schema by adding columns, primary and partition keys, and table distribution to the CREATE statement. Any thoughts are