You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by KylinPOC <sa...@gmail.com> on 2016/01/15 16:56:03 UTC
Kylin capabilities
Hi Kylin Team,
I have a few questions around capabilities of Kylin.
Does Kylin provide slicing and dicing capabilities on cubes?
Does Kylin offer nesting dimensions or hierarchies?
Other than SQL, can users use Kylin cube with drag and drop functionality
(something similar to the OLAP cubes in the traditional world)?
Is MDX (Multi-dimensional functions) supported in Kylin? (This is a standard
functionality of exiting OLAP tools).
Does Kylin provide role based security (who sees what data) and object level
security (who sees which dimensions)
Can existing HBase table be directly leveraged by Kylin for cubes and
suppose the HBase table was not created from any Hive Star schema.
Thanks.
--
View this message in context: http://apache-kylin.74782.x6.nabble.com/Kylin-capabilities-tp3270.html
Sent from the Apache Kylin mailing list archive at Nabble.com.
Re: Kylin capabilities
Posted by hongbin ma <ma...@apache.org>.
hi, santoshskulkarni75
I took a brief look at your video, it seems to me that "slicing and dicing,
nesting, drill-ups and drill-downs" is same as what Tableau+Kylin can help
to achieve.
For now Kylin is focusing on data cubing, and we don't intend to do
visualization like tableau.
kylin provides users with SQL interface, user does not need to worry
about "slicing
and dicing, nesting, drill-ups and drill-downs" at all, kylin cubing job
takes care of it.
On Sat, Jan 16, 2016 at 3:12 PM, KylinPOC <sa...@gmail.com>
wrote:
> Thanks everyone for your response. If we say Kylin is Multi-dimensional
> OLAP,
> slicing and dicing, nesting, drill-ups and drill-downs are really required
> because these are true multi-dimensional OLAP capabilities.
>
> For reference:
>
> IBM Dynamic Cubes
> http://www.redbooks.ibm.com/redbooks/pdfs/sg248064.pdf
>
> Nesting:
> https://www.youtube.com/watch?v=ADUOr1HeeRY
>
> Once the cube is built users should be able to drag and drop dimensions and
> facts(measures) to do analysis. These capabilities can be included as
> Improvements. (or this is left to tools like Tableau on top of Kylin?)
>
> Does Kylin support multi-fact tables with conformed dimensions?
>
> And, is time dimension mandatory for Kylin cube? What if for some specific
> use case time dimension is not required? Can we still create a cube?
>
> --
> View this message in context:
> http://apache-kylin.74782.x6.nabble.com/Kylin-capabilities-tp3270p3278.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>
--
Regards,
*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone
Re: Kylin capabilities
Posted by KylinPOC <sa...@gmail.com>.
Thanks everyone for your response. If we say Kylin is Multi-dimensional OLAP,
slicing and dicing, nesting, drill-ups and drill-downs are really required
because these are true multi-dimensional OLAP capabilities.
For reference:
IBM Dynamic Cubes
http://www.redbooks.ibm.com/redbooks/pdfs/sg248064.pdf
Nesting:
https://www.youtube.com/watch?v=ADUOr1HeeRY
Once the cube is built users should be able to drag and drop dimensions and
facts(measures) to do analysis. These capabilities can be included as
Improvements. (or this is left to tools like Tableau on top of Kylin?)
Does Kylin support multi-fact tables with conformed dimensions?
And, is time dimension mandatory for Kylin cube? What if for some specific
use case time dimension is not required? Can we still create a cube?
--
View this message in context: http://apache-kylin.74782.x6.nabble.com/Kylin-capabilities-tp3270p3278.html
Sent from the Apache Kylin mailing list archive at Nabble.com.
Re: Kylin capabilities
Posted by yu feng <ol...@gmail.com>.
OK,I will try to do it.
2016-01-16 10:22 GMT+08:00 Luke Han <lu...@gmail.com>:
> Hive view is good idea for this, even could handle for UDF.
>
> @Yu, maybe you could help to draft some tutorial and commit to website
> about this.
>
>
>
>
> Best Regards!
> ---------------------
>
> Luke Han
>
> On Sat, Jan 16, 2016 at 8:58 AM, yu feng <ol...@gmail.com> wrote:
>
> > Does Kylin offer nesting dimensions or hierarchies?
> >
> > > Kylin does not support Snowflake schema, It is currently restricted to
> > >Star.
> >
> > Generally speaking, we always transform snowflake schema to star schema
> by
> > creating some view.
> >
> > 2016-01-16 3:31 GMT+08:00 Adunuthula, Seshu <sa...@ebay.com>:
> >
> > > Does Kylin provide slicing and dicing capabilities on cubes?
> > >
> > > > Not sure what you mean, We can issue SQL on the cubes.
> > >
> > > Does Kylin offer nesting dimensions or hierarchies?
> > >
> > > > Kylin does not support Snowflake schema, It is currently restricted
> to
> > > >Star.
> > >
> > > Other than SQL, can users use Kylin cube with drag and drop
> functionality
> > > (something similar to the OLAP cubes in the traditional world)?
> > > > No it is not possible. It has to be a tool built on Kylin.
> > >
> > >
> > >
> > > Is MDX (Multi-dimensional functions) supported in Kylin? (This is a
> > > standard
> > > functionality of exiting OLAP tools).
> > > > MDX was wrapper was built but was not built by the Kylin team. Not
> sure
> > > >of how mature the capability is or if it works out of the box.
> > >
> > >
> > > Does Kylin provide role based security (who sees what data) and object
> > > level
> > > security (who sees which dimensions)
> > > > It provides basic security, you can grant permissions at the cube
> > level,
> > > >but cannot do row level or column level security.
> > >
> > > Can existing HBase table be directly leveraged by Kylin for cubes and
> > > suppose the HBase table was not created from any Hive Star schema.
> > > > No, We define the table row format, so you cannot use existing
> tables.
> > >
> > >
> > >
> > >
> > >
> > >
> > > On 1/15/16, 7:56 AM, "KylinPOC" <sa...@gmail.com> wrote:
> > >
> > > >Hi Kylin Team,
> > > >
> > > >I have a few questions around capabilities of Kylin.
> > > >
> > > >Does Kylin provide slicing and dicing capabilities on cubes?
> > > >
> > > >Does Kylin offer nesting dimensions or hierarchies?
> > > >
> > > >Other than SQL, can users use Kylin cube with drag and drop
> > functionality
> > > >(something similar to the OLAP cubes in the traditional world)?
> > > >
> > > >Is MDX (Multi-dimensional functions) supported in Kylin? (This is a
> > > >standard
> > > >functionality of exiting OLAP tools).
> > > >
> > > >Does Kylin provide role based security (who sees what data) and object
> > > >level
> > > >security (who sees which dimensions)
> > > >
> > > >Can existing HBase table be directly leveraged by Kylin for cubes and
> > > >suppose the HBase table was not created from any Hive Star schema.
> > > >
> > > >Thanks.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >--
> > > >View this message in context:
> > > >
> http://apache-kylin.74782.x6.nabble.com/Kylin-capabilities-tp3270.html
> > > >Sent from the Apache Kylin mailing list archive at Nabble.com.
> > >
> > >
> >
>
Re: Kylin capabilities
Posted by Luke Han <lu...@gmail.com>.
Hive view is good idea for this, even could handle for UDF.
@Yu, maybe you could help to draft some tutorial and commit to website
about this.
Best Regards!
---------------------
Luke Han
On Sat, Jan 16, 2016 at 8:58 AM, yu feng <ol...@gmail.com> wrote:
> Does Kylin offer nesting dimensions or hierarchies?
>
> > Kylin does not support Snowflake schema, It is currently restricted to
> >Star.
>
> Generally speaking, we always transform snowflake schema to star schema by
> creating some view.
>
> 2016-01-16 3:31 GMT+08:00 Adunuthula, Seshu <sa...@ebay.com>:
>
> > Does Kylin provide slicing and dicing capabilities on cubes?
> >
> > > Not sure what you mean, We can issue SQL on the cubes.
> >
> > Does Kylin offer nesting dimensions or hierarchies?
> >
> > > Kylin does not support Snowflake schema, It is currently restricted to
> > >Star.
> >
> > Other than SQL, can users use Kylin cube with drag and drop functionality
> > (something similar to the OLAP cubes in the traditional world)?
> > > No it is not possible. It has to be a tool built on Kylin.
> >
> >
> >
> > Is MDX (Multi-dimensional functions) supported in Kylin? (This is a
> > standard
> > functionality of exiting OLAP tools).
> > > MDX was wrapper was built but was not built by the Kylin team. Not sure
> > >of how mature the capability is or if it works out of the box.
> >
> >
> > Does Kylin provide role based security (who sees what data) and object
> > level
> > security (who sees which dimensions)
> > > It provides basic security, you can grant permissions at the cube
> level,
> > >but cannot do row level or column level security.
> >
> > Can existing HBase table be directly leveraged by Kylin for cubes and
> > suppose the HBase table was not created from any Hive Star schema.
> > > No, We define the table row format, so you cannot use existing tables.
> >
> >
> >
> >
> >
> >
> > On 1/15/16, 7:56 AM, "KylinPOC" <sa...@gmail.com> wrote:
> >
> > >Hi Kylin Team,
> > >
> > >I have a few questions around capabilities of Kylin.
> > >
> > >Does Kylin provide slicing and dicing capabilities on cubes?
> > >
> > >Does Kylin offer nesting dimensions or hierarchies?
> > >
> > >Other than SQL, can users use Kylin cube with drag and drop
> functionality
> > >(something similar to the OLAP cubes in the traditional world)?
> > >
> > >Is MDX (Multi-dimensional functions) supported in Kylin? (This is a
> > >standard
> > >functionality of exiting OLAP tools).
> > >
> > >Does Kylin provide role based security (who sees what data) and object
> > >level
> > >security (who sees which dimensions)
> > >
> > >Can existing HBase table be directly leveraged by Kylin for cubes and
> > >suppose the HBase table was not created from any Hive Star schema.
> > >
> > >Thanks.
> > >
> > >
> > >
> > >
> > >
> > >--
> > >View this message in context:
> > >http://apache-kylin.74782.x6.nabble.com/Kylin-capabilities-tp3270.html
> > >Sent from the Apache Kylin mailing list archive at Nabble.com.
> >
> >
>
Re: Kylin capabilities
Posted by yu feng <ol...@gmail.com>.
Does Kylin offer nesting dimensions or hierarchies?
> Kylin does not support Snowflake schema, It is currently restricted to
>Star.
Generally speaking, we always transform snowflake schema to star schema by
creating some view.
2016-01-16 3:31 GMT+08:00 Adunuthula, Seshu <sa...@ebay.com>:
> Does Kylin provide slicing and dicing capabilities on cubes?
>
> > Not sure what you mean, We can issue SQL on the cubes.
>
> Does Kylin offer nesting dimensions or hierarchies?
>
> > Kylin does not support Snowflake schema, It is currently restricted to
> >Star.
>
> Other than SQL, can users use Kylin cube with drag and drop functionality
> (something similar to the OLAP cubes in the traditional world)?
> > No it is not possible. It has to be a tool built on Kylin.
>
>
>
> Is MDX (Multi-dimensional functions) supported in Kylin? (This is a
> standard
> functionality of exiting OLAP tools).
> > MDX was wrapper was built but was not built by the Kylin team. Not sure
> >of how mature the capability is or if it works out of the box.
>
>
> Does Kylin provide role based security (who sees what data) and object
> level
> security (who sees which dimensions)
> > It provides basic security, you can grant permissions at the cube level,
> >but cannot do row level or column level security.
>
> Can existing HBase table be directly leveraged by Kylin for cubes and
> suppose the HBase table was not created from any Hive Star schema.
> > No, We define the table row format, so you cannot use existing tables.
>
>
>
>
>
>
> On 1/15/16, 7:56 AM, "KylinPOC" <sa...@gmail.com> wrote:
>
> >Hi Kylin Team,
> >
> >I have a few questions around capabilities of Kylin.
> >
> >Does Kylin provide slicing and dicing capabilities on cubes?
> >
> >Does Kylin offer nesting dimensions or hierarchies?
> >
> >Other than SQL, can users use Kylin cube with drag and drop functionality
> >(something similar to the OLAP cubes in the traditional world)?
> >
> >Is MDX (Multi-dimensional functions) supported in Kylin? (This is a
> >standard
> >functionality of exiting OLAP tools).
> >
> >Does Kylin provide role based security (who sees what data) and object
> >level
> >security (who sees which dimensions)
> >
> >Can existing HBase table be directly leveraged by Kylin for cubes and
> >suppose the HBase table was not created from any Hive Star schema.
> >
> >Thanks.
> >
> >
> >
> >
> >
> >--
> >View this message in context:
> >http://apache-kylin.74782.x6.nabble.com/Kylin-capabilities-tp3270.html
> >Sent from the Apache Kylin mailing list archive at Nabble.com.
>
>
Re: Kylin capabilities
Posted by "Adunuthula, Seshu" <sa...@ebay.com>.
Does Kylin provide slicing and dicing capabilities on cubes?
> Not sure what you mean, We can issue SQL on the cubes.
Does Kylin offer nesting dimensions or hierarchies?
> Kylin does not support Snowflake schema, It is currently restricted to
>Star.
Other than SQL, can users use Kylin cube with drag and drop functionality
(something similar to the OLAP cubes in the traditional world)?
> No it is not possible. It has to be a tool built on Kylin.
Is MDX (Multi-dimensional functions) supported in Kylin? (This is a
standard
functionality of exiting OLAP tools).
> MDX was wrapper was built but was not built by the Kylin team. Not sure
>of how mature the capability is or if it works out of the box.
Does Kylin provide role based security (who sees what data) and object
level
security (who sees which dimensions)
> It provides basic security, you can grant permissions at the cube level,
>but cannot do row level or column level security.
Can existing HBase table be directly leveraged by Kylin for cubes and
suppose the HBase table was not created from any Hive Star schema.
> No, We define the table row format, so you cannot use existing tables.
On 1/15/16, 7:56 AM, "KylinPOC" <sa...@gmail.com> wrote:
>Hi Kylin Team,
>
>I have a few questions around capabilities of Kylin.
>
>Does Kylin provide slicing and dicing capabilities on cubes?
>
>Does Kylin offer nesting dimensions or hierarchies?
>
>Other than SQL, can users use Kylin cube with drag and drop functionality
>(something similar to the OLAP cubes in the traditional world)?
>
>Is MDX (Multi-dimensional functions) supported in Kylin? (This is a
>standard
>functionality of exiting OLAP tools).
>
>Does Kylin provide role based security (who sees what data) and object
>level
>security (who sees which dimensions)
>
>Can existing HBase table be directly leveraged by Kylin for cubes and
>suppose the HBase table was not created from any Hive Star schema.
>
>Thanks.
>
>
>
>
>
>--
>View this message in context:
>http://apache-kylin.74782.x6.nabble.com/Kylin-capabilities-tp3270.html
>Sent from the Apache Kylin mailing list archive at Nabble.com.