[ https://issues.apache.org/jira/browse/HIVE-28198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17837622#comment-17837622 ]
Butao Zhang edited comment on HIVE-28198 at 4/16/24 9:27 AM: ------------------------------------------------------------- {code:java} <property> <name>metastore.metadata.transformer.class</name> <value> </value> </property> {code} You can disable the HMS transformer feature by set the *metastore.metadata.transformer.class* value to {*}empty{*}. was (Author: zhangbutao): {code:java} <property> <name>metastore.metadata.transformer.class</name> <value> </value> </property> {code} You can disable the HMS transformer feature by set the *metastore.metadata.transformer.class* value to \{*}empty{*}. > Trino table is recognized as EXTERNAL_TABLE regardless of external_location > parameter > ------------------------------------------------------------------------------------- > > Key: HIVE-28198 > URL: https://issues.apache.org/jira/browse/HIVE-28198 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 4.0.0 > Reporter: Mladjan Gadzic > Priority: Major > > {code:java} > trino > create table hive.default.test_table(id int);{code} > {code:java} > trino> delete from hive.default.test_table; > Query 20240402_103228_00042_hm8m3, FAILED, 1 node Splits: 1 total, 0 done > (0.00%) 0.08 [0 rows, 0B] [0 rows/s, 0B/s] > Query 20240402_103228_00042_hm8m3 failed: Cannot delete from non-managed Hive > table{code} > This behavior is tested and works as expected in Hive 3. Table type is stored > in HMS DB in {{TBLS}} table {{TBL_TYPE}} field. For Hive 3 value is > MANAGED_TABLE and EXTERNAL_TABLE for Hive 4. > -- This message was sent by Atlassian Jira (v8.20.10#820010)