Do kylin create any indexes against cubes data

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Do kylin create any indexes against cubes data

Nirav Patel
When generating cubes do kylin also generate some sort of indexing that
helps querying cube data ? If so how are those indexes designed. Are those
bitmaps? If so then once you identify qualified rows how query is being
pushdown to underlaying datasource (cache or hbase)?
Thanks

--


[image: What's New with Xactly] <http://www.xactlycorp.com/email-click/>

<https://www.nyse.com/quote/XNYS:XTLY>  [image: LinkedIn]
<https://www.linkedin.com/company/xactly-corporation>  [image: Twitter]
<https://twitter.com/Xactly>  [image: Facebook]
<https://www.facebook.com/XactlyCorp>  [image: YouTube]
<http://www.youtube.com/xactlycorporation>
Reply | Threaded
Open this post in threaded view
|

Re: Do kylin create any indexes against cubes data

Yang
Kylin Cube leverage HBase rowkey index to speed up query, and also limited
by it in some sense. That is why in the cube "Advanced Settings", user may
want to fine tune the dimensions order on the rowkey in some cases.

Cheers
Yang

On Tue, May 16, 2017 at 5:18 AM, Nirav Patel <[hidden email]> wrote:

> When generating cubes do kylin also generate some sort of indexing that
> helps querying cube data ? If so how are those indexes designed. Are those
> bitmaps? If so then once you identify qualified rows how query is being
> pushdown to underlaying datasource (cache or hbase)?
> Thanks
>
> --
>
>
> [image: What's New with Xactly] <http://www.xactlycorp.com/email-click/>
>
> <https://www.nyse.com/quote/XNYS:XTLY>  [image: LinkedIn]
> <https://www.linkedin.com/company/xactly-corporation>  [image: Twitter]
> <https://twitter.com/Xactly>  [image: Facebook]
> <https://www.facebook.com/XactlyCorp>  [image: YouTube]
> <http://www.youtube.com/xactlycorporation>
>