You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by davida <da...@live.com> on 2017/02/19 19:43:27 UTC
List of supported SQL functions (same as H2?)
Hi all,
Where can I find full list of supported SQL functions (e.g. string functions
like RTRIM, substring or hour, day, etc.). As SQL grid is based on H2
database, does it mean, that all functions of H2 are supported:
http://www.h2database.com/html/functions.html.
Thx
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/List-of-supported-SQL-functions-same-as-H2-tp10722.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: List of supported SQL functions (same as H2?)
Posted by Sergi Vladykin <se...@gmail.com>.
I don't see any right now. Patches are welcome!
Sergi
2017-02-22 2:32 GMT+03:00 Denis Magda <dm...@apache.org>:
> Sergi,
>
> Is there any technical reason that prevents us supporting GROUP_CONCAT?
>
> —
> Denis
>
> > On Feb 21, 2017, at 2:46 AM, zaid <za...@gmail.com> wrote:
> >
> >
> > Yes, everything that is supported in H2 available in Ignite.
> >
> > GROUP_CONCAT is not working for me:
> >
> > Please find below code snippet from ignite-indexing module:
> >
> > class file:
> >
> > GridSqlAggregateFunction
> >
> > line no: 84
> >
> > switch (type) {
> > case GROUP_CONCAT:
> > throw new UnsupportedOperationException();
> > Regards.
> >
> >
> >
> > --
> > View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/List-of-supported-SQL-functions-same-
> as-H2-tp10722p10756.html
> > Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>
>
Re: List of supported SQL functions (same as H2?)
Posted by Denis Magda <dm...@apache.org>.
Sergi,
Is there any technical reason that prevents us supporting GROUP_CONCAT?
—
Denis
> On Feb 21, 2017, at 2:46 AM, zaid <za...@gmail.com> wrote:
>
>
> Yes, everything that is supported in H2 available in Ignite.
>
> GROUP_CONCAT is not working for me:
>
> Please find below code snippet from ignite-indexing module:
>
> class file:
>
> GridSqlAggregateFunction
>
> line no: 84
>
> switch (type) {
> case GROUP_CONCAT:
> throw new UnsupportedOperationException();
> Regards.
>
>
>
> --
> View this message in context: http://apache-ignite-users.70518.x6.nabble.com/List-of-supported-SQL-functions-same-as-H2-tp10722p10756.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: List of supported SQL functions (same as H2?)
Posted by zaid <za...@gmail.com>.
Yes, everything that is supported in H2 available in Ignite.
GROUP_CONCAT is not working for me:
Please find below code snippet from ignite-indexing module:
class file:
GridSqlAggregateFunction
line no: 84
switch (type) {
case GROUP_CONCAT:
throw new UnsupportedOperationException();
Regards.
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/List-of-supported-SQL-functions-same-as-H2-tp10722p10756.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: List of supported SQL functions (same as H2?)
Posted by Denis Magda <dm...@apache.org>.
Yes, everything that is supported in H2 available in Ignite.
—
Denis
> On Feb 19, 2017, at 11:43 AM, davida <da...@live.com> wrote:
>
> Hi all,
>
> Where can I find full list of supported SQL functions (e.g. string functions
> like RTRIM, substring or hour, day, etc.). As SQL grid is based on H2
> database, does it mean, that all functions of H2 are supported:
> http://www.h2database.com/html/functions.html.
>
> Thx
>
>
>
> --
> View this message in context: http://apache-ignite-users.70518.x6.nabble.com/List-of-supported-SQL-functions-same-as-H2-tp10722.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.