Re: Creating Snowflake schema / Link 2 Cubes

[LeReunionais <ni...@gmail.com>]

I see that in Bart's use case, there was a one to many relationship between
books and author (one book is written by many authors). Looking at json
model definition he posted, I can only see a one to one relationship. 

Could you explain how this one to many relationship is archived?


--
View this message in context: http://apache-kylin.74782.x6.nabble.com/Creating-Snowflake-schema-Link-2-Cubes-tp7602p8220.html
Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Creating Snowflake schema / Link 2 Cubes

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

We could create multiple models and cubes like
- Model 1: Book (alone)
- Model 2: Author (alone)
- Model 3: Book join Author

Depending on the incoming query, Kylin will choose the right model with
best performance.




On Tue, Jun 13, 2017 at 12:23 PM, LeReunionais <ni...@gmail.com> wrote:

>
> I see that in Bart's use case, there was a one to many relationship between
> books and author (one book is written by many authors). Looking at json
> model definition he posted, I can only see a one to one relationship.
>
> Could you explain how this one to many relationship is archived?
>
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/Creating-Snowflake-schema-Link-2-Cubes-tp7602p8220.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>