You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by LixinZhang <in...@gmail.com> on 2020/10/12 16:00:59 UTC
enable sqlOffloadingEnabled sql avg fun has error
sqlOffloadingEnabled : true
create table tests(
ID int,
CREATETIME TIMESTAMP(29,9),
PRIMARY KEY (ID)
) WITH "template=partitioned, CACHE_NAME=tests";
select AVG(EXTRACT(MILLISECOND from CREATETIME))
from tests;
Failed to run reduce query locally. General error:
"java.lang.ArrayIndexOutOfBoundsException: 1"; SQL statement:
SELECT
CAST((CAST(SUM(("__C0_0" * "__C0_1")) AS BIGINT) / CAST(SUM("__C0_1") AS
BIGINT)) AS BIGINT) AS "__C0_0"
FROM "PUBLIC"."__T0" [50000-199]
javax.cache.CacheException: Failed to run reduce query locally. General
error: "java.lang.ArrayIndexOutOfBoundsException: 1"; SQL statement:
SELECT
CAST((CAST(SUM(("__C0_0" * "__C0_1")) AS BIGINT) / CAST(SUM("__C0_1") AS
BIGINT)) AS BIGINT) AS "__C0_0"
FROM "PUBLIC"."__T0" [50000-199]
I use Gridgain community version, but i believe all versions have this
problem.
I test it for Gridgain ignite version: 8.7.15 ~ 8.7.27
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: enable sqlOffloadingEnabled sql avg fun has error
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
Please use Apache Ignite JIRA to file tickets:
https://issues.apache.org/jira/projects/IGNITE/issues
Does this issue reproduce on any Apache Ignite versions? Please try some
2.9 nightly build:
https://ci.ignite.apache.org/buildConfiguration/Releases_NightlyRelease_RunApacheIgniteNightlyRelease?branch=ignite-2.9&buildTypeTab=overview&mode=builds
Regards,
--
Ilya Kasnacheev
пн, 12 окт. 2020 г. в 19:02, 张立鑫 <in...@gmail.com>:
> Your can see https://github.com/gridgain/gridgain/issues/1490
>
> 2020-10-13 0:00 GMT+08:00, LixinZhang <in...@gmail.com>:
> > sqlOffloadingEnabled : true
> >
> > create table tests(
> > ID int,
> > CREATETIME TIMESTAMP(29,9),
> > PRIMARY KEY (ID)
> > ) WITH "template=partitioned, CACHE_NAME=tests";
> >
> > select AVG(EXTRACT(MILLISECOND from CREATETIME))
> > from tests;
> >
> > Failed to run reduce query locally. General error:
> > "java.lang.ArrayIndexOutOfBoundsException: 1"; SQL statement:
> > SELECT
> > CAST((CAST(SUM(("__C0_0" * "__C0_1")) AS BIGINT) / CAST(SUM("__C0_1") AS
> > BIGINT)) AS BIGINT) AS "__C0_0"
> > FROM "PUBLIC"."__T0" [50000-199]
> > javax.cache.CacheException: Failed to run reduce query locally. General
> > error: "java.lang.ArrayIndexOutOfBoundsException: 1"; SQL statement:
> > SELECT
> > CAST((CAST(SUM(("__C0_0" * "__C0_1")) AS BIGINT) / CAST(SUM("__C0_1") AS
> > BIGINT)) AS BIGINT) AS "__C0_0"
> > FROM "PUBLIC"."__T0" [50000-199]
> >
> >
> >
> > I use Gridgain community version, but i believe all versions have this
> > problem.
> > I test it for Gridgain ignite version: 8.7.15 ~ 8.7.27
> >
> >
> >
> > --
> > Sent from: http://apache-ignite-users.70518.x6.nabble.com/
> >
>
Re: enable sqlOffloadingEnabled sql avg fun has error
Posted by 张立鑫 <in...@gmail.com>.
Your can see https://github.com/gridgain/gridgain/issues/1490
2020-10-13 0:00 GMT+08:00, LixinZhang <in...@gmail.com>:
> sqlOffloadingEnabled : true
>
> create table tests(
> ID int,
> CREATETIME TIMESTAMP(29,9),
> PRIMARY KEY (ID)
> ) WITH "template=partitioned, CACHE_NAME=tests";
>
> select AVG(EXTRACT(MILLISECOND from CREATETIME))
> from tests;
>
> Failed to run reduce query locally. General error:
> "java.lang.ArrayIndexOutOfBoundsException: 1"; SQL statement:
> SELECT
> CAST((CAST(SUM(("__C0_0" * "__C0_1")) AS BIGINT) / CAST(SUM("__C0_1") AS
> BIGINT)) AS BIGINT) AS "__C0_0"
> FROM "PUBLIC"."__T0" [50000-199]
> javax.cache.CacheException: Failed to run reduce query locally. General
> error: "java.lang.ArrayIndexOutOfBoundsException: 1"; SQL statement:
> SELECT
> CAST((CAST(SUM(("__C0_0" * "__C0_1")) AS BIGINT) / CAST(SUM("__C0_1") AS
> BIGINT)) AS BIGINT) AS "__C0_0"
> FROM "PUBLIC"."__T0" [50000-199]
>
>
>
> I use Gridgain community version, but i believe all versions have this
> problem.
> I test it for Gridgain ignite version: 8.7.15 ~ 8.7.27
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>