Hi, 周千昊 I am using source code of: https://github.com/KylinOLAP/Kylin.git on branch master (commit 4907794baa5504dec9af7ac7d5e39527489ac745). The environment I'm using is this docker container which is a fork of https://github.com/sequenceiq/docker-kylin.git on branch 0.6.4. And the only change I've made is the following in order to fix some broken links:
https://github.com/danielcsant/docker-kylin/blob/master/Dockerfile I've realized that removing fields TEST_KYLIN_FACT.PRICE and TEST_KYLIN_FACT.SELLER_ID from select it works *just* when the cube is built 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>* 2015-02-20 5:46 GMT+01:00 周千昊 <[email protected]>: > Hi, Daniel > Would you please give us some details, for example > 1. are you running kylin from the source code or the tgz package > 2. if you are running with the source code, what exact commit are you > using > 3. your hadoop env, although it usually may not be the problem. > > On Wed Feb 18 2015 at 7:16:44 PM Daniel Carroza <[email protected]> > wrote: > > > 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>* > > >
