You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Daniel Carroza <dc...@stratio.com> on 2015/02/18 12:16:18 UTC
Can't find cube for fact table TEST_KYLIN_FACT
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>*
Re: Can't find cube for fact table TEST_KYLIN_FACT
Posted by "Shi, Shaofeng" <sh...@ebay.com>.
Hi Daniel,
Firstly, ³slr² means ³seller²; ³with_slr² or ³without_slr² means whether
or not having the seller as a dimension. You can see that in the
³*with_slr_*² cubes, ³seller_id² is a dimension, which means it support
queries for seller_id (either "select seller_id² or ³group by seller_id";
³without_slr² cubes doesn¹t support that.
Checking the test SQL that you pasted, it expects to return
TEST_KYLIN_FACT.SELLER_ID in the query result, while this info wasn¹t
defined in the ³without_slr² cube, so that column will be ignored when
building this cube. The only cube ³test_kylin_cube_without_slr_desc² in
your project couldn¹t fulfill so Kylin throws the exception. You can try
either remove that from the SQL, or build the ³with_slr² cubes before
execute this query. As we¹re on holiday vacation this week, I couldn¹t
verify this on my testing box. Please give a try and let us know if you
have further question.
On 2/18/15, 7:16 PM, "Daniel Carroza" <dc...@stratio.com> 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>*
Re: Can't find cube for fact table TEST_KYLIN_FACT
Posted by 周千昊 <z....@gmail.com>.
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 周千昊 <z....@gmail.com> 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 <dc...@stratio.com>
> 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 周千昊 <z....@gmail.com>:
>>
>> > 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 <dc...@stratio.com>
>> > 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>*
>> > >
>> >
>>
>
Re: Can't find cube for fact table TEST_KYLIN_FACT
Posted by 周千昊 <z....@gmail.com>.
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 <dc...@stratio.com>
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 周千昊 <z....@gmail.com>:
>
> > 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 <dc...@stratio.com>
> > 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>*
> > >
> >
>
Re: Can't find cube for fact table TEST_KYLIN_FACT
Posted by Daniel Carroza <dc...@stratio.com>.
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 周千昊 <z....@gmail.com>:
> 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 <dc...@stratio.com>
> 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>*
> >
>
Re: Can't find cube for fact table TEST_KYLIN_FACT
Posted by 周千昊 <z....@gmail.com>.
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 <dc...@stratio.com>
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>*
>