[ https://issues.apache.org/jira/browse/IGNITE-24376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sergey Korotkov updated IGNITE-24376: ------------------------------------- Summary: Calcite. ClassNotFoundException in queries with SUM (missing commons-text JAR) (was: Calcite. ClassNotFoundException in queries with SUM (missing ) > Calcite. ClassNotFoundException in queries with SUM (missing commons-text JAR) > ------------------------------------------------------------------------------ > > Key: IGNITE-24376 > URL: https://issues.apache.org/jira/browse/IGNITE-24376 > Project: Ignite > Issue Type: Bug > Reporter: Sergey Korotkov > Priority: Critical > > 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)