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

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.1.0, 4.0.0
    • None
    • 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.1.patch
          5 kB
          Jason Dere
        2. HIVE-19096.2.patch
          5 kB
          Jason Dere
        3. HIVE-19096.3.patch
          5 kB
          Jason Dere

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: