Apache Kylin 在 left outer join 后为何不支持+-*/运算啊？

[myyou]

• kylin sql

select
  a."member_num", b."member_num_tb", a."member_num" / b."member_num_tb"
from
(
    select
      count(distinct mobile) as "member_num"
      ,'week' as "dtype"
    from member
    where dweek <= '18.06.04~18.06.10'
) as a
left outer join
(
    select
      count(distinct mobile) as "member_num_tb"
      ,'week' as "dtype"
    from member
    where dweek_tb <= '18.06.04~18.06.10'
) as b on a."dtype" = b."dtype"

• 报错信息

That the right side of the BinaryTupleExpression owns columns is not supported for / while executing SQL: 
"select a."member_num", b."member_num_tb", a."member_num" / b."member_num_tb" from ( select count(distinct mobile) as "member_num" ,'week' as "dtype" from member where dweek <= '18.06.04~18.06.10' ) as a left outer join ( select count(distinct mobile) as "member_num_tb" ,'week' as "dtype" from member where dweek_tb <= '18.06.04~18.06.10' ) as b on a."dtype" = b."dtype" "

请问这是是什么原因啊？

[zog]

你用的什么版本 Kylin?

[myyou]

@zog kylin-2.4.0, 测试了一下，发现 a."member_num" / 3.0 是可以执行的，也就是右边不能为表达式只能是已知到的值，你有遇到这个问题吗？有什么解决办法没？

[zog]

被除数不能是个 measure

[myyou]

@zog 请问有什么办法或写法可以解决上面的问题吗？

[zog]

参考: https://issues.apache.org/jira/browse/KYLIN-3476

[myyou]

@zog 它这个要 2.5.0 修复，请问老版本（低于 2.4.0 ）有这个问题吗？

[zog]

你自己打个 patch 修一下....以前好像也有

[myyou]

@zog ok,我看一下，非常感谢

[zog]

客气了