there is any public roadmap ? or list of possible ideas? 2016-10-07 11:06 GMT+02:00 Li Yang <[email protected]>:
> Thanks to Ashika for raising the questions. This is exactly how road map > is created by collecting community voices. > > From what I see, snowflake schema is a strong need. Its JIRA has been > there since the early days of Kylin. More and more enterprise adoptions are > calling for support of complicated models. I'm working on KYLIN-1971 at the > moment, which can be seen as a prerequisite of snowflake schema. > > Another thing I'm interested in is make Kylin consume realtime data, > KYLIN-603. That's a big task. Looking for ideas and other contributions. > > Cheers > Yang > > > > > > On Wed, Oct 5, 2016 at 12:36 PM, Luke Han <[email protected]> wrote: > >> Hi Ashika, >> That's great news about your POC, would you mind to share more detail >> information for community if possible? I think it will help a lot of people >> to adopt Kylin >> For your question, please refer to below comments: >> 1) Will there be a MAC ODBC Driver available? (We use couple of BI >> tools in different BUs including Tabalue,PowerBI,Excel,Domo..etc in >> different platforms) >> --No plan yet, since most of BI server are using Linux/Windows. We >> have some discussion with some vendors for this topic. But if there are >> many requirement for Mac version, I think we should invest something on >> this. >> >> 2) Support MDX >> --MDX already be supported via Mondrian plugin >> >> 3) Snowflake Schema (I assume answer for this is No) >> --Yes, will support snowflake in coming major release (just have some >> discussion with Yang and others recently, Yang could offer more detail >> information later) >> >> 4) Presentation layer for BI tools. (For example when we connect to a >> cube in Tableau, it looks as if its connected to table.There's no >> grouping of Dimensions and Measure, grouping under folders...etc ) >> -- This is design purpose, we would like users treat Kylin as a read >> only database not a pure Cube system >> >> Please feel free to leave your comments. >> >> Thanks. >> Luke >> >> >> >> Best Regards! >> --------------------- >> >> Luke Han >> >> On Tue, Oct 4, 2016 at 4:31 PM, Alberto Ramón <[email protected]> >> wrote: >> >>> In true Snowflake schema: >>> - Is a limitation or not of BI program , I never tested on Tableau >>> - Both queries must work, but: I don't Know if with Snowflake the >>> Optmization "Dynamic Partition Pruning (HIVE-7826)" is translated to HBase >>> queries (I don't have this Knowledge, sorry) >>> >>> 2016-10-04 8:38 GMT+02:00 Ashika Umanga Umagiliya <[email protected]> >>> : >>> >>>> Sorry, >>>> I meant "Snowflake schema" not "Star Schema" . Star Schema is already >>>> supported. >>>> >>>> On Tue, Oct 4, 2016 at 3:24 PM, Alberto Ramón < >>>> [email protected]> wrote: >>>> >>>>> 1 - I think, no >>>>> 2 - There isnt MDX support (Kylin 1525 >>>>> <https://issues.apache.org/jira/browse/KYLIN-1525> & Kylin 776 >>>>> <https://issues.apache.org/jira/browse/KYLIN-776>): For now you >>>>> can use mondrian <http://community.pentaho.com/projects/mondrian/> >>>>> see this example >>>>> <https://translate.google.com/translate?act=url&depth=1&hl=en&ie=UTF8&prev=_t&rurl=translate.google.com&sl=auto&tl=en&u=http://lxw1234.com/archives/2016/05/647.htm> >>>>> 3 - Why not ¿? >>>>> 4 - How to Bi-Tools >>>>> <http://kylin.apache.org/docs15/gettingstarted/best_practices.html> >>>>> BI tools (like Tableau) see tables, but queries are resolved using the >>>>> Cube >>>>> (in HBase). The BI tool must interpret what is a fact table and what is a >>>>> Dim table. Tableau can do it (manual1 >>>>> <https://kylin.apache.org/docs15/tutorial/tableau_91.html>and manual2 >>>>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithTableau>) >>>>> if you define a data model. Other programs >>>>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithMain> >>>>> have some integration issues :( >>>>> >>>>> 2016-10-04 2:53 GMT+02:00 Ashika Umanga Umagiliya < >>>>> [email protected]>: >>>>> >>>>>> Greetings , >>>>>> >>>>>> We managed to finish a PoC on using Kylin as enterprise level BI >>>>>> tool.Our primary goal is to streamline the KPI management in the >>>>>> orgnisation. >>>>>> However we come up with following limitation and want to know whether >>>>>> they are in your roadmap >>>>>> >>>>>> 1) Will there be a MAC ODBC Driver available? (We use couple of BI >>>>>> tools in different BUs including Tabalue,PowerBI,Excel,Domo..etc in >>>>>> different platforms) >>>>>> 2) Support MDX >>>>>> 3) Star Schema (I assume answer for this is No) >>>>>> 4) Presentation layer for BI tools. (For example when we connect to a >>>>>> cube in Tableau, it looks as if its connected to table.There's no >>>>>> grouping of Dimensions and Measure, grouping under folders...etc ) >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Umanga >>>> http://jp.linkedin.com/in/umanga >>>> http://umanga.ifreepages.com >>>> >>> >>> >> >
