This message was deleted.

This is probably a better question for the #C030CMF6B70 channel. I don't know the details, but it will likely require work on the calcite side of things in order to add a function to SQL.

hello @Kumar Saket, you’d need to implement the

SqlAggregator

interface and register it in your custom extension. You could take a look at how it’s done in the datasketches core extension for

APPROX_COUNT_DISTINCT_DS_THETA

. Then the wire up is complete here, so Calcite’s operator table is aware of the SQL functions from the datasketches extension. Hope that helps!

Sure @Sergio Ferragut - Will keep that in mind for the next time. Thanks @Abhishek Balaji Radhakrishnan - for the prompt response. Really appreciate it. 🙏