Hello Kylin community,
We stumbled upon a problem in Kylin 2.6.1: We built a cube yesterday and it
was working fine. For one of the columns ("latitude") of our input data it
had a SUM() measure and we used in queries AVG() aggregate successfully,
e.g.:
select sum(latitude),count(*), avg(latitude) from kylin_tickets left join
kylin_dic_store using (id_store)
Today, we don't know why it stopped working, and return an error:
2019-04-10 15:34:53,024 INFO [Query
fc6b32d8-45f1-141d-bc5d-2785190e1180-65] service.QueryService:403 : Using
project: Test
2019-04-10 15:34:53,024 INFO [Query
fc6b32d8-45f1-141d-bc5d-2785190e1180-65] service.QueryService:404 : The
original query: select sum(latitude),count(*), avg(latitude) from
kylin_tickets left join kylin_dic_store using (id_store) limit 10;
2019-04-10 15:34:53,028 INFO [Query
fc6b32d8-45f1-141d-bc5d-2785190e1180-65] service.QueryService:619 : The
corrected query: select sum(latitude),count(*), avg(latitude) from
kylin_tickets left join kylin_dic_store using (id_store) limit 10
2019-04-10 15:34:53,047 ERROR [Query
fc6b32d8-45f1-141d-bc5d-2785190e1180-65] service.QueryService:510 :
Exception while executing query
java.sql.SQLException: Error while executing SQL "select
sum(latitude),count(*), avg(latitude) from kylin_tickets left join
kylin_dic_store using (id_store) limit 10": Table not found by
REPORT_SALES.KYLIN_DIC_STORE
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156)
at
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:218)
at
org.apache.kylin.rest.service.QueryService.executeRequest(QueryService.java:938)
at
org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:641)
at
org.apache.kylin.rest.service.QueryService.query(QueryService.java:208)
at
org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:468)
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:429)
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:367)
...
Caused by: java.lang.IllegalArgumentException: Table not found by
REPORT_SALES.KYLIN_DIC_STORE
at
org.apache.kylin.metadata.model.DataModelDesc.findTable(DataModelDesc.java:320)
at
org.apache.kylin.metadata.model.TblColRef.fixUnknownModel(TblColRef.java:89)
at
org.apache.kylin.query.relnode.OLAPContext.belongToFactTableDims(OLAPContext.java:239)
at
org.apache.kylin.query.relnode.OLAPAggregateRel.buildAggregations(OLAPAggregateRel.java:369)
at
org.apache.kylin.query.relnode.OLAPAggregateRel.buildColumnRowType(OLAPAggregateRel.java:216)
at
org.apache.kylin.query.relnode.OLAPAggregateRel.implementOLAP(OLAPAggregateRel.java:189)
at
org.apache.kylin.query.relnode.OLAPRel$OLAPImplementor.visitChild(OLAPRel.java:84)
at
org.apache.kylin.query.relnode.OLAPProjectRel.implementOLAP(OLAPProjectRel.java:132)
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:75)
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:638)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:149)
... 85 more
...
==========================[QUERY]===============================
Query Id: fc6b32d8-45f1-141d-bc5d-2785190e1180
SQL: select sum(latitude),count(*), avg(latitude) from kylin_tickets left
join kylin_dic_store using (id_store) limit 10;
User: ADMIN
Success: false
Duration: 0.026
Project: Test
Realization Names: []
Cuboid Ids: []
Total scan count: 0
Total scan bytes: 0
Result row count: 0
Accept Partial: true
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: Table not found by REPORT_SALES.KYLIN_DIC_STORE
while executing SQL: "select sum(latitude),count(*), avg(latitude) from
kylin_tickets left join kylin_dic_store using (id_store) limit 10"
==========================[QUERY]===============================
2019-04-10 15:34:53,050 ERROR [http-nio-7070-exec-1]
controller.BasicController:63 :
org.apache.kylin.rest.exception.InternalErrorException: Table not found by
REPORT_SALES.KYLIN_DIC_STORE
while executing SQL: "select sum(latitude),count(*), avg(latitude) from
kylin_tickets left join kylin_dic_store using (id_store) limit 10"
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:441)
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:367)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87)
at sun.reflect.GeneratedMethodAccessor190.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
...
* We tried using just SUM(latitude) and it worked fine.
* We tried using COUNT(latitude) and it failed with the same issue
* We created exactly the same cube in new project and all queries worked
again.
* We tried restarting Kylin and it didn't help either.
Now we don't know what is/was the cause and we're afraid that an error
returns tomorrow.
Could you please help us investigate the issue, find a fix and/or a
workaround?
Thank you,
Krzysztof
