[jira] [Created] (KYLIN-4204) Table not found by DEFAULT.KYLIN_ACCOUNT in Kylin 3.0.0-alpha2

["Shaohui Liu (Jira)" <ji...@apache.org>]

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)