You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by ch...@apache.org on 2017/08/02 15:59:07 UTC
carbondata git commit: [CARBONDATA-1137]updated ddl
operation-on-carbondata.md for SORT_COLUMNS
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 <va...@gmail.com>
Authored: Fri Jul 28 18:18:41 2017 +0530
Committer: chenliang613 <ch...@apache.org>
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.