Apache Druid

hi <@U032X7PGEN4>! I’m looking into the same usecase as well. Currently there’s no API in Druid that provides you with all the types and function information. We’re thinking it’d be nice to store the information in the sys table/INFORMATION_SCHEMA and make it available via the SQL query interface. I will open a GitHub proposal soon and link it here when it’s ready. Thanks for asking!

I wish. This would be super helpful to the web console

currently the console has a script that scrapes the docs `.md` files to locate all the functions at compile time <https://github.com/apache/druid/blob/f6a0888bc07396a4afab91f5cb576793e26275d2/web-console/script/create-sql-docs.js#L66>

it would be soooo cool if it could instead query for them at runtime as well as any functions added by extensions

“tell me about all the types and Druid operators in my cluster” even if I have custom things loaded through an extension

Thanks <@U04CLDXP7HC> <@U030W50CNAC>

Our use case is something similar. We have own custom web query editor where we would like to provide auto-completion support for functions that are available. This will help a lot.

Would it make it to 0.26 by any chance?

The 26.0 release is already out, so sadly has to be in the next one :slightly_smiling_face:

<@U032X7PGEN4> , for now, you might make use of the file I linked (or the file it generates)

Thanks a lot <@U030W50CNAC>, this is helpful while we await the API. Appreciate it!

I opened a GitHub issue to expose Druid functions. Let me know if you’ve any questions or feedback: <https://github.com/apache/druid/issues/14346>. Thanks!