[jira] [Created] (KYLIN-2234) KYLIN throws null exception when execute specific query

["Hao Lin (JIRA)" <ji...@apache.org>]

Hao Lin created KYLIN-2234:
------------------------------

             Summary: 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)