Your can see https://github.com/gridgain/gridgain/issues/1490
2020-10-13 0:00 GMT+08:00, LixinZhang <[email protected]>: > 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/ >
