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

Support multiple parameters in count(distinct col1, col2, ..)

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.0-incubating
    • Component/s: None
    • Labels:

      Description

      Currently for sql like – select count(distinct seller_id, lstg_format_name) from test_kylin_fact

      Will result –
      org.eigenbase.sql.validate.SqlValidatorException <init>
      SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Invalid number of arguments to function 'COUNT'. Was expecting 1 arguments

      Could optiq support multiple parameters in count(distinct ...) ?

      ---------------- Imported from GitHub ----------------
      Url: https://github.com/julianhyde/optiq/issues/300
      Created by: liyang-gmt8
      Labels: enhancement,
      Created at: Thu Jun 12 12:00:44 CEST 2014
      State: open

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              github-import GitHub Import
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: