Uploaded image for project: 'Apache Lens (Retired)'
  1. Apache Lens (Retired)
  2. LENS-905

Group by is not promoted when keys projected along with having clause

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 2.5
    • cube
    • None

    Description

      Cube rewriter rewrites query with distinct if only keys are projected and having specified. Instead it should promote group by with projected columns.

      for eg.
      cube select key1 from table having msr1 > 0
      is being rewritten to "select distinct key1 from table having sum(msr1) > 0 " but it supposed to be rewritten to
      "select key1 from table group by key1 having sum(msr1) > 0"

      Attachments

        1. LENS-905.patch
          3 kB
          SushilMohanty

        Activity

          People

            sushilmohanty SushilMohanty
            sushilmohanty SushilMohanty
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: