You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2022/12/13 10:56:00 UTC
[jira] [Updated] (IGNITE-18393) Sql. Broken aggregations accumulators for (var)binary types.
[ https://issues.apache.org/jira/browse/IGNITE-18393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Evgeny Stanilovsky updated IGNITE-18393:
----------------------------------------
Description:
No accumulators implemented for aggregators with (var)binary types
{noformat}
CREATE TABLE blobs (b varbinary, g INTEGER);
INSERT INTO blobs VALUES (x'FFFEFB', 1);
SELECT MIN(b) FROM blobs;
{noformat}
{noformat}
Caused by: org.apache.ignite.sql.SqlException: IGN-SQL-26 TraceId:06941fc6-3098-4fd3-a9f2-07f9a66fb317 Line 2, Column 125: Cannot cast "long" to "org.apache.calcite.avatica.util.ByteString"
at org.apache.ignite.internal.sql.engine.util.Commons.compile(Commons.java:515)
at org.apache.ignite.internal.sql.engine.exec.exp.agg.AccumulatorsFactory.compileCast(AccumulatorsFactory.java:128)
at org.apache.ignite.internal.sql.engine.exec.exp.agg.AccumulatorsFactory.cast0(AccumulatorsFactory.java:100){noformat}
check:
org.apache.ignite.internal.sql.engine.exec.exp.agg.Accumulators
was:
No accumulators implemented for aggregators with (var)binary types
{noformat}
CREATE TABLE blobs (b varbinary, g INTEGER);
INSERT INTO blobs VALUES (x'FFFEFB', 1);
SELECT MIN(b) FROM blobs;
{noformat}
{noformat}
Caused by: org.apache.ignite.sql.SqlException: IGN-SQL-26 TraceId:06941fc6-3098-4fd3-a9f2-07f9a66fb317 Line 2, Column 125: Cannot cast "long" to "org.apache.calcite.avatica.util.ByteString"
at org.apache.ignite.internal.sql.engine.util.Commons.compile(Commons.java:515)
at org.apache.ignite.internal.sql.engine.exec.exp.agg.AccumulatorsFactory.compileCast(AccumulatorsFactory.java:128)
at org.apache.ignite.internal.sql.engine.exec.exp.agg.AccumulatorsFactory.cast0(AccumulatorsFactory.java:100){noformat}
check:
org.apache.ignite.internal.sql.engine.exec.exp.agg.Accumulators
> Sql. Broken aggregations accumulators for (var)binary types.
> ------------------------------------------------------------
>
> Key: IGNITE-18393
> URL: https://issues.apache.org/jira/browse/IGNITE-18393
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Evgeny Stanilovsky
> Priority: Major
>
> No accumulators implemented for aggregators with (var)binary types
> {noformat}
> CREATE TABLE blobs (b varbinary, g INTEGER);
> INSERT INTO blobs VALUES (x'FFFEFB', 1);
> SELECT MIN(b) FROM blobs;
> {noformat}
>
> {noformat}
> Caused by: org.apache.ignite.sql.SqlException: IGN-SQL-26 TraceId:06941fc6-3098-4fd3-a9f2-07f9a66fb317 Line 2, Column 125: Cannot cast "long" to "org.apache.calcite.avatica.util.ByteString"
> at org.apache.ignite.internal.sql.engine.util.Commons.compile(Commons.java:515)
> at org.apache.ignite.internal.sql.engine.exec.exp.agg.AccumulatorsFactory.compileCast(AccumulatorsFactory.java:128)
> at org.apache.ignite.internal.sql.engine.exec.exp.agg.AccumulatorsFactory.cast0(AccumulatorsFactory.java:100){noformat}
> check:
> org.apache.ignite.internal.sql.engine.exec.exp.agg.Accumulators
--
This message was sent by Atlassian Jira
(v8.20.10#820010)