saurabhd336 opened a new pull request, #11455: URL: https://github.com/apache/pinot/pull/11455
```select arrayAverage(intMv) as col from transformsAndAggregationsTest``` fails with ``` [{"errorCode":150,"message":"SQLParsingError:\nError composing query plan for 'SET \"useMultistageEngine\"=true;\nselect col from (select arrayLength(\"t1\".\"floatMv\") as col, \"t1\".\"$docId\" as docId from transformsAndAggregationsTest t1 join transformsAndAggregationsTest t2 on \"t1\".\"$docId\" = \"t2\".\"$docId\") order by docId limit 100': From line 2, column 25 to line 2, column 51: No match found for function signature arrayLength(<REAL ARRAY>)'\norg.apache.pinot.query.QueryEnvironment.planQuery(QueryEnvironment.java:180)\norg.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:137)\norg.apache.pinot.broker.requesthandler.BaseBrokerRequestHandler.handleRequest(BaseBrokerRequestHandler.java:263)\norg.apache.pinot.broker.requesthandler.BrokerRequestHandler.handleRequest(BrokerRequestHandler.java:48)\nFrom line 2, column 25 to line 2, column 51: No match found for function signature arrayLength(<REAL ARRAY>)\nj dk.internal.reflect.GeneratedConstructorAccessor116.newInstance(Unknown Source)\njava.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\njava.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)\norg.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:505)\nNo match found for function signature arrayLength(<REAL ARRAY>)\njdk.internal.reflect.GeneratedConstructorAccessor115.newInstance(Unknown Source)\njava.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\njava.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)\norg.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:505)\n"}] ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org