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

Add simple materialized views with manual rebuilds

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersStop watchingWatchersCreate sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      ‎此修补程序是从实现简单视图开始的。它没有足够的测试（例如，没有阴性测试）。我知道它在分区的情况下失败了。我怀疑像安全和锁定这样的事情也无法正常工作。但我把它作为一个起点发布。‎

      ‎在这个初始补丁中，我只是通过手动重新生成来处理简单的实例化视图。在以后的JIRA中，我们可以添加一些功能，例如允许优化程序重写查询以使用实例化视图而不是查询中命名的表，从而使优化程序能够确定实例化视图何时过时等。‎

      ‎另外，在从 svn->git 迁移后，我没有针对主干重新调整此修补程序的基础，因此它可能无法完全应用。‎

      Attachments

        1. HIVE-10459.2.patch
          123 kB
          jcamachorodriguez
        2. HIVE-14249.05.patch
          198 kB
          jcamachorodriguez
        3. HIVE-14249.06.patch
          182 kB
          jcamachorodriguez

        Issue Links

        incorporates

        Sub-task - The sub-task of the issue HIVE-14485 Create 'materialized view' table type

        • Major - Major loss of function.
        • Resolved

        Sub-task - The sub-task of the issue HIVE-14486 Add CREATE MATERIALIZED VIEW statement

        • Major - Major loss of function.
        • Resolved

        Sub-task - The sub-task of the issue HIVE-14488 Add DROP MATERIALIZED VIEW statement

        • Major - Major loss of function.
        • Resolved

        Sub-task - The sub-task of the issue HIVE-14489 Add tests for DESCRIBE [EXTENDED|FORMATTED] statement on materialized views

        • Major - Major loss of function.
        • Resolved

        Sub-task - The sub-task of the issue HIVE-14490 Block ACID for materialized views

        • Major - Major loss of function.
        • Resolved

        Sub-task - The sub-task of the issue HIVE-14491 Implement access control for materialized views

        • Major - Major loss of function.
        • Resolved

        Sub-task - The sub-task of the issue HIVE-14492 Optimize query in CREATE MATERIALIZED VIEW statement in Calcite

        • Major - Major loss of function.
        • Resolved
        is part of

        New Feature - A new feature of the product, which has yet to be developed. HIVE-10459 Add materialized views to Hive

        • Major - Major loss of function.
        • Resolved
        is related to

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-14484 Extensions for initial materialized views implementation

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

        Web Link GitHub Pull Request #91

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            jcamacho Jesús Camacho Rodríguez Assign to me
            gates Alan Gates
            Votes:
            0 Vote for this issue
            Watchers:
            13 Stop watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment