Many2many relationships

[Sarnath K <st...@gmail.com>]

Hi,

Can some1 point me how Kylin handles many2many relationships that
frequently occurs in warehouses? Is there Anything special need to be done?
Especially the queries using bridge tablez and their modeling in Kylin, and
query optimizations....

Best,
Sarnath

Thanks!

Re: Many2many relationships

[Sarnath K <st...@gmail.com>]

Hi,
Thanks for the inputs. View is a good idea...
Best,
Sarnath

Re: Many2many relationships

[Li Yang <li...@apache.org>]

Thanks, the example helps a lot.

Kylin itself does not provide special feature about the many2many
relationships as described in the article. Actually the classic workarounds
mentioned in the article are good ones and work for Kylin too. In addition,
you may make a view of user-join-sport, and let the view be the fact table
that feeds into Kylin.

On Mon, May 16, 2016 at 11:08 AM, Sarnath K <st...@gmail.com> wrote:

> Sure. Thanks for the revert.
> This Pythian blog explains very clearly - much better than what I can sum
> up.
>
>
> https://www.pythian.com/blog/implementing-many-to-many-relationships-in-data-warehousing/
>

Re: Many2many relationships

[Sarnath K <st...@gmail.com>]

Sure. Thanks for the revert.
This Pythian blog explains very clearly - much better than what I can sum
up.

https://www.pythian.com/blog/implementing-many-to-many-relationships-in-data-warehousing/

Re: Many2many relationships

[Li Yang <li...@apache.org>]

Maybe give an example?

On Fri, May 13, 2016 at 11:10 PM, Sarnath K <st...@gmail.com> wrote:

> Hi,
>
> Can some1 point me how Kylin handles many2many relationships that
> frequently occurs in warehouses? Is there Anything special need to be done?
> Especially the queries using bridge tablez and their modeling in Kylin, and
> query optimizations....
>
> Best,
> Sarnath
>
> Thanks!
>