osdir.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: SQL Client Limitations


I'd like to better understand how catalogs will work in SQL Client.   I
assume we'll be able to reference catalog classes from the environment file
(e.g. FLINK-9172).

Thanks

On Tue, Aug 21, 2018 at 4:56 AM Fabian Hueske <fhueske@xxxxxxxxxx> wrote:

> Hi Dominik,
>
> The SQL Client supports the same subset of SQL that you get with Java /
> Scala embedded queries.
> The documentation [1] covers all supported operations.
>
> There are some limitations because certain operators require special time
> attributes (row time or processing time attributes) which are monotonically
> increasing.
> Some operators such as a regular join (in contrast to a time-windowed join)
> remove the monotonicity property of time attributes such that time-based
> operations cannot be applied anymore.
>
> Best,
> Fabian
>
> [1] https://ci.apache.org/projects/flink/flink-docs-
> release-1.6/dev/table/sql.html
>
>
>
> 2018-08-21 13:27 GMT+02:00 Till Rohrmann <trohrmann@xxxxxxxxxx>:
>
> > Hi Dominik,
> >
> > I think such a list would be really helpful. I've pulled Timo and Fabian
> > into this conversation because they probably know more.
> >
> > Cheers,
> > Till
> >
> > On Mon, Aug 20, 2018 at 12:43 PM Dominik Wosiński <wossyn@xxxxxxxxx>
> > wrote:
> >
> >> Hey,
> >>
> >> Do we have any list of current limitations of SQL Client available
> >> somewhere or the only way is to go through JIRA issues?
> >>
> >> For example:
> >> I tried to make Group By Tumble Window and Inner Join in one query and
> it
> >> seems that it is not possible currently and I was wondering whether it's
> >> and issue with my query or known limitation.
> >>
> >> Thanks,
> >> Best Regards,
> >> Dominik.
> >>
> >
>