Sergey Korotkov created IGNITE-24376:
----------------------------------------
Summary: Calcite. ClassNotFoundException in queries with SUM
Key: IGNITE-24376
URL: https://issues.apache.org/jira/browse/IGNITE-24376
Project: Ignite
Issue Type: Bug
Reporter: Sergey Korotkov
After the IGNITE-22991 (bump from the calcite 1.34 to 1.37) the
org.apache.commons:commons-text JAR is missing from the binary distribution.
Which causes the floowing exceptions say for the following query executed on
the client node: "SELECT sum(fld) FROM Item"
{noformat}
[2025-02-03T13:02:52,932][WARN
][calciteQry-#117%isetest.perftests.sql_test.SqlSimpleTest.sum_indexed_test.range.10M.engine.calcite.ignite_version.ignite-2.17.0%][QueryTaskExecutorImpl]
Uncaught exception
org.apache.ignite.IgniteException: Unexpected exception
at
org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:329)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.lambda$init$2(ExchangeServiceImpl.java:195)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.message.MessageServiceImpl.onMessageInternal(MessageServiceImpl.java:233)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.message.MessageServiceImpl.lambda$onMessage$0(MessageServiceImpl.java:211)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:73)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
[?:?]
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
[?:?]
at java.base/java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: java.lang.NoClassDefFoundError:
org/apache/commons/text/similarity/LevenshteinDistance
at
org.apache.calcite.runtime.SqlFunctions.<clinit>(SqlFunctions.java:169)
~[calcite-core-1.37.0.jar:1.37.0]
at SC.apply(Unknown Source) ~[?:?]
at
org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.AccumulatorsFactory$AccumulatorWrapperImpl.end(AccumulatorsFactory.java:333)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getOnReducer(HashAggregateNode.java:381)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getRows(HashAggregateNode.java:291)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.flush(HashAggregateNode.java:196)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.end(HashAggregateNode.java:166)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.pushUnordered(Inbox.java:324)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.push(Inbox.java:203)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.onBatchReceived(Inbox.java:177)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:324)
~[ignite-calcite-2.17.0.jar:2.17.0]
... 7 more
Caused by: java.lang.ClassNotFoundException:
org.apache.commons.text.similarity.LevenshteinDistance
at
java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)
~[?:?]
at
java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
~[?:?]
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)
~[?:?]
at
org.apache.calcite.runtime.SqlFunctions.<clinit>(SqlFunctions.java:169)
~[calcite-core-1.37.0.jar:1.37.0]
at SC.apply(Unknown Source) ~[?:?]
at
org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.AccumulatorsFactory$AccumulatorWrapperImpl.end(AccumulatorsFactory.java:333)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getOnReducer(HashAggregateNode.java:381)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getRows(HashAggregateNode.java:291)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.flush(HashAggregateNode.java:196)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.end(HashAggregateNode.java:166)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.pushUnordered(Inbox.java:324)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.push(Inbox.java:203)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.onBatchReceived(Inbox.java:177)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:324)
~[ignite-calcite-2.17.0.jar:2.17.0]
... 7 more
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)