Re: Joint VS Derived

2016-07-01 Thread Julian Hyde
A real(ish) world example would help me understand. Can you give an example of a joint dimension in terms of sales, customers, products, etc.? > On Jul 1, 2016, at 2:01 AM, ShaoFeng Shi wrote: > > "joint" just tell Kylin to prune certain combinations; for example, "joint > AB" will prune all c

Re: Model Designer Dimensions

2016-07-01 Thread hongbin ma
hi shaofeng can you attach the JIAR here, too?

Re: Model Designer Dimensions

2016-07-01 Thread hongbin ma
I got it, it's KYLIN-1838 On Fri, Jul 1, 2016 at 6:43 PM, hongbin ma wrote: > hi shaofeng > > can you attach the JIAR here, too? > -- Regards, *Bin Mahone | 马洪宾*

关于cube build和merge的问题

2016-07-01 Thread 仇同心
大家好: 目前在kylin的使用过程中遇到以下一个问题: Cube构建时,开始时间设置为:2016-06-27 00:00:00结束时间为:2016-06-27 16:00:00 这样build 任务时,第一步从hive 抽取数据时where 条件是 >=2016-06-27 and <2016-06-27 导致没有抽取到数据,最后保存的hbase里也只是一个空表而已。 为了预计算27号的数据,也build另一个job, 开始时间设置为:2016-06-27 16:00:00结束时间为:2016-06-28 00:00:00 这样build 任务时,第一步从hive 抽

关于cube build和merge的问题

2016-07-01 Thread 仇同心
大家好: 目前在kylin的使用过程中遇到以下一个问题: Cube构建时,开始时间设置为:2016-06-27 00:00:00结束时间为:2016-06-27 16:00:00 这样build 任务时,第一步从hive 抽取数据时where 条件是 >=2016-06-27 and <2016-06-27 导致没有抽取到数据,最后保存的hbase里也只是一个空表而已。 为了预计算27号的数据,也build另一个job, 开始时间设置为:2016-06-27 16:00:00结束时间为:2016-06-28 00:00:00 这样build 任务时,第一步从hive 抽

Re: Joint VS Derived

2016-07-01 Thread ShaoFeng Shi
"joint" just tell Kylin to prune certain combinations; for example, "joint AB" will prune all combinations that only has A or only has B; the order in "joint" doesn't matter; for case 3), it should not be allowed on Kylin's GUI, can you verify? 2016-07-01 14:47 GMT+08:00 Richard Calaba (Fishbow

答复: 答复: kylin查询,报超时异常:Timeout visiting cube!

2016-07-01 Thread 仇同心
OK,我修改下dimension试试。 谢谢! -邮件原件- 发件人: ShaoFeng Shi [mailto:shaofeng...@apache.org] 发送时间: 2016年7月1日 13:23 收件人: user@kylin.apache.org 抄送: d...@kylin.apache.org 主题: Re: 答复: kylin查询,报超时异常:Timeout visiting cube! "derived" need post aggregation as we know; from Day to Month, it need aggregate