Repository: carbondata Updated Branches: refs/heads/master 11b94dd13 -> 545e93db3
[CARBONDATA-1137]updated ddl operation-on-carbondata.md for SORT_COLUMNS This closes #1209 Project: http://git-wip-us.apache.org/repos/asf/carbondata/repo Commit: http://git-wip-us.apache.org/repos/asf/carbondata/commit/545e93db Tree: http://git-wip-us.apache.org/repos/asf/carbondata/tree/545e93db Diff: http://git-wip-us.apache.org/repos/asf/carbondata/diff/545e93db Branch: refs/heads/master Commit: 545e93db3f808fea526130a75ef800683eee7435 Parents: 11b94dd Author: vandana <[email protected]> Authored: Fri Jul 28 18:18:41 2017 +0530 Committer: chenliang613 <[email protected]> Committed: Wed Aug 2 23:58:54 2017 +0800 ---------------------------------------------------------------------- docs/ddl-operation-on-carbondata.md | 14 ++++++++++++++ 1 file changed, 14 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/carbondata/blob/545e93db/docs/ddl-operation-on-carbondata.md ---------------------------------------------------------------------- diff --git a/docs/ddl-operation-on-carbondata.md b/docs/ddl-operation-on-carbondata.md index 180132d..34148a4 100644 --- a/docs/ddl-operation-on-carbondata.md +++ b/docs/ddl-operation-on-carbondata.md @@ -127,6 +127,20 @@ The following DDL operations are supported in CarbonData : 'SORT_COLUMNS'='productName,storeCity') ``` + - **SORT_COLUMNS** + + This table property specifies the order of the sort column. + +``` + TBLPROPERTIES('SORT_COLUMNS'='column1, column3') +``` + + NOTE: + + - If this property is not specified, then by default SORT_COLUMNS consist of all dimension (exclude Complex Column). + + - If this property is specified but with empty argument, then the table will be loaded without sort. For example, ('SORT_COLUMNS'='') + ## SHOW TABLE This command can be used to list all the tables in current database or all the tables of a specific database.
