You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "wangrupeng (Jira)" <ji...@apache.org> on 2019/11/01 03:07:00 UTC
[jira] [Comment Edited] (KYLIN-4204) Table not found by
DEFAULT.KYLIN_ACCOUNT in Kylin 3.0.0-alpha2
[ https://issues.apache.org/jira/browse/KYLIN-4204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16964565#comment-16964565 ]
wangrupeng edited comment on KYLIN-4204 at 11/1/19 3:06 AM:
------------------------------------------------------------
There's surely a problem. I'm using kylin3.0.0-alpha2 in local cluster not docker and get the same problem.
When I change property "kylin.query.enable-dynamic-column" from TRUE to FALSE, it wil not throw table not found exception again and can return the correct result.
I'm checking this out.
was (Author: wangrupeng):
There's surely a problem. I'm using kylin3.0.0-alpha2 in local cluster not docker and get the same problem.
When I change property "kylin.query.enable-dynamic-column" from TRUE to FALSE, it wil not throw table not found exception again and can return the correct result.
I'm checking out this.
> 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
> Assignee: Shaohui Liu
> Priority: Minor
>
> The following sql is executed normally in Kylin 2.5.2 while throwing Table not found by DEFAULT.KYLIN_ACCOUNT in standalone docker of 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)