I tried to use saiku, mondrian and kylin according to
https://github.com/mustangore/kylin-mondrian-interaction.
I build a cube in kylin use two tables as the picture below:
[image: pasted3]
I also build a cube in Saiku as below:
[image: pasted2]
The measures new_num is sum of is_new and order_num is sum of order_pay_num.
Here is the problem.
When I use Saiku, I got the error:
IOException: org.apache.commons.httpclient.methods.PostMethod@697d2a4e
failed, error code 500 and response: {"url":"
http://10.10.163.68:7070/kylin/api/query","exception":"[Ljava.lang.Object;
cannot be cast to java.lang.Integer\nwhile executing SQL: \"select
\"DIM_ENTERPRISE\".\"ID\" as \"c0\" from \"DIM_ENTERPRISE\" as
\"DIM_ENTERPRISE\" group by \"DIM_ENTERPRISE\".\"ID\" order by CASE WHEN
\"DIM_ENTERPRISE\".\"ID\" IS NULL THEN 1 ELSE 0 END,
\"DIM_ENTERPRISE\".\"ID\" ASC\""}
I use the sql in Kylin and also get the same error.
However, when I use the same saiku schema and use mysql to store the data.
I got different sql and it works:
select
`dim_enterprise`.`kdt_id` as `c0`,
sum(`fact_qyd_enterprise_d`.`is_new`) as `m0`
from
`fact_qyd_enterprise_d` as `fact_qyd_enterprise_d`,
`dim_enterprise` as `dim_enterprise`
where
`fact_qyd_enterprise_d`.`kdt_id` = `dim_enterprise`.`kdt_id`
group by
`dim_enterprise`.`kdt_id`
I searched and didn't find much useful. I guess it's maybe
the mondrian-4.4-lagunitas-SNAPSHOT-with-kylin-dialect.jar. Any suggestions?
Thanks.
Longxing
