ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Denis Magda <dma...@gridgain.com>
Subject Re: [SparkDataFrame] Query Optimization. Prototype
Date Mon, 22 Jan 2018 05:20:19 GMT
I see that CAST is supported by H2 but not presented among Ignite system
functions:
https://apacheignite-sql.readme.io/docs/system-functions

Serge, is this an oversight on our doc side? H2 system functions scope is
much broader in general. Could you check this up?

Denis

On Sunday, January 21, 2018, Nikolay Izhikov <nizhikov.dev@gmail.com> wrote:

> Hello, Val.
>
> Thank you.
> Looking forward for your review.
>
> One more issues with Ignite SQL:
>
> Do we have description of CAST function?
> I want to find out which types that can be converted from one to other.
>
> Something like following table for a MsSQL [1]
>
> Should I wrote my questions about Ignite SQL in another thread?
>
> [1] https://docs.microsoft.com/ru-ru/sql/t-sql/functions/cast-
> and-convert-transact-sql
>
>
> В Пт, 19/01/2018 в 14:18 -0800, Valentin Kulichenko пишет:
> > Hi Nikolay,
> >
> > I will review this sometime next week.
> >
> > -Val
> >
> > On Fri, Jan 19, 2018 at 2:44 AM, Nikolay Izhikov <nizhikov.dev@gmail.com>
> wrote:
> > > Hello, guys.
> > >
> > > I have done prototype of implementation of optimization query from
> Spark to Ignite [1].
> > >
> > > Please, take a look at PR [2].
> > >
> > > But still there are some issues I want to clarify with community:
> > >
> > >     * Can I know scale and precision of DECIMAL column?
> > >       Example - [3]
> > >
> > >     * Ignite have some limitation for a *distributed* join. For
> example, we can execute join only for indexed columns. Example - [4].
> > >         * Do we have documentation for all limitations of distributed
> join implementation?
> > >         * How can I know whether concrete syntactically correct SQL
> query with join can be executed by Ignite or not?
> > >
> > > [1] https://issues.apache.org/jira/browse/IGNITE-7077
> > > [2] https://github.com/apache/ignite/pull/3397
> > > [3] https://gist.github.com/nizhikov/2d67ed68afd473d7251dab7d79135513
> > > [4] https://gist.github.com/nizhikov/a4389fd78636869dd38c13920b5baf2b
> >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message