Sorry for replying to the same thread. As Shaofeng has said, different cube may meet the need of different query. So if you are going to run that query, you may need to create a cube by yourself.
On Fri Feb 20 2015 at 11:18:41 PM 周千昊 <[email protected]> wrote: > Hi, Santosh > There should be some folder like ${hdp_home}/hive/conf, please also add > this directory to the classpath > > On Fri Feb 20 2015 at 8:37:31 PM Daniel Carroza <[email protected]> > wrote: > >> 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>* >> > > >> > >> >
