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

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

     [ https://issues.apache.org/jira/browse/KYLIN-3988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shaofeng SHI resolved KYLIN-3988.
---------------------------------
    Resolution: Invalid

> 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
>            Priority: Critical
>
> 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)