Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
To set a shard number that will be for controlling the size per shard properly, we need to estimate cube size through accumulating all dimension and measure size roughly before building a cube. But the way of calculating the percentile measure is inaccurate currently and cause too many partitions for cube storage. Furthermore, it may affect the performance of SQL query.