Suggestion to standardize delete query syntax

[Sangeeta Gulia]

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

[Sangeeta Gulia]

Change required to solve it is very small, if it is ok with you, Can i
raise PR for this?

On Tue, Aug 29, 2017 at 11:42 AM, Sangeeta Gulia <[e-mail]>
wrote:

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


--
Warm Regards,

Sangeeta Gulia
Software Consultant