YangCheersAnother thing I'm interested in is make Kylin consume realtime data, KYLIN-603. That's a big task. Looking for ideas and other contributions.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.On Wed, Oct 5, 2016 at 12:36 PM, Luke Han <email@example.com> 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 KylinFor 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..et
c 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 plugin3) 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 systemPlease feel free to leave your comments.Thanks.LukeBest Regards!
Luke HanOn Tue, Oct 4, 2016 at 4:31 PM, Alberto Ramón <firstname.lastname@example.org> wrote:- 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)In true Snowflake schema:- Is a limitation or not of BI program , I never tested on Tableau2016-10-04 8:38 GMT+02:00 Ashika Umanga Umagiliya <email@example.com>: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 <firstname.lastname@example.org> wrote:1 - I think, no2 - There isnt MDX support (Kylin 1525 & Kylin 776): For now you can use mondrian see this example3 - Why not ¿?4 - How to Bi-Tools 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 and manual2) if you define a data model. Other programs have some integration issues :(2016-10-04 2:53 GMT+02:00 Ashika Umanga Umagiliya <email@example.com>: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 roadmap1) Will there be a MAC ODBC Driver available? (We use couple of BI tools in different BUs including Tabalue,PowerBI,Excel,Domo..et
c in different platforms)2) Support MDX3) 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 )