[jira] [Created] (KYLIN-1831) Couldn't run "count (distinct pk)" on a lookup table

["Shaofeng SHI (JIRA)" <ji...@apache.org>]

Shaofeng SHI created KYLIN-1831:
-----------------------------------

             Summary: Couldn't run "count (distinct pk)" on a lookup table
                 Key: KYLIN-1831
                 URL: https://issues.apache.org/jira/browse/KYLIN-1831
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: v1.5.2
            Reporter: Shaofeng SHI
            Assignee: Dong Li


I have a SSB testing cube, in which ssb.customer is a lookup table, the cube has been built successfully (table snapshot exists); As KYLIN-1016 mentioned, count distinct should work even if there is no pre-defined measure; The SQL is: "select count (distinct c_custkey) from ssb.customer", the error log is:

{code}
Caused by: java.lang.IllegalStateException: Can't create EnumerableAggregate!
	at org.apache.kylin.query.relnode.OLAPAggregateRel.implementEnumerable(OLAPAggregateRel.java:373)
	at org.apache.kylin.query.relnode.OLAPRel$JavaImplementor.createEnumerable(OLAPRel.java:158)
	at org.apache.kylin.query.relnode.OLAPRel$JavaImplementor.createEnumerable(OLAPRel.java:154)
	at org.apache.kylin.query.relnode.OLAPToEnumerableConverter.implement(OLAPToEnumerableConverter.java:99)
	at org.apache.calcite.adapter.enumerable.EnumerableRelImplementor.implementRoot(EnumerableRelImplementor.java:102)
	at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:92)
	at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1171)
	at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:297)
	at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:196)
	at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:721)
	at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:588)
	at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:558)
	at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:214)
	at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:573)
	at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:571)
	at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:135)
	... 80 more
Caused by: org.apache.calcite.rel.InvalidRelException: distinct aggregation not supported
	at org.apache.calcite.adapter.enumerable.EnumerableAggregate.<init>(EnumerableAggregate.java:71)
	at org.apache.kylin.query.relnode.OLAPAggregateRel.implementEnumerable(OLAPAggregateRel.java:370)
	... 95 more
{code}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)