Re: 答复: cube关联后的distinct问题

2018-10-29 Thread Xiaoxiang Yu
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

答复: 答复: cube关联后的distinct问题

2018-10-29 Thread 高扬02
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 收件人:

Re: 答复: 答复: cube关联后的distinct问题

2018-10-29 Thread Xiaoxiang Yu
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 答复:

答复: 答复: 答复: cube关联后的distinct问题

2018-10-29 Thread 高扬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

答复: cube关联后的distinct问题

2018-10-29 Thread 高扬02
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 ,

Re: cube关联后的distinct问题

2018-10-29 Thread Xiaoxiang Yu
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

Re: Default Bloom Filters for HTables

2018-10-29 Thread Shrikant Bang
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

答复: Default Bloom Filters for HTables

2018-10-29 Thread Yichen Zhou
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.

Re: MsgPicker.setMsg method has not been invoked.

2018-10-29 Thread you Zhuang
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) > >

Kylin comprehensive debug documentation

2018-10-29 Thread you Zhuang
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

Re: Kylin comprehensive debug documentation

2018-10-29 Thread JiaTao Tao
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 >

Re: MsgPicker.setMsg method has not been invoked.

2018-10-29 Thread ShaoFeng Shi
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.