Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
3.1.0
-
None
-
None
Description
Created Hive table from Hive
Inserted data
and fire delete from <tablename>;
CREATE TABLE insert_only (key int, value string) STORED AS ORC
TBLPROPERTIES ("transactional"="true", "transactional_properties"="insert_only");
INSERT INTO insert_only VALUES (13,'BAD'), (14,'SUCCESS');
delete from insert_only;
Error throws:
Error: Error while compiling statement: FAILED: SemanticException [Error 10414]: Attempt to do update or delete on table hive.insert_only that is insert-only transactional (state=42000,code=10414)
Expectation:
Should throw as where clause is missing because to delete all the content of table hive provides truncate table <tablename>;