[jira] [Work logged] (HIVE-26578) Enable Iceberg storage format for materialized views

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-26578?focusedWorklogId=830261&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-830261 ]

ASF GitHub Bot logged work on HIVE-26578:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 01/Dec/22 08:06
            Start Date: 01/Dec/22 08:06
    Worklog Time Spent: 10m 
      Work Description: kasakrisz opened a new pull request, #3823:
URL: https://github.com/apache/hive/pull/3823

   <!--
   Thanks for sending a pull request!  Here are some tips for you:
     1. If this is your first time, please read our contributor guidelines: https://cwiki.apache.org/confluence/display/Hive/HowToContribute
     2. Ensure that you have created an issue on the Hive project JIRA: https://issues.apache.org/jira/projects/HIVE/summary
     3. Ensure you have added or run the appropriate tests for your PR: 
     4. If the PR is unfinished, add '[WIP]' in your PR title, e.g., '[WIP]HIVE-XXXXX:  Your PR title ...'.
     5. Be sure to keep the PR description updated to reflect all changes.
     6. Please write your PR title to summarize what this PR proposes.
     7. If possible, provide a concise example to reproduce the issue for a faster review.
   
   -->
   
   ### What changes were proposed in this pull request?
   * Treat creation materialized view as ctas since technically they are similar. MV creation has some extra steps like persisting creation metadata and the view location should not be translated by metastore translator
   * If storage handler is specified: pass the generated view location to storage handler at compile time and at commit in move task
   * Insert MV create task to create the view and update MV task to enable the view usage for automatic query rewrites in TaskCompiler when direc insert is enabled by the storage handler.
   
   ### Why are the changes needed?
   Improve MV functionality by enabling iceberg storage of the view data.
   
   ### Does this PR introduce _any_ user-facing change?
   Iceberg storage format my appear in outputs of sql statements like `DESCRIBE FORMATTED` and `EXPLAIN CREATE/ALTER MATERIALIZED VIEW`
   
   ### How was this patch tested?
   ```
   mvn test -Dtest.output.overwrite -Dtest=TestIcebergCliDriver -Dqfile=mv_iceberg_orc2.q -pl itests/qtest-iceberg -Piceberg -Pitests -Drat.skip
   ```




Issue Time Tracking
-------------------

            Worklog Id:     (was: 830261)
    Remaining Estimate: 0h
            Time Spent: 10m

> Enable Iceberg storage format for materialized views
> ----------------------------------------------------
>
>                 Key: HIVE-26578
>                 URL: https://issues.apache.org/jira/browse/HIVE-26578
>             Project: Hive
>          Issue Type: Improvement
>          Components: Materialized views
>            Reporter: Krisztian Kasa
>            Assignee: Krisztian Kasa
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> {code}
> create materialized view mat1 stored by iceberg stored as orc tblproperties ('format-version'='1') as
> select tbl_ice.b, tbl_ice.c from tbl_ice where tbl_ice.c > 52;
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)