ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nikolay Izhikov <nizhikov....@gmail.com>
Subject Re: [SparkDataFrame] Query Optimization. Prototype
Date Mon, 22 Jan 2018 04:19:47 GMT
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
View raw message