[
https://issues.apache.org/jira/browse/KYLIN-3988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16827482#comment-16827482
]
xingzhicn commented on KYLIN-3988:
----------------------------------
I used the same way to reproduce this problem, I think it is because cuboids
does not store your Measure metadata, which will make the cube data very large,
cuboids will combine your dimensions and measures together to store hbase In
the case, sum(Measure *Measure) is not supported. You can use
{code:java}
// select sum(Measure )*sum(Measure ) from library_collection where org_code =
'001'{code}
but obviously this is not what you want :), the current version Depending on
the lack of a good solution, look forward to the answers of others
> 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)
