You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2019/04/27 14:41:00 UTC
[jira] [Comment Edited] (KYLIN-3988) Weighted Average does not work
on cube
[ https://issues.apache.org/jira/browse/KYLIN-3988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16827626#comment-16827626 ]
Shaofeng SHI edited comment on KYLIN-3988 at 4/27/19 2:40 PM:
--------------------------------------------------------------
Hello Anoop, sum(x*y) couldn't be translated to sum(X) and sum(Y) with any operator, so it is not supported by Kylin, unless you define a column "z" = "x*y" in the source table, and then define "sum(z)" as a measure. If you're not willing to add this column in your hive table, you can define it in a hive view, and then use the view as the cube fact table.
was (Author: shaofengshi):
Hello Anoop, sum(x*y) couldn't be translated to sum(x) and sum(y) with any operator, so it is not supported by Kylin, unless you define a column "z" = "x*y" in the source table, and then define "sum(z)" as a measure. If you're not willing to add this column in your hive table, you can define it in a hive view, and then use the view as the cube fact table.
> 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)