Shaohui Liu created KYLIN-4204: ---------------------------------- Summary: Table not found by DEFAULT.KYLIN_ACCOUNT in Kylin 3.0.0-alpha2 Key: KYLIN-4204 URL: https://issues.apache.org/jira/browse/KYLIN-4204 Project: Kylin Issue Type: Bug Reporter: Shaohui Liu
The following sql is executed normally in Kylin 2.5.2 while throwing Table not found by DEFAULT.KYLIN_ACCOUNT in Kylin 3.0 {code:java} SELECT KYLIN_SALES.TRANS_ID, SUM(KYLIN_SALES.PRICE), COUNT(KYLIN_ACCOUNT.ACCOUNT_ID) FROM KYLIN_SALES INNER JOIN KYLIN_ACCOUNT ON KYLIN_SALES.BUYER_ID = KYLIN_ACCOUNT.ACCOUNT_ID WHERE KYLIN_SALES.LSTG_SITE_ID != 1000 GROUP BY KYLIN_SALES.TRANS_ID ORDER BY TRANS_ID LIMIT 10;{code} The detailed exception are following {code:java} Caused by: java.lang.IllegalArgumentException: Table not found by DEFAULT.KYLIN_ACCOUNT at org.apache.kylin.metadata.model.DataModelDesc.findTable(DataModelDesc.java:320) at org.apache.kylin.metadata.model.TblColRef.fixUnknownModel(TblColRef.java:96) at org.apache.kylin.query.relnode.OLAPContext.belongToFactTableDims(OLAPContext.java:242) at org.apache.kylin.query.relnode.OLAPAggregateRel.buildAggregations(OLAPAggregateRel.java:371) at org.apache.kylin.query.relnode.OLAPAggregateRel.buildColumnRowType(OLAPAggregateRel.java:217) at org.apache.kylin.query.relnode.OLAPAggregateRel.implementOLAP(OLAPAggregateRel.java:190) at org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:84) at org.apache.kylin.query.relnode.OLAPSortRel.implementOLAP(OLAPSortRel.java:72) at org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:84) at org.apache.kylin.query.relnode.OLAPLimitRel.implementOLAP(OLAPLimitRel.java:77) at org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:84) at org.apache.kylin.query.relnode.OLAPToEnumerableConverter.implement(OLAPToEnumerableConverter.java:77) at org.apache.calcite.adapter.enumerable.EnumerableRelImplementor.implementRoot(EnumerableRelImplementor.java:103) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:92) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1278) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:331) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:230) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:796) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:655) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:618) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:221) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:603) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:675) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156) ... 84 more {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)