[jira] [Commented] (KYLIN-2363) Prune cuboids by capping number of dimensions
[ https://issues.apache.org/jira/browse/KYLIN-2363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15980702#comment-15980702 ] fengYu commented on KYLIN-2363: --- [~roger.shi] sorry for delay. I am waiting for the release of kylin 2.0, I want to add this feature beyond it, I think this week it will release and I will do this job. > 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 > > 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.3.15#6346)
[jira] [Assigned] (KYLIN-1668) Rowkey column shouldn't allow delete and add
[ https://issues.apache.org/jira/browse/KYLIN-1668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shaofeng SHI reassigned KYLIN-1668: --- Assignee: Zhixiong Chen (was: Zhong,Jason) Request participants: (was: ) hi [~Zhixiong Chen], could you please check this? I think it should be fixed as earlier as possible. > Rowkey column shouldn't allow delete and add > > > Key: KYLIN-1668 > URL: https://issues.apache.org/jira/browse/KYLIN-1668 > Project: Kylin > Issue Type: Bug > Components: Web >Affects Versions: v1.5.0, v1.3.0, v1.5.1 >Reporter: Shaofeng SHI >Assignee: Zhixiong Chen > > Every column in rowkey are required, couldn't be deleted. And no need to add > other columns. The "-" icon and "New Rowkey Column" button should be removed > from the UI. > Besides, please add some text to let user know the column sequence is > adjustable with drag -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (KYLIN-2538) extract(MONTH from CURRENT_DATE) cannot be selected as a column in sql
[ https://issues.apache.org/jira/browse/KYLIN-2538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dong Li updated KYLIN-2538: --- Description: >From calcite SQL reference: CURRENT_DATE is a const to get the value of >current value. But in Kylin this SQL will fail with exceptions: select extract(MONTH from CURRENT_DATE), count(*) from test_kylin_fact Error message: Error while executing SQL "select extract(MONTH from CURRENT_DATE), count(*) from test_kylin_fact LIMIT 5": No TblColRef found in EXTRACT_DATE(FLAG(MONTH), Reinterpret(CURRENT_DATE)) Stacktrace: Caused by: java.lang.IllegalStateException: No TblColRef found in EXTRACT_DATE(FLAG(MONTH), Reinterpret(CURRENT_DATE)) at org.apache.kylin.query.relnode.OLAPProjectRel.buildColumnRowType(OLAPProjectRel.java:132) at org.apache.kylin.query.relnode.OLAPProjectRel.implementOLAP(OLAPProjectRel.java:117) at org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:83) at org.apache.kylin.query.relnode.OLAPLimitRel.implementOLAP(OLAPLimitRel.java:75) at org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:83) at org.apache.kylin.query.relnode.OLAPToEnumerableConverter.implement(OLAPToEnumerableConverter.java:85) at org.apache.calcite.adapter.enumerable.EnumerableRelImplementor.implementRoot(EnumerableRelImplementor.java:108) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:92) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1248) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:306) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:203) was: This SQL will fail with exceptions: select extract(MONTH from CURRENT_DATE), count(*) from test_kylin_fact Error message: Error while executing SQL "select extract(MONTH from CURRENT_DATE), count(*) from test_kylin_fact LIMIT 5": No TblColRef found in EXTRACT_DATE(FLAG(MONTH), Reinterpret(CURRENT_DATE)) Stacktrace: Caused by: java.lang.IllegalStateException: No TblColRef found in EXTRACT_DATE(FLAG(MONTH), Reinterpret(CURRENT_DATE)) at org.apache.kylin.query.relnode.OLAPProjectRel.buildColumnRowType(OLAPProjectRel.java:132) at org.apache.kylin.query.relnode.OLAPProjectRel.implementOLAP(OLAPProjectRel.java:117) at org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:83) at org.apache.kylin.query.relnode.OLAPLimitRel.implementOLAP(OLAPLimitRel.java:75) at org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:83) at org.apache.kylin.query.relnode.OLAPToEnumerableConverter.implement(OLAPToEnumerableConverter.java:85) at org.apache.calcite.adapter.enumerable.EnumerableRelImplementor.implementRoot(EnumerableRelImplementor.java:108) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:92) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1248) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:306) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:203) > extract(MONTH from CURRENT_DATE) cannot be selected as a column in sql > -- > > Key: KYLIN-2538 > URL: https://issues.apache.org/jira/browse/KYLIN-2538 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: Dong Li >Assignee: liyang > > From calcite SQL reference: CURRENT_DATE is a const to get the value of > current value. > But in Kylin this SQL will fail with exceptions: > select extract(MONTH from CURRENT_DATE), count(*) from test_kylin_fact > Error message: > Error while executing SQL "select extract(MONTH from CURRENT_DATE), count(*) > from test_kylin_fact LIMIT 5": No TblColRef found in > EXTRACT_DATE(FLAG(MONTH), Reinterpret(CURRENT_DATE)) > Stacktrace: > Caused by: java.lang.IllegalStateException: No TblColRef found in > EXTRACT_DATE(FLAG(MONTH), Reinterpret(CURRENT_DATE)) > at > org.apache.kylin.query.relnode.OLAPProjectRel.buildColumnRowType(OLAPProjectRel.java:132) > at > org.apache.kylin.query.relnode.OLAPProjectRel.implementOLAP(OLAPProjectRel.java:117) > at > org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:83) > at > org.apache.kylin.query.relnode.OLAPLimitRel.implementOLAP(OLAPLimitRel.java:75) > at > org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:83) > at >
[jira] [Commented] (KYLIN-2538) extract(MONTH from CURRENT_DATE) cannot be selected as a column in sql
[ https://issues.apache.org/jira/browse/KYLIN-2538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15980370#comment-15980370 ] Dong Li commented on KYLIN-2538: Yes it's on CI cubes. But actually CURRENT_DATE is a const value to return current date, for example, "select extract(MONTH from CURRENT_DATE)" will return right result, but will fail when other column/aggr func appears in the SQL. Thanks Roger. I will add more description in this JIRA to avoid misunderstanding. > extract(MONTH from CURRENT_DATE) cannot be selected as a column in sql > -- > > Key: KYLIN-2538 > URL: https://issues.apache.org/jira/browse/KYLIN-2538 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: Dong Li >Assignee: liyang > > This SQL will fail with exceptions: > select extract(MONTH from CURRENT_DATE), count(*) from test_kylin_fact > Error message: > Error while executing SQL "select extract(MONTH from CURRENT_DATE), count(*) > from test_kylin_fact LIMIT 5": No TblColRef found in > EXTRACT_DATE(FLAG(MONTH), Reinterpret(CURRENT_DATE)) > Stacktrace: > Caused by: java.lang.IllegalStateException: No TblColRef found in > EXTRACT_DATE(FLAG(MONTH), Reinterpret(CURRENT_DATE)) > at > org.apache.kylin.query.relnode.OLAPProjectRel.buildColumnRowType(OLAPProjectRel.java:132) > at > org.apache.kylin.query.relnode.OLAPProjectRel.implementOLAP(OLAPProjectRel.java:117) > at > org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:83) > at > org.apache.kylin.query.relnode.OLAPLimitRel.implementOLAP(OLAPLimitRel.java:75) > at > org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:83) > at > org.apache.kylin.query.relnode.OLAPToEnumerableConverter.implement(OLAPToEnumerableConverter.java:85) > at > org.apache.calcite.adapter.enumerable.EnumerableRelImplementor.implementRoot(EnumerableRelImplementor.java:108) > at > org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:92) > at > org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1248) > at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:306) > at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:203) -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (KYLIN-2538) extract(MONTH from CURRENT_DATE) cannot be selected as a column in sql
[ https://issues.apache.org/jira/browse/KYLIN-2538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15980337#comment-15980337 ] Roger Shi commented on KYLIN-2538: -- I suppose this query targets CI Data Model and Cube. If yes, CURRENT_DATE is not in the table. And count(*) should not in the query. The refined query is "select extract(MONTH from CAL_DT) from test_kylin_fact" and it returns the expected result. Please let me know if I miss anything. > extract(MONTH from CURRENT_DATE) cannot be selected as a column in sql > -- > > Key: KYLIN-2538 > URL: https://issues.apache.org/jira/browse/KYLIN-2538 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: Dong Li >Assignee: liyang > > This SQL will fail with exceptions: > select extract(MONTH from CURRENT_DATE), count(*) from test_kylin_fact > Error message: > Error while executing SQL "select extract(MONTH from CURRENT_DATE), count(*) > from test_kylin_fact LIMIT 5": No TblColRef found in > EXTRACT_DATE(FLAG(MONTH), Reinterpret(CURRENT_DATE)) > Stacktrace: > Caused by: java.lang.IllegalStateException: No TblColRef found in > EXTRACT_DATE(FLAG(MONTH), Reinterpret(CURRENT_DATE)) > at > org.apache.kylin.query.relnode.OLAPProjectRel.buildColumnRowType(OLAPProjectRel.java:132) > at > org.apache.kylin.query.relnode.OLAPProjectRel.implementOLAP(OLAPProjectRel.java:117) > at > org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:83) > at > org.apache.kylin.query.relnode.OLAPLimitRel.implementOLAP(OLAPLimitRel.java:75) > at > org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:83) > at > org.apache.kylin.query.relnode.OLAPToEnumerableConverter.implement(OLAPToEnumerableConverter.java:85) > at > org.apache.calcite.adapter.enumerable.EnumerableRelImplementor.implementRoot(EnumerableRelImplementor.java:108) > at > org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:92) > at > org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1248) > at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:306) > at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:203) -- This message was sent by Atlassian JIRA (v6.3.15#6346)