gianm commented on issue #8661: Druid SQL - natively support mathematical functions ROUND(), RADIANS(), EXP(), LN(), POWER(), RAND() URL: https://github.com/apache/incubator-druid/issues/8661#issuecomment-548066861 Hi @ntkawasaki, Druid does support all of those functions today except `RAND`. Most of them were added in version 0.15. (You can access old Druid docs at e.g. https://druid.apache.org/docs/0.14.0-incubating/querying/sql; note that the 0.14 docs don't include most of these functions.) I raised an issue specifically for `RAND`: https://github.com/apache/incubator-druid/issues/8789, which is still missing today. Btw, we deprecated and removed `useFallback` because it led to unscalable query plans in many cases. We found that often, queries with `useFallback` would pull all raw data into the Druid Broker and process it there, which was a bad approach for big datasets. This risk outweighed the benefits, and so we decided to implement more functionality in Druid's native query system instead of relying on SQL interpreter fallback.
---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org For additional commands, e-mail: commits-h...@druid.apache.org