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

Reply via email to