Agree with Lee. >From v2.5, Kylin enables the Cube planner's first phase optimization, which will generate the recommended cuboid list when building the first segment, based on the data statistics.
If you want to disable it, please set in conf/kylin.properties: kylin.cube.cubeplanner.enabled=false After restart Kylin, please disable and purse the already built cube, and then rebuild the segment. This time there will be the full cuboids based on your settings. est regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: [email protected] Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: [email protected] Join Kylin dev mail group: [email protected] Li Feng <[email protected]> 于2019年6月7日周五 下午2:18写道： > Hi Cinto, > > > > Do you used Kylin version 2.5+? > > From these versions, cube planner is enabled by default and will decrease > cuboid numbers automatically. > > For cube planner, you can see > http://kylin.apache.org/docs/tutorial/use_cube_planner.html > > > > BR， > > Lee > > > > *发件人**: *Cinto Sunny <[email protected]> > *答复**: *"[email protected]" <[email protected]> > *日期**: *2019年6月7日 星期五 下午1:28 > *收件人**: *"[email protected]" <[email protected]> > *主**题**: *Re: No. of cuboids not as expected > > > > No, all the columns are normal, no derived dimensions. I had created > derived dimensions earlier, but dropped it for the latest build > > > - Cinto > > > > > > On Thu, Jun 6, 2019 at 9:50 PM JiaTao Tao <[email protected]> wrote: > > Hi > > > > Do you have any lookup tables? The type of dim in the lookup table is > "Derived Dimension" by default. > > More details about "Derived Dimension" in > http://kylin.apache.org/docs15/howto/howto_optimize_cubes.html > > > > > > -- > > > > Regards! > > Aron Tao > > > > Cinto Sunny <[email protected]> 于2019年6月7日周五 上午4:01写道： > > I work at Apple and am planning to use Kylin for creating OLAP cube. I > have an issue and wanted to see if somebody could help. Not sure if this is > the right group though. > > > > I set up a cube with 10 dimension (1 is mandatory). When I check the > planner section in Kylin webpage, I see 60 cuboids. Ideally, I was > expecting something around 2^9+1. Not sure where my understanding is wrong. > I do not have any hierarchy currently defined on this cube. Also, I set up > this model on a hive view. > > > > What could be the reasons the no. of cuboids could be 60. I can share more > details if needed. Let me know. > > > > Thanks > > > - Cinto > > > > > > >
