enable sqlOffloadingEnabled sql avg fun has error

classic Classic list List threaded Threaded
3 messages Options
LixinZhang LixinZhang
Reply | Threaded
Open this post in threaded view
|

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/
LixinZhang LixinZhang
Reply | Threaded
Open this post in threaded view
|

Re: enable sqlOffloadingEnabled sql avg fun has error

Your can see https://github.com/gridgain/gridgain/issues/1490

2020-10-13 0:00 GMT+08:00, LixinZhang <[hidden email]>:

> 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/
>
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: enable sqlOffloadingEnabled sql avg fun has error

Hello!

Please use Apache Ignite JIRA to file tickets: https://issues.apache.org/jira/projects/IGNITE/issues


Regards,
--
Ilya Kasnacheev


пн, 12 окт. 2020 г. в 19:02, 张立鑫 <[hidden email]>:
Your can see https://github.com/gridgain/gridgain/issues/1490

2020-10-13 0:00 GMT+08:00, LixinZhang <[hidden email]>:
> 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/
>