Re: Callback not only Email

2016-12-08 Thread Billy Liu
No interface yet. But you could setup mail account to send the notification mail if something wrong happens. The callback hook is an interesting feature. Maybe someone could contribute it to the community. 2016-12-09 14:07 GMT+08:00 张晓明(zhangxiaoming)-技术产品中心 : > Does Kylin support CallBack interf

Re: Cube tunning

2016-12-08 Thread Billy Liu
You are correct. Put dimensions which are used together into one aggr group is right. Suppose you have dimension A, B and C. If A and B in aggr group 1, and B and C in group 2, then Kylin will pre-compute AB, BC, but without AC. That means if you query by AB, the result will respond quickly, but if

Callback not only Email

2016-12-08 Thread 张晓明(zhangxiaoming)-技术产品中心
Does Kylin support CallBack interface if the cube Error or something else? Thanks

Re: Cube tunning

2016-12-08 Thread peter zhang
Billy, thanks very much for you quick reply. In my case, I logical split Aggregation-Groups by dimension category. As you can check out in my schema JSON, all the date related columns in a group, all the payment way related dimensions in another group and all the other junk dimensions that are no

Re: Cube tunning

2016-12-08 Thread Billy Liu
Suppose you have N dimensions, and all in one agg group, then the total cuboid will be 2^N. But if you split N into N1, N2, N3, which N1+N2+N3>=N, then the total cuboid will be 2^N1+2^N2+2^N3. You will figure out how improvement this could be. How to split the agg groups depends on how your query

Cube tunning

2016-12-08 Thread peter zhang
I build a cube. First time, without any tuning and no aggregation group setting, cube size is about 20G. Then refer tuning document, I add some aggregation group, cube is deduced to 71.02 MB. Unfortunately, query performance is also worse than before, most of the query latency is about more than 10

Use derived or Joint

2016-12-08 Thread Alberto Ramón
Typical case 1: *IDDate* *Month_ID* *Month_Txt* *DayWeek_ID* *DayWeek_Txt* *Year* 2016-03-01 3 March 2 Wendesday 2016 2016-03-02 3 March 3 Thursday 2016 2016-03-02 3 March 4 Friday 2016 IDDate is PK of Dim table and Unique SOL 1: Uses Hierarchy and Derived from non PK col

Cut Size

2016-12-08 Thread Alberto Ramón
I'm reading this MailList and have some doubts (Example ): region-cut-gb max-region-count hfile-siz