Re: Hive table design (multiple fact tables or rolled up)

2018-09-03 Thread ShaoFeng Shi
Correct; Kylin supports star schema or snowflake schema, both are single fact table models. 2018-09-03 14:59 GMT+08:00 mvneethu : > Hi, > > I know this is the old post, but I don't think kylin 2.x has the facility > to > add more than 1 fact table. Is this correct. Please clarify. > > Thanks, >

Re: Hive table design (multiple fact tables or rolled up)

2018-09-03 Thread mvneethu
Hi, I know this is the old post, but I don't think kylin 2.x has the facility to add more than 1 fact table. Is this correct. Please clarify. Thanks, Neethu -- Sent from: http://apache-kylin.74782.x6.nabble.com/

Re: Hive table design (multiple fact tables or rolled up)

2017-03-08 Thread ShaoFeng Shi
In Kylin 1.x as it only allow one Fact table, you have to join multiple big tables as one before using in Cube. Of course you can do that with a Hive view, so all joins are over fly when Kylin fetches data from Hive. The impact is, when query Kylin you need to use the name of the joined table,