Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-11752

Pre-materializing complex CTE queries

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.1.0
    • 2.1.0
    • Query Processor

    Description

      Currently, hive regards CTE clauses as a simple alias to the query block, which makes redundant works if it's used multiple times in a query. This introduces a reference threshold for pre-materializing the CTE clause as a volatile table (which is not exists in any form of metastore and just accessible from QB).

      Attachments

        1. HIVE-11752.2.patch.txt
          64 kB
          Navis Ryu
        2. HIVE-11752.1.patch.txt
          64 kB
          Navis Ryu
        3. HIVE-11752.05.patch
          262 kB
          jcamachorodriguez
        4. HIVE-11752.04.patch
          115 kB
          jcamachorodriguez
        5. HIVE-11752.03.patch
          112 kB
          jcamachorodriguez

        Issue Links

          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-11049 With Clause should cache data & reuse

          • Major - Major loss of function.
          • Resolved
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-24081 Enable pre-materializing CTEs referenced in scalar subqueries

          • Major - Major loss of function.
          • Closed
          links to

          Web Link RB link

          Activity

            People

              jcamacho Jesús Camacho Rodríguez
              navis Navis Ryu
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: