Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1588

Add SQL syntax to allow approximate LIMIT and distinct-COUNT

Log workAgile BoardRank to TopRank to BottomAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      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)).

      Attachments

        Issue Links

        is related to

        Bug - A problem which impairs or prevents the functions of the product. CALCITE-2035 Add APPROX_COUNT_DISTINCT aggregate function

        • Major - Major loss of function.
        • Closed

        New Feature - A new feature of the product, which has yet to be developed. PHOENIX-3390 Custom UDAF for HyperLogLogPlus

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • In Progress

        New Feature - A new feature of the product, which has yet to be developed. PHOENIX-418 Support approximate COUNT DISTINCT

        • Blocker - Blocks development and/or testing work, production could not run
        • Resolved
        relates to

        Bug - A problem which impairs or prevents the functions of the product. CALCITE-1670 Count distinct on druid is translated to Cardinality aggregator which is approximate

        • Major - Major loss of function.
        • Open

        Bug - A problem which impairs or prevents the functions of the product. CALCITE-1587 Druid adapter: topN returns approximate results

        • Major - Major loss of function.
        • Closed

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned Assign to me
            julianhyde Julian Hyde
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Slack

                Issue deployment