[KYLIN-3988] Weighted Average does not work on cube

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Invalid
• Affects Version/s: v2.6.1
• Component/s: Driver - ODBC
• Assignee: Unassigned
• Reporter: Anoop Krishnaswamy
• Created: 26/Apr/19 14:05
• Updated: 30/Apr/19 02:46
• Resolved: 30/Apr/19 02:46

Description

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