Hi, What I've understood about Kylin is that it choose between cubes and relational queries to satisfy a given query depending on if the cube is available or not, right?
I'm trying to test it and check this performance with and without a cube. After I've built the cube *test_kylin_cube_without_slr_desc* (BTW, what does slr mean? ) I get this error: Can't find cube for fact table TEST_KYLIN_FACT in project DEFAULT with dimensions [TEST_KYLIN_FACT.SLR_SEGMENT_CD, TEST_KYLIN_FACT.PRICE, TEST_CATEGORY_GROUPINGS.CATEG_LVL3_NAME, TEST_CATEGORY_GROUPINGS.META_CATEG_NAME, TEST_KYLIN_FACT.LEAF_CATEG_ID, TEST_KYLIN_FACT.LSTG_SITE_ID, TEST_KYLIN_FACT.SELLER_ID, TEST_KYLIN_FACT.CAL_DT, TEST_CATEGORY_GROUPINGS.CATEG_LVL2_NAME, TEST_KYLIN_FACT.LSTG_FORMAT_NAME] and measures []. Also please check whether join types match what defined in Cube. while executing SQL: "SELECT TEST_KYLIN_FACT.CAL_DT ,TEST_KYLIN_FACT.LEAF_CATEG_ID ,TEST_KYLIN_FACT.LSTG_SITE_ID ,TEST_CATEGORY_GROUPINGS.META_CATEG_NAME ,TEST_CATEGORY_GROUPINGS.CATEG_LVL2_NAME ,TEST_CATEGORY_GROUPINGS.CATEG_LVL3_NAME ,TEST_KYLIN_FACT.LSTG_FORMAT_NAME ,TEST_KYLIN_FACT.SLR_SEGMENT_CD ,TEST_KYLIN_FACT.PRICE ,TEST_KYLIN_FACT.SELLER_ID FROM TEST_KYLIN_FACT INNER JOIN TEST_CAL_DT ON TEST_KYLIN_FACT.CAL_DT = TEST_CAL_DT.CAL_DT INNER JOIN TEST_CATEGORY_GROUPINGS ON TEST_KYLIN_FACT.LEAF_CATEG_ID = TEST_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND TEST_KYLIN_FACT.LSTG_SITE_ID = TEST_CATEGORY_GROUPINGS.SITE_ID INNER JOIN TEST_SITES ON TEST_KYLIN_FACT.LSTG_SITE_ID = TEST_SITES.SITE_ID INNER JOIN TEST_SELLER_TYPE_DIM ON TEST_KYLIN_FACT.SLR_SEGMENT_CD = TEST_SELLER_TYPE_DIM.SELLER_TYPE_CD LIMIT 50000" What I'm missing? Thanks in advance Daniel Carroza <http://www.stratio.com/> Vía de las Dos Castillas, 33, Ática 4, 3ª Planta. 28224 Pozuelo de Alarcón. Madrid. Tel: +34 91 828 64 73 // *@stratiobd <https://twitter.com/StratioBD>*
