Hi,
Thanks for the inputs. View is a good idea...
Best,
Sarnath
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
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/
Maybe give an example?
On Fri, May 13, 2016 at 11:10 PM, Sarnath K 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 th
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!