Star-schema is the most common schema in data analysis, and other schemas can be converted to a star schema, that's why Kylin only support this;
For your last question, as I know Kylin doesn't have plan to support other schema in short-term. 2016-07-28 11:53 GMT+08:00 Yiming Liu <[email protected]>: > More information about snowflake schema， > https://en.wikipedia.org/wiki/Snowflake_schema > > The snowflake schema can be rewritten into multiple star schemas. It's > simplified Kylin design by supporting star schema only. > > 2016-07-28 10:07 GMT+08:00 俊 赵 <[email protected]>: > >> Thanks for your answer. >> >> What is the consideration about not supporting multi fact tables? Is it >> because multi fact tables means too many dimensions? >> >> >> >> >> *Zhao Jun* >> >> ------------------------------ >> From: [email protected] >> Date: Wed, 27 Jul 2016 07:45:46 +0800 >> Subject: Re: Multiple Fact Tables in Kylin >> To: [email protected] >> >> >> Hi Zhao Jun, >> >> Kylin supports start schema, which means only one fact table. >> >> Could you try build a view which joins the fact tables as the new fact >> table？It's the common design pattern. >> >> No that plan, as I know. >> >> 2016-07-27 7:39 GMT+08:00 俊 赵 <[email protected]>: >> >> Hi Kylin Team, >> >> I have some questions. >> >> 1. Does Kylin only support one fact table in building a cube? >> >> 2. If so, is there a way to analyse a database with several fact tables >> using Kylin, except that building a cube per fact table and joining results >> together? >> >> 3. If so, will Kylin support multi fact tables in the future? >> >> Many thanks! >> >> >> *Zhao Jun* >> >> >> >> >> -- >> With Warm regards >> >> Yiming Liu (刘一鸣) >> > > > > -- > With Warm regards > > Yiming Liu (刘一鸣) > -- Best regards, Shaofeng Shi
