You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Bhanu Mohanty <bh...@gmail.com> on 2016/01/14 04:41:48 UTC
Two cubes on same FACT table
Can I create two cubes on same base table ?
All the queries point to same FACT table name . How can i use the cube name
instead of fact table name ?
Re: Two cubes on same FACT table
Posted by yu feng <ol...@gmail.com>.
It should works, In kylin, it is not recommend to create two cubes with
same fact table in the same project...
2016-01-14 12:41 GMT+08:00 Bhanu Mohanty <bh...@gmail.com>:
> for now , I created two projects.
> two cubes on same hive tables , but in two projects . Hopefully that will
> work.
>
> On Wed, Jan 13, 2016 at 8:39 PM, yu feng <ol...@gmail.com> wrote:
>
>> You have to use table name in your query, if you want to query
>> on specific cube, you can create two view on the same fact table with
>> different name and create cube view different view, If your query match two
>> cube, kylin do not know which one is you want, so maybe result can not make
>> you satisfied.
>>
>> 2016-01-14 11:41 GMT+08:00 Bhanu Mohanty <bh...@gmail.com>:
>>
>>> Can I create two cubes on same base table ?
>>> All the queries point to same FACT table name . How can i use the cube
>>> name instead of fact table name ?
>>>
>>
>>
>
Re: Two cubes on same FACT table
Posted by Bhanu Mohanty <bh...@gmail.com>.
for now , I created two projects.
two cubes on same hive tables , but in two projects . Hopefully that will
work.
On Wed, Jan 13, 2016 at 8:39 PM, yu feng <ol...@gmail.com> wrote:
> You have to use table name in your query, if you want to query on specific
> cube, you can create two view on the same fact table with different name
> and create cube view different view, If your query match two cube, kylin do
> not know which one is you want, so maybe result can not make you satisfied.
>
> 2016-01-14 11:41 GMT+08:00 Bhanu Mohanty <bh...@gmail.com>:
>
>> Can I create two cubes on same base table ?
>> All the queries point to same FACT table name . How can i use the cube
>> name instead of fact table name ?
>>
>
>
Re: Two cubes on same FACT table
Posted by yu feng <ol...@gmail.com>.
You have to use table name in your query, if you want to query on specific
cube, you can create two view on the same fact table with different name
and create cube view different view, If your query match two cube, kylin do
not know which one is you want, so maybe result can not make you satisfied.
2016-01-14 11:41 GMT+08:00 Bhanu Mohanty <bh...@gmail.com>:
> Can I create two cubes on same base table ?
> All the queries point to same FACT table name . How can i use the cube
> name instead of fact table name ?
>