ABHISHEK KUMAR GUPTA created HIVE-23740:
-------------------------------------------
Summary: [Hive]delete from <tablename>; without where clause not
giving correct error msg
Key: HIVE-23740
URL: https://issues.apache.org/jira/browse/HIVE-23740
Project: Hive
Issue Type: Bug
Components: Hive
Affects Versions: 3.1.0
Reporter: ABHISHEK KUMAR GUPTA
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>;
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
