Re: Question about future Kylin features and roapmap.

[Li Yang]

Open JIRAs serve as the list of possible ideas.

On Fri, Oct 7, 2016 at 6:01 PM, Alberto Ramón 
wrote:

> there is any public roadmap ? or list of possible ideas?
>
> 2016-10-07 11:06 GMT+02:00 Li Yang :
>
>> 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  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 >> > 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 :

> 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.ramonporto...@gmail.com> wrote:
>
>> 1 - I think, no
>> 2 - There isnt MDX support (Kylin 1525
>>  & Kylin 776
>> ):For now you
>> can use mondrian 
>> see this example
>> 
>> 3 - 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 <
>> umanga@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
>>> 

Re: Question about future Kylin features and roapmap.

[Li Yang]

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  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 
> 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 :
>>
>>> 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 >> > wrote:
>>>
 1 - I think, no
 2 - There isnt MDX support (Kylin 1525
  & Kylin 776
 ):For now you can
 use mondrian  see this
 example
 
 3 - 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 :

> 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
>>>
>>
>>
>

Re: Question about future Kylin features and roapmap.

[Luke Han]

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 
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 :
>
>> 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 
>> wrote:
>>
>>> 1 - I think, no
>>> 2 - There isnt MDX support (Kylin 1525
>>>  & Kylin 776
>>> ):For now you can
>>> use mondrian  see this
>>> example
>>> 
>>> 3 - 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 
>>> :
>>>
 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
>>
>
>

Re: Question about future Kylin features and roapmap.

[Alberto Ramón]

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 :

> 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 
> wrote:
>
>> 1 - I think, no
>> 2 - There isnt MDX support (Kylin 1525
>>  & Kylin 776
>> ):For now you can
>> use mondrian  see this
>> example
>> 
>> 3 - 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 :
>>
>>> 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
>

Re: Question about future Kylin features and roapmap.

[Alberto Ramón]

1 - I think, no
2 - There isnt MDX support (Kylin 1525
 & Kylin 776
):For now you can use
mondrian  see this example

3 - 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 :

> 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  )
>

Question about future Kylin features and roapmap.

[Ashika Umanga Umagiliya]

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  )