Luke Han created KYLIN-776:
------------------------------
Summary: Mondrian and Kylin integration
Key: KYLIN-776
URL: https://issues.apache.org/jira/browse/KYLIN-776
Project: Kylin
Issue Type: New Feature
Components: General
Reporter: Luke Han
Fix For: Backlog
Original work from Sebastien: https://github.com/mustangore/thesis
Hi,
This is Luke Han from Kylin team.
I just found your project on github: https://github.com/mustangore/thesis
I'm really interesting about the project's current status and would like to
know do you have interesting to contribute this to Kylin community and make it
more stable, flexible for Pentaho and other BI tools?
Please feel free to let me know your idea.
Thank you very much.
Best Regards!
---------------------
Luke Han
Sébastien Jelsch
22:35 (17小时前)
发送至 我
Hi Luke,
my name is Sebastien Jelsch, I’m currently working as a student at the German
company inovex. As a part of my thesis at the University of Karlsruhe (Germany)
I have get the task to extend a horizontal scalable OLAP engine with an
analysis UI. For this I have integrated Kylin into Pentaho Business Analytics
Platform.
With Saiku as an OLAP UI on top of Kylin OLAP, I am able to generate MDX
statements via drag’n'drop. Mondrian converts this generated MDX statement in
SQL and sends it to Kylin using the existing Kylin JDBC driver. The first
results are very promising. Currently, I study and check the advantages and
disadvantages, what problems arise and so on…
But I did not have to make any changes to Kylin. The integration of Kylin into
Pentaho Business Analytics Platform was possible with some changes to
Kettle-Core and Mondrian (add KylinDialect and Patch for generate explicit
joins instead of implicit joins. For this I’ve also created a ticket:
https://issues.apache.org/jira/browse/KYLIN-611 ). I’m going to create a pull
request for my changes in Mondrian project soon.
As I did not have to make any changes in Kylin, I’m not sure what I can
contribute to Kylin. But I would like to help, since this project is very
interesting and has a lot of potential from my point of view. Here in Germany,
I have submitted a presentation at the „data2day“ conference. I would like to
give a talk about Kylin. I hope, my proposal will be accepted soon.
Currently I’m also working on an integration of Mondrian in Kylin, so Kylin can
accept MDX statements via REST API. I’m still at the beginning of my work, but
I was able to achieve small successes, see my picture attached (you can find my
first patch in the kylin folder on my github project).
Please let me know if you have an idea how I can help you and the Kylin team.
Thank you for your interest.
With best regards,
Sébastien Jelsch
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
