[ https://issues.apache.org/jira/browse/KYLIN-776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15530379#comment-15530379 ]
Kenneth Ohaeri commented on KYLIN-776: -------------------------------------- I am in the process of starting a project for my management consulting company. I want to use multidimensional or OLAP concept for my project. In my review of open source technologies, a colleague recommended that I use Mondrian because it is a mature technology and have been around for a long time but when I searched for books I found Mondrian in Action. I purchased it and have been happy with it but then a friend suggested that I use Apache Kylin. I never heard of it before and then I search for books or publication but none exists. I also noticed that it uses Hadoop for data source. My question is would you recommend Kylin over Mondrian or do you suggest finding ways to integrate both in my solution so that our customers can use Mondrian component for smaller data footprint and use Kylin for Big Data type processing. Thanks in advance for your advise. Ken Ohaeri > 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)