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

Reply via email to