NikitaElmanov commented on issue #12699: URL: https://github.com/apache/druid/issues/12699#issuecomment-1165268999
> have you loaded the datasketches extension in your cluster as mentioned in Yes, I have this extension and in UI it's shown: <img width="1147" alt="Снимок экрана 2022-06-24 в 09 33 17" src="https://user-images.githubusercontent.com/39399744/175476719-88086c41-67a3-445e-81f8-f7ee6e69bc28.png";> Reduced all unneed code in sql query and ``` SELECT DS_GET_QUANTILE(sla, 0.99) as "q", name as "service" FROM SYTESTER_DRUID ``` returns for me: _Error: Unknown exception Error while applying rule DruidQueryRule(SELECT_PROJECT), args [rel#33886:LogicalProject.NONE.[](input=RelSubset#33885,q=DS_GET_QUANTILE($4, 0.99:DECIMAL(3, 2))), rel#33896:DruidQueryRel.NONE.[](query={"queryType":"scan","dataSource":{"type":"table","name":"SYTESTER_DRUID"},"intervals":{"type":"intervals","intervals":["-146136543-09-08T08:23:32.096Z/146140482-04-24T15:36:27.903Z"]},"virtualColumns":[],"resultFormat":"compactedList","batchSize":20480,"order":"none","filter":null,"columns":["__time","message","name","rnd","sla","status","value"],"legacy":false,"context":{"sqlOuterLimit":101,"sqlQueryId":"3d87fef6-4c5c-4044-9227-f5c681c24ed6"},"descending":false,"granularity":{"type":"all"}},signature={__time:LONG, message:STRING, name:STRING, rnd:LONG, sla:DOUBLE, status:LONG, value:STRING})] java.lang.RuntimeException_ And this query: ``` SELECT APPROX_QUANTILE(sla, 0.99) as "q", name as "service" FROM SYTESTER_DRUID ``` returns: _Error: Plan validation failed org.apache.calcite.runtime.CalciteContextException: From line 28, column 2 to line 28, column 27: No match found for function signature APPROX_QUANTILE(\<NUMERIC>, \<NUMERIC>) org.apache.calcite.tools.ValidationException_ -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
![https://user-images.githubusercontent.com/39399744/175476719-88086c41-67a3-445e-81f8-f7ee6e69bc28.png"](https://user-images.githubusercontent.com/39399744/175476719-88086c41-67a3-445e-81f8-f7ee6e69bc28.png"){kind=link}