Hi, Kylin Developers, I am a newbie to Kylin system. During I investigate this awesome system, these questions come to me:
1. Can I build a cube from a SQL? For learn_kylin example, the SQL for "kylin_cube_sales" is: ``` sql SELECT FACT_TABLE.PART_DT ,FACT_TABLE.LEAF_CATEG_ID ,FACT_TABLE.LSTG_SITE_ID ,LOOKUP_2.META_CATEG_NAME ,LOOKUP_2.CATEG_LVL2_NAME ,LOOKUP_2.CATEG_LVL3_NAME ,FACT_TABLE.LSTG_FORMAT_NAME ,FACT_TABLE.PRICE ,FACT_TABLE.SELLER_ID FROM DEFAULT.KYLIN_SALES as FACT_TABLE INNER JOIN DEFAULT.KYLIN_CAL_DT as LOOKUP_1 ON FACT_TABLE.PART_DT = LOOKUP_1.CAL_DT INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as LOOKUP_2 ON FACT_TABLE.LEAF_CATEG_ID = LOOKUP_2.LEAF_CATEG_ID AND FACT_TABLE.LSTG_SITE_ID = LOOKUP_2.SITE_ID ``` 2. Kylin is super fast, can I route *unmatched* query to slow hive engine? For example, the simple query like "select * from kylin_sales" return a empty result set. Can I route query like this to the hive engine? Thanks.
