[jira] [Comment Edited] (KYLIN-3351) Cube Planner not working in apche kylin 2.3.0(open Source)
[ https://issues.apache.org/jira/browse/KYLIN-3351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16493138#comment-16493138 ] praveenece edited comment on KYLIN-3351 at 5/29/18 9:02 AM: Hi Shaofeng I attached a screenshot of my cube. image 1 the Leaf Cuboid rollup rate 99.87% I prepared a query for this Cuboid and hit it. image 2 this cuboid is parent cuboid of image 1 cuboid. this cuboid rollup rate -99% whenever I hit query means changes(colors) happen only main cuboid, not for image 1 cuboid(99.87%) the roll up rate from parent cuboid to leaf cuboid is high, so that colors change happen in leaf cuboid.but not happen. kindly guide me. On Fri, May 18, 2018 at 2:54 PM, Shaofeng SHI (JIRA) was (Author: praveenece): Hi Shaofeng I attached a screenshot of my cube. image 1 the Leaf Cuboid rollup rate 99.87% I prepared a query for this Cuboid and hit it. image 2 this cuboid is parent cuboid of image 1 cuboid. this cuboid rollup rate -99% whenever I hit query means changes(colors) happen only main cuboid, not for image 1 cuboid(99.87%) the roll up rate from parent cuboid to leaf cuboid is not so high, so that colors change not happen in leaf cuboid. kindly guide me. On Fri, May 18, 2018 at 2:54 PM, Shaofeng SHI (JIRA) > Cube Planner not working in apche kylin 2.3.0(open Source) > -- > > Key: KYLIN-3351 > URL: https://issues.apache.org/jira/browse/KYLIN-3351 > Project: Kylin > Issue Type: Task >Reporter: praveenece >Priority: Major > Attachments: image 1.png, image 2.png > > > Hi Team > i want test Cube planner in apache-kylin(2.3.0),So i created cube with > segment, and i hit query to cube many times more than thousands but the cube > planner there is no change in cuboid level like color changing and not get > COUNT in exactly row count and other items.can u please guide me. > Note: > Could u tell me? > Cube Planner Working only old Cube (like 3 month before) or new Cube also. > Configuration(kylin.Properties) > kylin.cube.cubeplanner.enabled=true > Kylin Version=2.3.0(SINGLE NODE) > MyCube creation =10days before > I referred: http://kylin.apache.org/docs23/howto/howto_use_cube_planner.html > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Comment Edited] (KYLIN-3351) Cube Planner not working in apche kylin 2.3.0(open Source)
[ https://issues.apache.org/jira/browse/KYLIN-3351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16474035#comment-16474035 ] praveenece edited comment on KYLIN-3351 at 5/16/18 10:55 AM: - Hi How we Decide Cuboid color changing?whether user hit the query against cuboids? or we follows any other steps? Scenario i selected one leaf-cuboid under that cuboid i checked what r the dimension combination based on i prepared query. example total dimension ABCD leaf cuboid -abc,abd,acd,bcd so i prepared select query which is contains dimension like abc (quboid) ex:select a,b,c from table; i hit qube and get records but abc (quboid )not change color instead of changed in parent cubiod like(abcd) . kindly guide me why this happen? was (Author: praveenece): Hi How we Decide Cuboid color changing?whether user hit the query against cuboids? or we follows any other steps? Scenario i selected one leaf-cuboid under that cuboid i checked what r the dimension combination based on i prepared query. i hit that query many times but leaf-Cuboid colors not changed. How we calculate row count in every Cuboid? > Cube Planner not working in apche kylin 2.3.0(open Source) > -- > > Key: KYLIN-3351 > URL: https://issues.apache.org/jira/browse/KYLIN-3351 > Project: Kylin > Issue Type: Task >Reporter: praveenece >Priority: Major > > Hi Team > i want test Cube planner in apache-kylin(2.3.0),So i created cube with > segment, and i hit query to cube many times more than thousands but the cube > planner there is no change in cuboid level like color changing and not get > COUNT in exactly row count and other items.can u please guide me. > Note: > Could u tell me? > Cube Planner Working only old Cube (like 3 month before) or new Cube also. > Configuration(kylin.Properties) > kylin.cube.cubeplanner.enabled=true > Kylin Version=2.3.0(SINGLE NODE) > MyCube creation =10days before > I referred: http://kylin.apache.org/docs23/howto/howto_use_cube_planner.html > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Comment Edited] (KYLIN-3351) Cube Planner not working in apche kylin 2.3.0(open Source)
[ https://issues.apache.org/jira/browse/KYLIN-3351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16474035#comment-16474035 ] praveenece edited comment on KYLIN-3351 at 5/14/18 10:56 AM: - Hi How we Decide Cuboid color changing?whether user hit the query against cuboids? or we follows any other steps? Scenario i selected one leaf-cuboid under that cuboid i checked what r the dimension combination based on i prepared query. i hit that query many times but leaf-Cuboid colors not changed. How we calculate row count in every Cuboid? was (Author: praveenece): Hi How we Decide Cuboid color changing?whether user hit the query against cuboids? or we follows any other steps? Scenario i selected one leaf-cuboid under that cuboid i checked what r the dimension combination based on i prepared query. i hit that query many times but leaf-Cubiod colors not changed. > Cube Planner not working in apche kylin 2.3.0(open Source) > -- > > Key: KYLIN-3351 > URL: https://issues.apache.org/jira/browse/KYLIN-3351 > Project: Kylin > Issue Type: Task >Reporter: praveenece >Priority: Major > > Hi Team > i want test Cube planner in apache-kylin(2.3.0),So i created cube with > segment, and i hit query to cube many times more than thousands but the cube > planner there is no change in cuboid level like color changing and not get > COUNT in exactly row count and other items.can u please guide me. > Note: > Could u tell me? > Cube Planner Working only old Cube (like 3 month before) or new Cube also. > Configuration(kylin.Properties) > kylin.cube.cubeplanner.enabled=true > Kylin Version=2.3.0(SINGLE NODE) > MyCube creation =10days before > I referred: http://kylin.apache.org/docs23/howto/howto_use_cube_planner.html > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Comment Edited] (KYLIN-3351) Cube Planner not working in apche kylin 2.3.0(open Source)
[ https://issues.apache.org/jira/browse/KYLIN-3351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16473582#comment-16473582 ] Roberto Tardío Olmos edited comment on KYLIN-3351 at 5/13/18 5:44 PM: -- Hi Praveence, I managed to use the Kylin's cube planner to optimize a cube successfully. After this process cube size is smaller and faster than original one. However as you say, the last optimized time is not showed on cube planner tab. was (Author: rober tardio): Hi praveence, I managed to use the Kylin's cube planner to optimize a cube successfully. After this process cube size is smaller and faster than original one. However as you say, the last optimized time is not showed on cube planner tab. > Cube Planner not working in apche kylin 2.3.0(open Source) > -- > > Key: KYLIN-3351 > URL: https://issues.apache.org/jira/browse/KYLIN-3351 > Project: Kylin > Issue Type: Task >Reporter: praveenece >Priority: Major > > Hi Team > i want test Cube planner in apache-kylin(2.3.0),So i created cube with > segment, and i hit query to cube many times more than thousands but the cube > planner there is no change in cuboid level like color changing and not get > COUNT in exactly row count and other items.can u please guide me. > Note: > Could u tell me? > Cube Planner Working only old Cube (like 3 month before) or new Cube also. > Configuration(kylin.Properties) > kylin.cube.cubeplanner.enabled=true > Kylin Version=2.3.0(SINGLE NODE) > MyCube creation =10days before > I referred: http://kylin.apache.org/docs23/howto/howto_use_cube_planner.html > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Comment Edited] (KYLIN-3351) Cube Planner not working in apche kylin 2.3.0(open Source)
[ https://issues.apache.org/jira/browse/KYLIN-3351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16473582#comment-16473582 ] Roberto Tardío Olmos edited comment on KYLIN-3351 at 5/13/18 5:43 PM: -- Hi praveence, I managed to use the Kylin's cube planner to optimize a cube successfully. After this process cube size is smaller and faster than original one. However as you say, the last optimized time is not showed on cube planner tab. was (Author: rober tardio): Hi praveence, I managed to use the Kylin's cube planner to optimize cube a cube successfully. After this process cube size is smaller and faster than original one. However as you say, the last optimized time is not showed on cube planner tab. > Cube Planner not working in apche kylin 2.3.0(open Source) > -- > > Key: KYLIN-3351 > URL: https://issues.apache.org/jira/browse/KYLIN-3351 > Project: Kylin > Issue Type: Task >Reporter: praveenece >Priority: Major > > Hi Team > i want test Cube planner in apache-kylin(2.3.0),So i created cube with > segment, and i hit query to cube many times more than thousands but the cube > planner there is no change in cuboid level like color changing and not get > COUNT in exactly row count and other items.can u please guide me. > Note: > Could u tell me? > Cube Planner Working only old Cube (like 3 month before) or new Cube also. > Configuration(kylin.Properties) > kylin.cube.cubeplanner.enabled=true > Kylin Version=2.3.0(SINGLE NODE) > MyCube creation =10days before > I referred: http://kylin.apache.org/docs23/howto/howto_use_cube_planner.html > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
