You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "Anoop Krishnaswamy (JIRA)" <ji...@apache.org> on 2019/04/26 14:06:00 UTC

[jira] [Created] (KYLIN-3988) Weighted Average does not work on cube

Anoop Krishnaswamy created KYLIN-3988:
-----------------------------------------

             Summary: Weighted Average does not work on cube
                 Key: KYLIN-3988
                 URL: https://issues.apache.org/jira/browse/KYLIN-3988
             Project: Kylin
          Issue Type: Bug
          Components: Driver - ODBC
    Affects Versions: v2.6.1
            Reporter: Anoop Krishnaswamy


When we try to get aggregate over multiplication of 2 metrics it throws an error:


That both of the two sides of the BinaryTupleExpression own columns is not supported for * while executing SQL: "select sum(riskscoreinitial*cyc_xxx_balanceAdb), cyc_xxx_cyclesdelinquent from fct_profit_table_monthly group by cyc_xxx_cyclesdelinquent LIMIT 50000"

 

My query looks something like this :

 

select sum(<Metric1>*<Metric2>), <dim1> from <table> group by <dim1>

Any guidance will help



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)