[jira] [Commented] (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&focusedCommentId=16460621#comment-16460621 ] praveenece commented on KYLIN-3351: --- thanks Billy for reply. Could you give me kylin user mailer? > 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] [Commented] (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&focusedCommentId=16460653#comment-16460653 ] Dong Li commented on KYLIN-3351: Please refer to http://kylin.apache.org/community/ You need to subscribe to the user mailing list firstly, and then send your questions to u...@kylin.apache.org. To learn more about mailing list, please refer to http://www.apache.org/foundation/mailinglists.html > 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] [Commented] (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&focusedCommentId=16460678#comment-16460678 ] Zhong Yanghong commented on KYLIN-3351: --- Hi [~praveenece], have you build system cubes to collect query metrics? > 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] [Created] (KYLIN-3358) Support more sqls
Zhong Yanghong created KYLIN-3358: - Summary: Support more sqls Key: KYLIN-3358 URL: https://issues.apache.org/jira/browse/KYLIN-3358 Project: Kylin Issue Type: Improvement Reporter: Zhong Yanghong Because of not storing raw data, kylin is not able to support all of the ANSI SQLs. For other cases, kylin should support as much as possible. For example, sum(case when...), sum(2*price+1), count(column), etc. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3359) Support sum(expression) if possible
Zhong Yanghong created KYLIN-3359: - Summary: Support sum(expression) if possible Key: KYLIN-3359 URL: https://issues.apache.org/jira/browse/KYLIN-3359 Project: Kylin Issue Type: Sub-task Reporter: Zhong Yanghong Assignee: Zhong Yanghong The expression can be as follows: # a ~1~*col ~1~ + a ~2~*col ~2~ + ... + a ~n~*col ~n~ + b, if sum(col ~1~),sum(col ~2~),...sum(col ~n~) are defined # case when {{filter}} ~1~ then expr ~1~ when {{filter}} ~2~ then expr ~2~ ... else expr ~N~ end, if {{filter}} ~1~,{{filter}} ~2~, ... {{filter}} ~N-1~, and expr ~1~,expr ~2~,...expr ~N~ are supported -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (KYLIN-3358) Support more sqls
[ https://issues.apache.org/jira/browse/KYLIN-3358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhong Yanghong reassigned KYLIN-3358: - Assignee: Zhong Yanghong > Support more sqls > - > > Key: KYLIN-3358 > URL: https://issues.apache.org/jira/browse/KYLIN-3358 > Project: Kylin > Issue Type: Improvement >Reporter: Zhong Yanghong >Assignee: Zhong Yanghong >Priority: Major > > Because of not storing raw data, kylin is not able to support all of the ANSI > SQLs. For other cases, kylin should support as much as possible. For example, > sum(case when...), sum(2*price+1), count(column), etc. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3360) Support count(column)
Zhong Yanghong created KYLIN-3360: - Summary: Support count(column) Key: KYLIN-3360 URL: https://issues.apache.org/jira/browse/KYLIN-3360 Project: Kylin Issue Type: Sub-task Reporter: Zhong Yanghong Assignee: Zhong Yanghong -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3361) Support stddev as a new measure
Zhong Yanghong created KYLIN-3361: - Summary: Support stddev as a new measure Key: KYLIN-3361 URL: https://issues.apache.org/jira/browse/KYLIN-3361 Project: Kylin Issue Type: Sub-task Reporter: Zhong Yanghong Assignee: Zhong Yanghong -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3362) Support dynamic dimension push down
Zhong Yanghong created KYLIN-3362: - Summary: Support dynamic dimension push down Key: KYLIN-3362 URL: https://issues.apache.org/jira/browse/KYLIN-3362 Project: Kylin Issue Type: Sub-task Reporter: Zhong Yanghong Assignee: Zhong Yanghong Here, dynamic dimension is mainly for case when for column. By push down, the cardinality will be reduced and the returned result row number can be reduced. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3360) Support count(column)
[ https://issues.apache.org/jira/browse/KYLIN-3360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhong Yanghong updated KYLIN-3360: -- Description: If the value of the column is null, the related row should not be counted. > Support count(column) > - > > Key: KYLIN-3360 > URL: https://issues.apache.org/jira/browse/KYLIN-3360 > Project: Kylin > Issue Type: Sub-task >Reporter: Zhong Yanghong >Assignee: Zhong Yanghong >Priority: Major > > If the value of the column is null, the related row should not be counted. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3361) Support stddev as a new measure
[ https://issues.apache.org/jira/browse/KYLIN-3361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhong Yanghong updated KYLIN-3361: -- Description: (x ~1~ - +x+) ^2^ + (x ~2~ - +x+) ^2^ + ... + (x ~n~ - +x+) ^2^ = x ~1~ ^2^ + x ~2~ ^2^ + ... + x ~n~ ^2^ - n +x+ ^2^, where +x+ is the average of x ~1~, x ~2~, ..., x ~n~. Therefore, to compute stddev, what kylin need to do is to pre-calculate sum(x ~i~ ^2^), sum(x ~i~) and count > Support stddev as a new measure > --- > > Key: KYLIN-3361 > URL: https://issues.apache.org/jira/browse/KYLIN-3361 > Project: Kylin > Issue Type: Sub-task >Reporter: Zhong Yanghong >Assignee: Zhong Yanghong >Priority: Major > > (x ~1~ - +x+) ^2^ + (x ~2~ - +x+) ^2^ + ... + (x ~n~ - +x+) ^2^ = x ~1~ ^2^ + > x ~2~ ^2^ + ... + x ~n~ ^2^ - n +x+ ^2^, where +x+ is the average of x ~1~, x > ~2~, ..., x ~n~. Therefore, to compute stddev, what kylin need to do is to > pre-calculate sum(x ~i~ ^2^), sum(x ~i~) and count -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3363) Wrong partition condition appended in JDBC Source
Dong Li created KYLIN-3363: -- Summary: Wrong partition condition appended in JDBC Source Key: KYLIN-3363 URL: https://issues.apache.org/jira/browse/KYLIN-3363 Project: Kylin Issue Type: Improvement Components: RDBMS Source Reporter: Dong Li create a cube, and select the partition column from lookup table, then select shard by column from fact table. then an unexecutable sql will be created to build the flatten table with sqoop: select ... from [FACT] where [LOOKUP].[PARTITION_COL] > ... -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3363) Wrong partition condition appended in JDBC Source
[ https://issues.apache.org/jira/browse/KYLIN-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dong Li updated KYLIN-3363: --- Affects Version/s: v2.3.1 > Wrong partition condition appended in JDBC Source > - > > Key: KYLIN-3363 > URL: https://issues.apache.org/jira/browse/KYLIN-3363 > Project: Kylin > Issue Type: Bug > Components: RDBMS Source >Affects Versions: v2.3.1 >Reporter: Dong Li >Priority: Minor > > create a cube, and select the partition column from lookup table, then select > shard by column from fact table. > then an unexecutable sql will be created to build the flatten table with > sqoop: > select ... from [FACT] where [LOOKUP].[PARTITION_COL] > ... -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3363) Wrong partition condition appended in JDBC Source
[ https://issues.apache.org/jira/browse/KYLIN-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dong Li updated KYLIN-3363: --- Issue Type: Bug (was: Improvement) > Wrong partition condition appended in JDBC Source > - > > Key: KYLIN-3363 > URL: https://issues.apache.org/jira/browse/KYLIN-3363 > Project: Kylin > Issue Type: Bug > Components: RDBMS Source >Affects Versions: v2.3.1 >Reporter: Dong Li >Priority: Minor > > create a cube, and select the partition column from lookup table, then select > shard by column from fact table. > then an unexecutable sql will be created to build the flatten table with > sqoop: > select ... from [FACT] where [LOOKUP].[PARTITION_COL] > ... -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (KYLIN-3363) Wrong partition condition appended in JDBC Source
[ https://issues.apache.org/jira/browse/KYLIN-3363?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dong Li reassigned KYLIN-3363: -- Assignee: Dong Li > Wrong partition condition appended in JDBC Source > - > > Key: KYLIN-3363 > URL: https://issues.apache.org/jira/browse/KYLIN-3363 > Project: Kylin > Issue Type: Bug > Components: RDBMS Source >Affects Versions: v2.3.1 >Reporter: Dong Li >Assignee: Dong Li >Priority: Minor > > create a cube, and select the partition column from lookup table, then select > shard by column from fact table. > then an unexecutable sql will be created to build the flatten table with > sqoop: > select ... from [FACT] where [LOOKUP].[PARTITION_COL] > ... -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3360) Support count(column)
[ https://issues.apache.org/jira/browse/KYLIN-3360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhong Yanghong updated KYLIN-3360: -- Description: If the value of the column is null, the related row should not be counted. count(column) can be explained as sum(case when column is not null then 1 else 0), which can be will be supported by [KYLIN-3359] was:If the value of the column is null, the related row should not be counted. > Support count(column) > - > > Key: KYLIN-3360 > URL: https://issues.apache.org/jira/browse/KYLIN-3360 > Project: Kylin > Issue Type: Sub-task >Reporter: Zhong Yanghong >Assignee: Zhong Yanghong >Priority: Major > > If the value of the column is null, the related row should not be counted. > count(column) can be explained as sum(case when column is not null then 1 > else 0), which can be will be supported by [KYLIN-3359] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3364) Make the behavior of BigDecimalSumAggregator consistent with hive
Zhong Yanghong created KYLIN-3364: - Summary: Make the behavior of BigDecimalSumAggregator consistent with hive Key: KYLIN-3364 URL: https://issues.apache.org/jira/browse/KYLIN-3364 Project: Kylin Issue Type: Sub-task Reporter: Zhong Yanghong Assignee: Zhong Yanghong When aggregating on a sequence of BigDecimal values, if all values are null, the result should be null. Otherwise, null should be regarded as 0. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3365) Add unit test for the coprocessor code, CubeVisitService
Zhong Yanghong created KYLIN-3365: - Summary: Add unit test for the coprocessor code, CubeVisitService Key: KYLIN-3365 URL: https://issues.apache.org/jira/browse/KYLIN-3365 Project: Kylin Issue Type: Test Reporter: Zhong Yanghong Assignee: Zhong Yanghong -- This message was sent by Atlassian JIRA (v7.6.3#76005)