vmarchaud opened a new issue, #9812: URL: https://github.com/apache/pinot/issues/9812
Slack ref: https://apache-pinot.slack.com/archives/C011C9JHN7R/p1668446311267249 We just upgraded to 0.11 from 0.10 and some of previously working queries started to fail: ```sql SELECT groovy('{"returnType":"STRING","isSingleValue":true}', 'arg0.toList().join('';'')', JSONEXTRACTKEY("labels", '$.*')) FROM datasource_609bc534f46c000300b29dcf_REALTIME WHERE (("timestamp" >= 1667833781565)) AND "labels" != '{}' GROUP BY 1 LIMIT 0,100 ``` Yield: ``` [ { "errorCode": 200, "message": "QueryExecutionError:\njava.lang.NullPointerException" }, { "errorCode": 200, "message": "QueryExecutionError:\njava.lang.NullPointerException" } ] ``` In the broker log: ``` 2022/11/14 17:06:15.764 INFO [BaseBrokerRequestHandler] [jersey-server-managed-async-executor-76] requestId=64701,table=datasource_609bc534f46c000300b29dcf_REALTIME,timeMs=50,docs=60000/374868,entries=204226/60000,segments(queried/processed/matched/consumingQueried/consumingProcessed/consumingMatched/unavailable):4/4/4/1/1/1/0,consumingFreshnessTimeMs=1668393656448,servers=2/2,groupLimitReached=false,brokerReduceTimeMs=0,exceptions=2,serverStats=(Server=SubmitDelayMs,ResponseDelayMs,ResponseSize,DeserializationTimeMs,RequestSentDelayMs);10.1.1.13_R=0,48,307,0,-1;10.1.1.14_R=0,42,299,0,-1,offlineThreadCpuTimeNs(total/thread/sysActivity/resSer):0/0/0/0,realtimeThreadCpuTimeNs(total/thread/sysActivity/resSer):0/0/0/0,clientIp=unknown,query=SELECT groovy('{"returnType":"STRING","isSingleValue":true}', 'arg0.toList().join('';'')', JSONEXTRACTKEY("labels", '$.*')) FROM datasource_609bc534f46c000300b29dcf_REALTIME WHERE (("timestamp" >= 1667833781565)) AND "labels" != '{}' GROUP BY 1 LIM IT 0,100 ``` However the query works if we remove the `GROUP BY 1` but thats doesn't get the correct result anyway. I suspect that comes from the groovy part but again this was working previously in 0.10 -- 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.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
