kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anoop Krishnaswamy (JIRA)" <>
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
             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

View raw message