Add NULL support to rollup(hyperloglog)
#649
Labels
feature-request
And area of analysis that could be made easier
rollup(hyperloglog)
#649
Is your feature request related to a problem? Please describe.
Add NULL support to
rollup(hyperloglog)
to improve user experience.Describe the solution you'd like
rollup(hyperloglog)
should simply ignore NULL hyperloglog objects instead of returning an error. For Toolkit 1.12.0, the returned error is:Consider this query:
It should return the same value as this query as the second
hyperloglog
object will be NULL:Describe alternatives you've considered
An alternative is to do nothing and ask the user to always include
FILTER (WHERE hll IS NOT NULL)
clause ifhll
can be null. For the example above, the query would look like this,The alternative works, it's just more boilerplate SQL code to write.
The text was updated successfully, but these errors were encountered: