[ https://issues.apache.org/jira/browse/KYLIN-2363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16165651#comment-16165651 ]
Yang Hao commented on KYLIN-2363: --------------------------------- If there is no one to solve the problem, I want to solve it by not saving data in step "Convert Cuboid Data to HFile". If the max dimension N has set, then a row key with more than N column will be filtered. How about this solution. [~R0ger] [~liyang.g...@gmail.com] [~feng_xiao_yu] > Prune cuboids by capping number of dimensions > --------------------------------------------- > > Key: KYLIN-2363 > URL: https://issues.apache.org/jira/browse/KYLIN-2363 > Project: Kylin > Issue Type: Improvement > Reporter: fengYu > Assignee: Roger Shi > Attachments: Dimension Capping.md > > > the scene like this: > I have 20+ dimensions, However the query will only use at most 5 dimensions > in all dimensions, so cuboid that contains 5+ dimensions(except base cuboid) > is useless. > I think we can add a configuration in cube, which limit the max dimensions > that cuboid includes. > What's more, we can config which level(number of dimension) need to > calculate. in above scene, we only calculate leve 1,2,3,4,5. and skip level 5+ -- This message was sent by Atlassian JIRA (v6.4.14#64029)