You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@flink.apache.org by Sebastián Magrí <se...@gmail.com> on 2021/02/18 13:55:49 UTC
Compile time checking of SQL
Is there any way to check SQL strings in compile time?
--
Sebastián Ramírez Magrí
Re: Compile time checking of SQL
Posted by Sebastián Magrí <se...@gmail.com>.
Thanks a lot Timo!
On Mon, 22 Feb 2021 at 08:19, Timo Walther <tw...@apache.org> wrote:
> Yes, this is possible. You can run `tableEnv.sqlQuery("...").explain()`
> or `tableEnv.toRetractStream(table)` which would trigger the complete
> translation of the SQL query without executing it.
>
> Regards,
> Timo
>
> On 20.02.21 18:46, Sebastián Magrí wrote:
> > I mean the SQL queries being validated when I do `mvn compile` or any
> > target that runs that so that basic syntax checking is performed without
> > having to submit the job to the cluster.
> >
> > On Thu, 18 Feb 2021 at 16:17, Timo Walther <twalthr@apache.org
> > <ma...@apache.org>> wrote:
> >
> > Hi Sebastián,
> >
> > what do you consider as compile time? If you mean some kind of SQL
> > editor, you could take a look at Ververica platform (the community
> > edition is free):
> >
> >
> https://www.ververica.com/blog/data-pipelines-with-flink-sql-on-ververica-platform
> > <
> https://www.ververica.com/blog/data-pipelines-with-flink-sql-on-ververica-platform
> >
> >
> > Otherwise Flink SQL is always validated at (what we call) "pre-flight
> > phase". A cluster is not required but it is already JVM runtime of
> the
> > client.
> >
> > Regards,
> > Timo
> >
> > On 18.02.21 14:55, Sebastián Magrí wrote:
> > > Is there any way to check SQL strings in compile time?
> > >
> > > --
> > > Sebastián Ramírez Magrí
> >
> >
> >
> > --
> > Sebastián Ramírez Magrí
>
>
--
Sebastián Ramírez Magrí
Re: Compile time checking of SQL
Posted by Timo Walther <tw...@apache.org>.
Yes, this is possible. You can run `tableEnv.sqlQuery("...").explain()`
or `tableEnv.toRetractStream(table)` which would trigger the complete
translation of the SQL query without executing it.
Regards,
Timo
On 20.02.21 18:46, Sebastián Magrí wrote:
> I mean the SQL queries being validated when I do `mvn compile` or any
> target that runs that so that basic syntax checking is performed without
> having to submit the job to the cluster.
>
> On Thu, 18 Feb 2021 at 16:17, Timo Walther <twalthr@apache.org
> <ma...@apache.org>> wrote:
>
> Hi Sebastián,
>
> what do you consider as compile time? If you mean some kind of SQL
> editor, you could take a look at Ververica platform (the community
> edition is free):
>
> https://www.ververica.com/blog/data-pipelines-with-flink-sql-on-ververica-platform
> <https://www.ververica.com/blog/data-pipelines-with-flink-sql-on-ververica-platform>
>
> Otherwise Flink SQL is always validated at (what we call) "pre-flight
> phase". A cluster is not required but it is already JVM runtime of the
> client.
>
> Regards,
> Timo
>
> On 18.02.21 14:55, Sebastián Magrí wrote:
> > Is there any way to check SQL strings in compile time?
> >
> > --
> > Sebastián Ramírez Magrí
>
>
>
> --
> Sebastián Ramírez Magrí
Re: Compile time checking of SQL
Posted by Sebastián Magrí <se...@gmail.com>.
I mean the SQL queries being validated when I do `mvn compile` or any
target that runs that so that basic syntax checking is performed without
having to submit the job to the cluster.
On Thu, 18 Feb 2021 at 16:17, Timo Walther <tw...@apache.org> wrote:
> Hi Sebastián,
>
> what do you consider as compile time? If you mean some kind of SQL
> editor, you could take a look at Ververica platform (the community
> edition is free):
>
>
> https://www.ververica.com/blog/data-pipelines-with-flink-sql-on-ververica-platform
>
> Otherwise Flink SQL is always validated at (what we call) "pre-flight
> phase". A cluster is not required but it is already JVM runtime of the
> client.
>
> Regards,
> Timo
>
> On 18.02.21 14:55, Sebastián Magrí wrote:
> > Is there any way to check SQL strings in compile time?
> >
> > --
> > Sebastián Ramírez Magrí
>
>
--
Sebastián Ramírez Magrí
Re: Compile time checking of SQL
Posted by Timo Walther <tw...@apache.org>.
Hi Sebastián,
what do you consider as compile time? If you mean some kind of SQL
editor, you could take a look at Ververica platform (the community
edition is free):
https://www.ververica.com/blog/data-pipelines-with-flink-sql-on-ververica-platform
Otherwise Flink SQL is always validated at (what we call) "pre-flight
phase". A cluster is not required but it is already JVM runtime of the
client.
Regards,
Timo
On 18.02.21 14:55, Sebastián Magrí wrote:
> Is there any way to check SQL strings in compile time?
>
> --
> Sebastián Ramírez Magrí