You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "任建亭 (Jira)" <ji...@apache.org> on 2021/12/21 10:43:00 UTC
[jira] [Updated] (HIVE-14249) Add simple materialized views with manual rebuilds

     [ https://issues.apache.org/jira/browse/HIVE-14249?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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

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

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

  was:
This patch is a start at implementing simple views. It doesn't have enough testing yet (e.g. there's no negative testing). And I know it fails in the partitioned case. I suspect things like security and locking don't work properly yet either. But I'm posting it as a starting point.

In this initial patch I'm just handling simple materialized views with manual rebuilds. In later JIRAs we can add features such as allowing the optimizer to rewrite queries to use materialized views rather than tables named in the queries, giving the optimizer the ability to determine when a materialized view is stale, etc.

Also, I didn't rebase this patch against trunk after the migration from svn->git so it may not apply cleanly.


> Add simple materialized views with manual rebuilds
> --------------------------------------------------
>
>                 Key: HIVE-14249
>                 URL: https://issues.apache.org/jira/browse/HIVE-14249
>             Project: Hive
>          Issue Type: New Feature
>          Components: Materialized views, Parser
>            Reporter: Alan Gates
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Major
>              Labels: TODOC2.3
>             Fix For: 2.3.0
>
>         Attachments: HIVE-10459.2.patch, HIVE-14249.05.patch, HIVE-14249.06.patch
>
>
> ‎此修补程序是从实现简单视图开始的。它没有足够的测试（例如，没有阴性测试）。我知道它在分区的情况下失败了。我怀疑像安全和锁定这样的事情也无法正常工作。但我把它作为一个起点发布。‎
> ‎在这个初始补丁中，我只是通过手动重新生成来处理简单的实例化视图。在以后的JIRA中，我们可以添加一些功能，例如允许优化程序重写查询以使用实例化视图而不是查询中命名的表，从而使优化程序能够确定实例化视图何时过时等。‎
> ‎另外，在从 svn->git 迁移后，我没有针对主干重新调整此修补程序的基础，因此它可能无法完全应用。‎



--
This message was sent by Atlassian Jira
(v8.20.1#820001)