Hi, Santosh
There should be some folder like ${hdp_home}/hive/conf, please also add
this directory to the classpathOn 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>* > > > > > >
