carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sehriff (JIRA)" <j...@apache.org>
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
                 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)

Mime
View raw message