[jira] [Commented] (HIVE-23740) [Hive]delete from ; without where clause not giving correct error msg

["wenjun ma (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-23740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17160299#comment-17160299 ] 

wenjun ma commented on HIVE-23740:
----------------------------------

Hi [~abhishek.akg], It should be as design. For insert_only table, you can only inert and drop it. 

> [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)