[
https://issues.apache.org/jira/browse/HIVE-27265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Simhadri Govindappa updated HIVE-27265:
---------------------------------------
Summary: Ensure table properties are case-insensitive when translating hms
property to iceberg property (was: Ensure iceberg table properties are
case-insensitive)
> Ensure table properties are case-insensitive when translating hms property to
> iceberg property
> ----------------------------------------------------------------------------------------------
>
> Key: HIVE-27265
> URL: https://issues.apache.org/jira/browse/HIVE-27265
> Project: Hive
> Issue Type: Improvement
> Reporter: Simhadri Govindappa
> Assignee: Simhadri Govindappa
> Priority: Major
>
>
> In this example, the "format-version" case is modified to upper case and the
> query fails.
>
> {noformat}
> >>>CREATE EXTERNAL TABLE TBL5(ID INT, NAME STRING) PARTITIONED BY (DEPT
> >>>STRING) STORED BY ICEBERG STORED AS PARQUET TBLPROPERTIES
> >>>('format-version'='2');
> OK
> >>>insert into tbl5 values (1, 'one', 50), (2, 'two', 51), (3, 'three', 52),
> >>>(4, 'four', 53), (5, 'five', 54), (111, 'one', 55), (333, 'two', 56);
> OK
> >>>delete from tbl5 where name in ('one', 'four') or id = 22;
> OK{noformat}
>
> {noformat}
> >>> CREATE EXTERNAL TABLE TBL6(ID INT, NAME STRING) PARTITIONED BY (DEPT
> >>> STRING) STORED BY ICEBERG STORED AS PARQUET TBLPROPERTIES
> >>> ('FORMAT-VERSION'='2');
> ok
> >>>insert into tbl6 values (1, 'one', 50), (2, 'two', 51), (3, 'three', 52),
> >>>(4, 'four', 53), (5, 'five', 54), (111, 'one', 55), (333, 'two', 56);
> ok
> >>>delete from tbl6 where name in ('one', 'four') or id = 22;
> Error: Error while compiling statement: FAILED: SemanticException [Error
> 10297]: Attempt to do update or delete on table tbl6 that is not
> transactional (state=42000,code=10297){noformat}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
