Mladjan Gadzic created HIVE-28198:
-------------------------------------
Summary: 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
{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_TABLEfor Hive 4.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
