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

Reply via email to