kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Yang <liy...@apache.org>
Subject Re: Question about future Kylin features and roapmap.
Date Fri, 07 Oct 2016 10:10:18 GMT
Open JIRAs serve as the list of possible ideas.

On Fri, Oct 7, 2016 at 6:01 PM, Alberto Ramón <a.ramonportoles@gmail.com>
wrote:

> 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