[
https://issues.apache.org/jira/browse/HIVE-28198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mladjan Gadzic updated HIVE-28198:
----------------------------------
Description:
{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.
was:
{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.
> 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)
