Suggestion to standardize delete query syntax

Posted by Sangeeta Gulia on Aug 29, 2017; 6:12am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Suggestion-to-standardize-delete-query-syntax-tp20863.html

Hi All,

I have found one issue with the syntax of delete query.

1) Syntax of delete query : delete from <tablename>; (used in carbondata
and hive)
Example:
delete from <tablename> where customer_id = 1000;
2) Syntax of delete by segment id/starttime : (used in carbondata in case
of segments)
Example :
delete from table <tablename> where segment.id in(0);
delete from table <tablename> where segment.starttime before
'date_type_value'
The first query doesn't use the keyword 'table' whereas the second query
which deletes segment uses it.
I suggest that carbondata can adopt a standardized syntax for the delete
query by following hive syntax.

-- Warm Regards,
Sangeeta Gulia