[HIVE-27073] Apply SerDe properties when creating materialized view

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: Iceberg integration, Materialized views
• Labels: pull-request-available
• Assignee: Krisztian Kasa Assign to me
• Reporter: Krisztian Kasa
• Created: 13/Feb/23 09:30
• Updated: 15/Feb/23 14:48
• Resolved: 15/Feb/23 08:07

Description

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;

Materialized view mat1 should use ORC file format.

Issue Links

• fixes: HIVE-27066 Fix mv_iceberg_partitioned_orc and mv_iceberg_partitioned_orc2
• links to: GitHub Pull Request #4059