[CARBONDATA-1270] Documentation update for Delete by ID and DATE syntax and example
This closes #1141 Project: http://git-wip-us.apache.org/repos/asf/carbondata/repo Commit: http://git-wip-us.apache.org/repos/asf/carbondata/commit/5af529e0 Tree: http://git-wip-us.apache.org/repos/asf/carbondata/tree/5af529e0 Diff: http://git-wip-us.apache.org/repos/asf/carbondata/diff/5af529e0 Branch: refs/heads/datamap Commit: 5af529e0e0ab54fb592774bd4f6eae11d5000187 Parents: 05de7fd Author: sgururajshetty <sgururajshe...@gmail.com> Authored: Thu Jul 6 11:53:38 2017 +0530 Committer: Venkata Ramana G <ramana.gollam...@huawei.com> Committed: Thu Jul 6 16:22:33 2017 +0530 ---------------------------------------------------------------------- docs/dml-operation-on-carbondata.md | 17 ++++++++--------- 1 file changed, 8 insertions(+), 9 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/carbondata/blob/5af529e0/docs/dml-operation-on-carbondata.md ---------------------------------------------------------------------- diff --git a/docs/dml-operation-on-carbondata.md b/docs/dml-operation-on-carbondata.md index 45f7464..4928098 100644 --- a/docs/dml-operation-on-carbondata.md +++ b/docs/dml-operation-on-carbondata.md @@ -262,14 +262,13 @@ Using this segment ID, you can remove the segment. The following command will get the segmentID. ``` -SHOW SEGMENTS FOR Table dbname.tablename LIMIT number_of_segments +SHOW SEGMENTS FOR Table [db_name.]table_name LIMIT number_of_segments ``` After you retrieve the segment ID of the segment that you want to delete, execute the following command to delete the selected segment. ``` -DELETE SEGMENT segment_sequence_id1, segments_sequence_id2, .... -FROM TABLE tableName +DELETE FROM TABLE [db_name.]table_name WERE SEGMENT.ID IN (segment_id1, segments_id2, ....) ``` ### Parameter Description @@ -282,8 +281,8 @@ FROM TABLE tableName ### Example: ``` -DELETE SEGMENT 0 FROM TABLE CarbonDatabase.CarbonTable; -DELETE SEGMENT 0.1,5,8 FROM TABLE CarbonDatabase.CarbonTable; +DELETE FROM TABLE CarbonDatabase.CarbonTable WHERE SEGMENT.ID IN (0); +DELETE FROM TABLE CarbonDatabase.CarbonTable WHERE SEGMENT.ID IN (0,5,8); ``` NOTE: Here 0.1 is compacted segment sequence id. @@ -293,8 +292,8 @@ This command will allow to delete the CarbonData segment(s) from the store based The segment created before the particular date will be removed from the specific stores. ``` -DELETE SEGMENTS FROM TABLE [db_name.]table_name -WHERE STARTTIME BEFORE DATE_VALUE +DELETE FROM TABLE [db_name.]table_name +WHERE SEGMENT.STARTTIME BEFORE DATE_VALUE ``` ### Parameter Description @@ -308,8 +307,8 @@ WHERE STARTTIME BEFORE DATE_VALUE ### Example: ``` - DELETE SEGMENTS FROM TABLE CarbonDatabase.CarbonTable - WHERE STARTTIME BEFORE '2017-06-01 12:05:06'; + DELETE FROM TABLE CarbonDatabase.CarbonTable + WHERE SEGMENT.STARTTIME BEFORE '2017-06-01 12:05:06'; ``` ## Update CarbonData Table