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 <stell...@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/ >