Re: Many2many relationships

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

Re: Many2many relationships

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

Re: Many2many relationships

Maybe give an example? On Fri, May 13, 2016 at 11:10 PM, Sarnath K <stell...@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 querie

Many2many relationships

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!