Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-18

Distinct based aggregations not working correctly when query contains ORDER BY

Attach filesAttach ScreenshotVotersStop watchingWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • None
    • None
    • Cloudera 4.5

    Description

      I run the below query and not getting the expected result...

      SELECT "tbp_VPN" as "Part Number",Count(distinct "tbpEGN") as "egn Number" FROM "AL_V_PNO_DEMO" WHERE ("tbpVPN" is not null) GROUP BY "tbp_VPN" ORDER BY 'egn Number' DESC /* +SKIP_SCAN */;

      the above query executes fine but the sorting is not done for ORDER BY column..Is its problem with the Query or Its some Bug in Phoenix.

      Attachments

        Activity

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

          People

            anoop.hbase Anoop Sam John
            s@r@v@n@n saravanan
            Votes:
            0 Vote for this issue
            Watchers:
            6 Stop watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 12h
                12h
                Remaining:
                Remaining Estimate - 12h
                12h
                Logged:
                Time Spent - Not Specified
                Not Specified

                Slack

                  Issue deployment