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

Make spilling to disk for order/group by configurable

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.15.0, 5.1.0, 4.14.2, 5.0.1
    • None
    • None

    Description

      We've observed that large queries, doing order/group by leading to issues on the regionserver (crashes/long gc pauses/file handler exhaustion etc.). We should make spilling to disk configurable and in case its disabled, fail the query once it hits the spilling limit on any of the region servers. Also make spooling threshold server-side property only to prevent clients from controlling memory allocation on the rs side.

      Attachments

        1. PHOENIX-5131-master-v4.patch
          88 kB
          Abhishek Singh Chouhan
        2. PHOENIX-5131-master-v3.patch
          89 kB
          Abhishek Singh Chouhan
        3. PHOENIX-5131-master-v2.patch
          82 kB
          Abhishek Singh Chouhan
        4. PHOENIX-5131-master-v2.patch
          82 kB
          Abhishek Singh Chouhan
        5. PHOENIX-5131-master.patch
          81 kB
          Abhishek Singh Chouhan
        6. PHOENIX-5131-master.patch
          81 kB
          Abhishek Singh Chouhan
        7. PHOENIX-5131-4.x-HBase-1.4.patch
          89 kB
          Abhishek Singh Chouhan
        8. PHOENIX-5131-4.x-HBase-1.3.patch
          89 kB
          Abhishek Singh Chouhan
        9. PHOENIX-5131-4.x-HBase-1.2.patch
          89 kB
          Abhishek Singh Chouhan

        Activity

          People

            abhishek.chouhan Abhishek Singh Chouhan
            abhishek.chouhan Abhishek Singh Chouhan
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: