You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by Qi Luo <lu...@gmail.com> on 2019/09/03 10:18:50 UTC

Flink SQL - Support Computed Columns in DDL?

Hi folks,

Computed columns in Flink SQL DDL is currently disabled in both old planner
and Blink planner (throws "Computed columns for DDL is not supported yet!"
exception in SqlToOperationConverter).

I searched through the JIRA but found no relevant issues. Do we have any
plans to support this nice feature?

Thanks,
Qi

Re: Flink SQL - Support Computed Columns in DDL?

Posted by Qi Luo <lu...@gmail.com>.
Hi Jark and Danny,

Glad to hear your plan on this!

One of our use cases is to define some column as rowtime (which is not of
type timestamp). Computed column seems to be a natural fit for that.

Thanks,
Qi

On Tue, Sep 3, 2019 at 7:46 PM Jark Wu <im...@gmail.com> wrote:

> Hi Qi,
>
> The computed column is not fully supported in 1.9. We will start a design
> discussion in the dev mailing list soon. Please stay tuned!
>
> Btw, could you share with us what's the case why do you want to use
> computed column?
>
> Best,
> Jark
>
> On Tue, 3 Sep 2019 at 19:25, Danny Chan <yu...@gmail.com> wrote:
>
> > Yeah, we are planning to implement this feature in release-1.10, wait for
> > our good news !
> >
> > Best,
> > Danny Chan
> > 在 2019年9月3日 +0800 PM6:19，Qi Luo <lu...@gmail.com>，写道：
> > > Hi folks,
> > >
> > > Computed columns in Flink SQL DDL is currently disabled in both old
> > planner
> > > and Blink planner (throws "Computed columns for DDL is not supported
> > yet!"
> > > exception in SqlToOperationConverter).
> > >
> > > I searched through the JIRA but found no relevant issues. Do we have
> any
> > > plans to support this nice feature?
> > >
> > > Thanks,
> > > Qi
> >
>

Re: Flink SQL - Support Computed Columns in DDL?

Posted by Jark Wu <im...@gmail.com>.
Hi Qi,

The computed column is not fully supported in 1.9. We will start a design
discussion in the dev mailing list soon. Please stay tuned!

Btw, could you share with us what's the case why do you want to use
computed column?

Best,
Jark

On Tue, 3 Sep 2019 at 19:25, Danny Chan <yu...@gmail.com> wrote:

> Yeah, we are planning to implement this feature in release-1.10, wait for
> our good news !
>
> Best,
> Danny Chan
> 在 2019年9月3日 +0800 PM6:19，Qi Luo <lu...@gmail.com>，写道：
> > Hi folks,
> >
> > Computed columns in Flink SQL DDL is currently disabled in both old
> planner
> > and Blink planner (throws "Computed columns for DDL is not supported
> yet!"
> > exception in SqlToOperationConverter).
> >
> > I searched through the JIRA but found no relevant issues. Do we have any
> > plans to support this nice feature?
> >
> > Thanks,
> > Qi
>

Re: Flink SQL - Support Computed Columns in DDL?

Posted by Danny Chan <yu...@gmail.com>.
Yeah, we are planning to implement this feature in release-1.10, wait for our good news !

Best,
Danny Chan
在 2019年9月3日 +0800 PM6:19，Qi Luo <lu...@gmail.com>，写道：
> Hi folks,
>
> Computed columns in Flink SQL DDL is currently disabled in both old planner
> and Blink planner (throws "Computed columns for DDL is not supported yet!"
> exception in SqlToOperationConverter).
>
> I searched through the JIRA but found no relevant issues. Do we have any
> plans to support this nice feature?
>
> Thanks,
> Qi