kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anoop Krishnaswamy (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-3988) Weighted Average does not work on cube
Date Fri, 26 Apr 2019 14:06:00 GMT
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)

Mime
View raw message