You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by GitBox <gi...@apache.org> on 2019/11/29 03:37:48 UTC
[GitHub] [incubator-druid] wch661 opened a new issue #8971: No match found
for function signature STDDEV_POP()
wch661 opened a new issue #8971: No match found for function signature STDDEV_POP(<NUMERIC>)
URL: https://github.com/apache/incubator-druid/issues/8971
I'm using apache druid 0.15.1.
This exception occurs when using the std function to aggregate data.
```
Unknown exception / org.apache.calcite.runtime.CalciteContextException: From line 3, column 5 to line 3, column 33: No match found for function signature STDDEV_POP(<NUMERIC>) / org.apache.calcite.tools.ValidationException
```
Sql:
```
SELECT
TIME_FLOOR("__time", 'PT1M') AS "dt_1min",
STDDEV_POP ("XXXXXXXX_Speed") AS std_1min
FROM "test"
GROUP BY TIME_FLOOR("__time", 'PT1M')
ORDER BY TIME_FLOOR("__time", 'PT1M')
```
I have read about this page: https://druid.apache.org/docs/latest/development/extensions-core/stats.html.
Added the extension `druid-stats`.

Extensions are loaded in all nodes.

But this exception still occurs when using the std function.
Can anyone help me?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org