You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Krisztian Kasa (Jira)" <ji...@apache.org> on 2023/02/13 09:31:00 UTC

[jira] [Created] (HIVE-27073) Apply SerDe properties when creating materialized view

Krisztian Kasa created HIVE-27073:
-------------------------------------

             Summary: Apply SerDe properties when creating materialized view
                 Key: HIVE-27073
                 URL: https://issues.apache.org/jira/browse/HIVE-27073
             Project: Hive
          Issue Type: Improvement
          Components: Iceberg integration, Materialized views
            Reporter: Krisztian Kasa
            Assignee: Krisztian Kasa


{code}
create table tbl_ice(a int, b string, c int) stored by iceberg stored as orc tblproperties ('format-version'='1');

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}

Materialized view {{mat1}} should use {{ORC}} file format.



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