You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2017/01/18 19:16:26 UTC

[jira] [Created] (CALCITE-1588) Add SQL syntax to allow approximate LIMIT and distinct-COUNT

Julian Hyde created CALCITE-1588:
------------------------------------

             Summary: 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.3.4#6332)