[jira] [Commented] (HIVE-28198) Trino table is recognized as EXTERNAL_TABLE regardless of external_location parameter

["Butao Zhang (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-28198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17837622#comment-17837622 ] 

Butao Zhang commented on HIVE-28198:
------------------------------------

{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)