You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Simhadri Govindappa (Jira)" <ji...@apache.org> on 2023/04/14 22:37:00 UTC
[jira] [Updated] (HIVE-27265) Ensure table properties are case-insensitive when translating hms property to iceberg property
[ 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)