chetandb commented on a change in pull request #3203: [DOC] Update doc for
sort_columns modification
URL: https://github.com/apache/carbondata/pull/3203#discussion_r282823475
##########
File path: docs/ddl-of-carbondata.md
##########
@@ -793,6 +793,19 @@ Users can specify which columns to include and exclude
for local dictionary gene
ALTER TABLE tablename UNSET TBLPROPERTIES('SORT_SCOPE')
```
+ - ##### SORT COLUMNS
+ Example to SET SORT COLUMNS:
+ ```
+ ALTER TABLE tablename SET TBLPROPERTIES('SORT_COLUMNS'='column1')
+ ```
+
+ UNSET is not supported, but it can set SORT_COLUMNS to empty string
instead of using UNSET.
+ ```
+ ALTER TABLE tablename SET TBLPROPERTIES('SORT_COLUMNS'='')
+ ```
+
+ **NOTE:** streaming table is not supported for SORT_COLUMNS
modification.
Review comment:
This information needs to be updated -
If some new columns are added in alter table sort columns which are not
there in inverted index columns list, the existing inverted index columns are
removed.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
