kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alberto Ramón <a.ramonporto...@gmail.com>
Subject Re: Question about future Kylin features and roapmap.
Date Fri, 07 Oct 2016 10:01:14 GMT
there is any public roadmap ? or list of possible ideas?

2016-10-07 11:06 GMT+02:00 Li Yang <liyang@apache.org>:

> 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 <luke.hq@gmail.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 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 <a.ramonportoles@gmail.com>
>> 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 <umanga.pdn@gmail.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 <
>>>> a.ramonportoles@gmail.com> 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 <
>>>>> umanga.pdn@gmail.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 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
>>>>
>>>
>>>
>>
>

Mime
View raw message