[
https://issues.apache.org/jira/browse/HIVE-23740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
wenjun ma reassigned HIVE-23740:
--------------------------------
Assignee: wenjun ma
> [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
> Assignee: wenjun ma
> Priority: Minor
>
> 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)
