Open JIRAs serve as the list of possible ideas. On Fri, Oct 7, 2016 at 6:01 PM, Alberto Ramón <[email protected]> wrote:
> 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 >>>>> >>>> >>>> >>> >> >
