sascha-coenen opened a new issue #9419: SQL: top-level sketch functions do not return sketches URL: https://github.com/apache/druid/issues/9419 ### Affected Version 0.17.0 ### Description The following query should be returning materialized sketches in the form of base64 encoded strings such that the results can be exported, forklifted and later on used in other contexts. The Druid documentation states that the following three functions would return sketches, but if they are used at top-level as in the following example, they either return counts or unique counts but no sketches: ``` SELECT DS_HLL(countryName), DS_THETA(countryName), DS_QUANTILES_SKETCH(countryName) FROM wikipedia ``` This yields 105, 105.0, 2383 The documentation states: > DS_HLL(expr, [lgK, tgtHllType]) | Creates an HLL sketch on the values of expr > DS_THETA(expr, [size]) | Creates a Theta sketch on the values of expr > DS_QUANTILES_SKETCH(expr, [k]) | Creates a Quantiles sketch on the values of expr
---------------------------------------------------------------- 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]
