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....@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....@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 > > > > >
