Hello gaoyang,
In your case, you have two fact tables which both has one column "user_id",
these two columns both have duplicate values so you cannot use one of these
fact tables as a lookup table. You want get the distinct count of user_id which
occur in both two sides.
If what I
Hi Xiaoxiang,
I tried to query pushdown to solve this case , but it is too slow to meet the
need of us.
I will try something else to solve this problem.
Thank you for your advice.
Best regards,
Yang Gao
发件人: Xiaoxiang Yu [mailto:xiaoxiang...@kyligence.io]
发送时间: 2018年10月29日 17:39
收件人:
Hi gaoyang,
Is it possible to create a view which contains all data from these two
tables.(Maybe union them, that might solve you question.) After that you can
define a new cube use that view. Wish that could be help.
Best wishes,
Xiaoxiang Yu
发件人: 高扬02
答复:
Hi Xiaoxiang,
Thank you for your advice . I will try it .
Best regards,
Yang Gao
发件人: Xiaoxiang Yu [mailto:xiaoxiang...@kyligence.io]
发送时间: 2018年10月29日 18:23
收件人: user@kylin.apache.org
主题: Re: 答复: 答复: cube关联后的distinct问题
Hi gaoyang,
Is it possible to create a view which contains all data from
Hi Xiaoxiang,
Thank you for your reply.
So you mean , we cannot use Kylin to deal with the intersection of two sets
from two fact tables , is that true ?
If that is true , I cannot use “join” between two fact tables in two cubes.
And I cannot create a snowflake schema with the tow fact tables ,
Hi, kylin is a OLAP engine, it support star schema and snowflake schema. Both
star schema and snowflake schema support only one fact table. If these two
tables cannnot be found in one model, it cannot be executed on kylin.
As FAQ says [http://kylin.apache.org/docs/gettingstarted/faq.html]
Is
Thank you Yichen, for response. Its a very informative!
Regards,
Shrikant Bang.
On Mon, Oct 29, 2018 at 12:23 PM Yichen Zhou
wrote:
> Hi Shrikant,
>
>
> Kylin use FuzzyRowFilter instead of Bloom Filter. FuzzyRowFilter can find
> the row key which matches the specific pattern and skip scanning
Hi Shrikant,
Kylin use FuzzyRowFilter instead of Bloom Filter. FuzzyRowFilter can find the
row key which matches the specific pattern and skip scanning the records. It is
more suitable than bloom filter for kylin in most cases.
Sorry for long time elapsed, I just want Kylin to use china locale , but I
don’t know how to setup.
> On Oct 27, 2018, at 4:08 PM, George Ni wrote:
>
> Hi you Zhuang,
>
> Would you please provide more details about the log of the exception?
>
> Best regards,
>
> Chun’en Ni(George)
>
>
1. I can debug Kylin and standalone mr job in intellij idea with
-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=9001 , but I
don’t know how to debug both Kylin web server and whole build job flow, which
mean idea can’t set up two remote debug servers
2. can we write a
You may need this: http://kylin.apache.org/development/dev_env.html.
Using debug mode to launch org.apache.kylin.rest.DebugTomcat, then you can
debug Kylin server
--
Regards!
Aron Tao
you Zhuang 于2018年10月30日周二 下午12:04写道:
> 1. I can debug Kylin and standalone mr job in intellij idea with
>
Hi You,
I see it, you're correct; so far we don't have the plan to support
multi-languages; If you want to try, welcome to contribute a patch. Thank
you!
you Zhuang 于2018年10月30日周二 上午11:44写道:
> Sorry for long time elapsed, I just want Kylin to use china locale , but I
> don’t know how to setup.
12 matches
Mail list logo