tement
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 LIKE statement allows the
definition
> of n
t; > > >
>> > > > Regards,
>> > > > Jeyhun
>> > > >
>> > > > On Thu, Jun 13, 2024 at 4:48 PM Sergio Pena
>> > > > > >
>> > > > wrote:
>> > > >
>> > > > > Sure Yuxia, I jus
t; > >
> > > > > Sure Yuxia, I just added the support for RTAS statements too.
> > > > >
> > > > > - Sergio
> > > > >
> > > > > On Wed, Jun 12, 2024 at 8:22 PM yuxia >
> > > > wrote:
> > > >
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 supporting schema definition for REPLACE T
> > to CREATE TABLE AS Statement
> > > >
> > > >
> > > > [1]
> > > >
> > >
> >
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-303%3A+Support+REPLACE+TABLE+AS+SELECT+statement
> > > >
> >
; > > [1]
> > >
> >
> https://cwiki.apache.org/confluence/display/FLINK/FLIP-303%3A+Support+REPLACE+TABLE+AS+SELECT+statement
> > >
> > > Best regards,
> > > Yuxia
> > >
> > > - 原始邮件 -
> > > 发件人: "Timo Walth
a
> >
> > - 原始邮件 -----
> > 发件人: "Timo Walther"
> > 收件人: "dev"
> > 发送时间: 星期三, 2024年 6 月 12日 下午 10:19:14
> > 主题: Re: [DISCUSS] FLIP-463: Schema Definition in CREATE TABLE AS
> Statement
> >
> > > I just noticed the CREA
ment
>
> 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 LIKE
2] supports ISNULL. Is there a thought to change the
>>>>>>> nullability for the CTAS?
>>>>>>
>>>>>> Amazon [4] ignores ordered by clauses ? is that the same for this
>>>> proposal?
>>>>>>
>>>>>
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@flink.apache.org
Subject: [EXTERNAL] [DISCUSS] FLIP-463: Schema Definition in CR
t; >> 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 don't see
> > any
> > >> >> restrictio
t; 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>
> >> >> wrote:
> >> >>
> >> >>> H
>>> - 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,
>> >>> aggregate, windowed?
>> >>> - I
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 change the
> >>> nullability for the CTAS?
> >>&g
ations-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 discussion on FLIP-463: Schema Definition in CREATE
TABLE
electinto-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-limitations.html#ctas-considerati
hena/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] [DISCUSS] FLIP-463: Schema
: 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 CTAS
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
19 matches
Mail list logo