[
https://issues.apache.org/jira/browse/CALCITE-1588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16107560#comment-16107560
]
Gian Merlino commented on CALCITE-1588:
---------------------------------------
In Druid at least, you don't get to specify the accuracy you want. HLL in
general does have some parameters but Druid uses hard-coded constants for them.
> Add SQL syntax to allow approximate LIMIT and distinct-COUNT
> ------------------------------------------------------------
>
> Key: CALCITE-1588
> URL: https://issues.apache.org/jira/browse/CALCITE-1588
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
>
> Add SQL syntax to allow approximate LIMIT and distinct-COUNT. These will set
> the properties specified in CALCITE-1587. By default the properties are
> false, so the query will return exact results.
> Exact syntax is to be decided. It could be at the top of the query (therefore
> affecting every LIMIT or aggregate in the query) or it could be more
> localized (e.g. {{COUNT(DISTINCT customerId) APPROXIMATE (WITHIN 10
> PERCENT)}}).
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
