[ https://issues.apache.org/jira/browse/KYLIN-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15750179#comment-15750179 ]
Hao Lin commented on KYLIN-2234: -------------------------------- Hi, I verify at the latest release version 1.6.0 (hbase 0.98), but the error is still there. > KYLIN throws null exception when execute specific query > ------------------------------------------------------- > > Key: KYLIN-2234 > URL: https://issues.apache.org/jira/browse/KYLIN-2234 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: v1.5.3 > Reporter: Hao Lin > Assignee: liyang > > KYLIN throws null pointer exception when executing a specify query. The query > tries to calculate VV ratio of condition A and condition B. For simplicity, a > minimum query is rewriten on ‘learn_kylin’ project and the condition is > removed, so it can be reproduced easily. > > *Query* > {code:xml} > SELECT t1.PART_DT, SUM(t2.vv) / SUM(t1.vv) AS vv_rate > FROM > ( > SELECT PART_DT, COUNT(1) as vv > FROM KYLIN_SALES > GROUP BY PART_DT > ) AS t1 > JOIN > ( > SELECT PART_DT, COUNT(1) as vv > FROM KYLIN_SALES > GROUP BY PART_DT > ) AS t2 > ON (t1.PART_DT = t2.PART_DT) > GROUP BY t1.PART_DT > {code} > > *KYLIN Server LOG* > {code} > null > 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:143) > at > org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:186) > at > org.apache.kylin.rest.service.QueryService.execute(QueryService.java:366) > at > org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:278) > at > org.apache.kylin.rest.service.QueryService.query(QueryService.java:121) > at > org.apache.kylin.rest.service.QueryService$$FastClassByCGLIB$$4957273f.invoke(<generated>) > ….. > Caused by: java.lang.NullPointerException > at > org.apache.kylin.query.relnode.OLAPAggregateRel.translateAggregation(OLAPAggregateRel.java:268) > at > org.apache.kylin.query.relnode.OLAPAggregateRel.implementRewrite(OLAPAggregateRel.java:240) > at > org.apache.kylin.query.relnode.OLAPRel$RewriteImplementor.visitChild(OLAPRel.java:121) > at > org.apache.kylin.query.relnode.OLAPProjectRel.implementRewrite(OLAPProjectRel.java:233) > at > org.apache.kylin.query.relnode.OLAPRel$RewriteImplementor.visitChild(OLAPRel.java:121) > at > org.apache.kylin.query.relnode.OLAPLimitRel.implementRewrite(OLAPLimitRel.java:101) > at > org.apache.kylin.query.relnode.OLAPRel$RewriteImplementor.visitChild(OLAPRel.java:121) > at > org.apache.kylin.query.relnode.OLAPToEnumerableConverter.implement(OLAPToEnumerableConverter.java:95) > at > org.apache.calcite.adapter.enumerable.EnumerableRelImplementor.implementRoot(EnumerableRelImplementor.java:102) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)