Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3446

Materialized views

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • Impala 2.5.0
    • None
    • Frontend
    • None

    Description

      This JIRA is a placeholder for this big topic.
      Some user stories I can imagine under the epic:

      1. materialized view is a CTAS where the SELECT is saved in the HMS and can be rerun by a simple command
      2. materialized view detects that the source data has changed and falls back to be a view instead of SELECT *
      3. materialized view detects that the source data has changed and reruns the CTAS automatically
      4. ... reruns only the necessary changes (e.g. if only some of the partitions change)
      5. Impala and Hive to have common semantics of materialized views (https://issues.apache.org/jira/browse/HIVE-10459)
      6. materialized view stores extra statistics that help the optimizer, storing the full resultset is optional
      7. query optimizer checks for every query whether part of the query plan can be covered by an existing materialized view

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              szama_impala_6295 Marcell Szabo
              Votes:
              2 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated: