carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sehriff (JIRA)" <>
Subject [jira] [Created] (CARBONDATA-1051) why sort_columns?
Date Sat, 13 May 2017 05:55:04 GMT
sehriff created CARBONDATA-1051:

             Summary: why sort_columns?
                 Key: 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) 
 "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

View raw message