You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@carbondata.apache.org by "sehriff (JIRA)" <ji...@apache.org> on 2017/05/13 05:55:04 UTC

[jira] [Created] (CARBONDATA-1051) why sort_columns?

sehriff created CARBONDATA-1051:
-----------------------------------

             Summary: why sort_columns?
                 Key: CARBONDATA-1051
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1051
             Project: CarbonData
          Issue Type: Improvement
            Reporter: sehriff


since we already have many rmdb sqls scripts,we don't want to change them too much when migrating to carbon.
suppose we already have sql script like:
"create table (c1,c2,...c7")",
If we want to change column order to shift most often used column ahead when query data,i think it's better change it this way like:
"create table(c1,c2,c7,c4..c6,c3) 
rather
 "create table(c1...c7)  tblproperties('sort_columns' = 'c7,c3')" 
because the former way just reordering columns without adding extra settings,which is more readable to thos who is familiar with rmdb but not  with carbon.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)