Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-18513 Query results caching
  3. HIVE-19096

query result cache interferes with explain analyze

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.1.0, 4.0.0
    • Component/s: None
    • Labels:
      None

      Description

      if result cache is active; the explain analyze doesn't really return usefull informations; even for unseen queries the result is like this:

      +----------------------------------------+
      |                Explain                 |
      +----------------------------------------+
      | Stage-0                                |
      |   Fetch Operator                       |
      |     Cached Query Result:true,limit:-1  |
      |                                        |
      +----------------------------------------+
      

        Attachments

        1. HIVE-19096.3.patch
          5 kB
          Jason Dere
        2. HIVE-19096.2.patch
          5 kB
          Jason Dere
        3. HIVE-19096.1.patch
          5 kB
          Jason Dere

          Activity

            People

            • Assignee:
              jdere Jason Dere
              Reporter:
              kgyrtkirk Zoltan Haindrich
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: