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`.
   
![image](https://user-images.githubusercontent.com/8898158/69841697-3a907d00-129b-11ea-95e8-0fd684b40063.png)
   
   Extensions are loaded in all nodes.
   
![image](https://user-images.githubusercontent.com/8898158/69841759-7b889180-129b-11ea-8c34-94fdfae004c7.png)
   
   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:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to