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

Support derived tables in FROM clause that needs extra steps of client-side aggregation or other processing

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0.0, 4.0.0
    • 4.2.0, 3.2.0
    • None
    • None

    Description

      Groupby in both outer and inner queries cannot be flattened. We can apply an extra step of client-side aggregation to handle such cases.
      See DerivedTableIT.java for all those examples that are currently not supported.

      Attachments

        1. 944.patch
          108 kB
          Wei Xue
        2. 944-3.patch
          118 kB
          Wei Xue

        Issue Links

          Activity

            People

              maryannxue Wei Xue
              maryannxue Wei Xue
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

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