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

Posted to issues@kylin.apache.org by "liyang (JIRA)" <ji...@apache.org> on 2018/06/26 12:31:00 UTC

[jira] [Created] (KYLIN-3429) Have a default measure value to save storage space

liyang created KYLIN-3429:
-----------------------------

             Summary: Have a default measure value to save storage space
                 Key: KYLIN-3429
                 URL: https://issues.apache.org/jira/browse/KYLIN-3429
             Project: Kylin
          Issue Type: Improvement
            Reporter: liyang


The idea is from Alberto.

When a Cuboid is very sparse, like below:

 
||Dim1||Dim2||Measure||
|1|A|0|
|1|B|100|
|1|C|0|
|2|A|0|
|2|B|0|
|2|C|130|

It becomes beneficial to store only the non-zero lines and remember a default measure value for the rest.

That is to only save the below lines, plus the default value 0.
||Dim1||Dim2||Measure||
|1|B|100|
|2|C|130|

However this comes with the assumption that all combinations of dimensions exist in cuboid.

 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)