a problem of build cube

2016-12-28 Thread wang...@snqu.com
can be build to 3 lines or 1 line ? wang...@snqu.com

Re: Re: kylin 1.6 supports SQL right join

2016-12-20 Thread wang...@snqu.com
"=" ... ">" ... "<" ... "<=" ... ">=" ... "<>" ... "+" ... "-" ... "*" ... "/" ... "||" ... "AND" ... "OR" ... "IS" ... "MEMBER" ...

kylin 1.6 supports SQL right join

2016-12-20 Thread wang...@snqu.com
Hi when I excute the sql: (select t3.CATE1,count(*) from (select CATE1 ,CATE2 from kylinlabel.USER_TAG group by CATE1 ,CATE2) as t3 group by t3.CATE1) as t4 right join (select cate1 from kylinlabel.USER_TAG group by cate1) as t5 on (t4.cate1=t5.cate1) I got the error: Encountered "as"

kylin 1.6.0 cardinality can't greater than 5000000 ?

2016-12-07 Thread wang...@snqu.com
I improved the version from 1.5.4.1 to 1.6.0 and modified KYLIN_HOME, and modied "kylin.dictionary.max.cardinality=500" to "kylin.dictionary.max.cardinality=3000" in file kylin.properties, then start kylin 1.6-->create model-->create cube-->build cube I got the following error

Re: Re: 使用全局字典报错AppendTrieDictionary can't retrive value from id

2016-12-07 Thread wang...@snqu.com
count(label) from USERCASE_20161204 group by label order by label desc". If you could, please using English also. This is worldwide community, English is the better language for everyone. 2016-12-06 13:24 GMT+08:00 wang...@snqu.com <wang...@snqu.com>: > Hi Roger > > cu

回复: 使用全局字典报错AppendTrieDictionary can't retrive value from id

2016-12-05 Thread wang...@snqu.com
c633ee-dffb-4d80-9844-768b6ee21782.dict", "DEFAULT.USERCASE_20161204/LOCAL": "/dict/DEFAULT.USERCASE_20161204/LOCAL/31ed5b68-aae2-40b7-ba09-83abf1d64953.dict", "DEFAULT.USERCASE_20161204/ROWKEY": "/dict/DEFAULT.USERCASE_20161204/ROWKE

使用全局字典报错AppendTrieDictionary can't retrive value from id

2016-12-04 Thread wang...@snqu.com
hi, 每个维度的基数有590万,当在rowkey中选择dict时,编译产生错误: “Too high cardinality is not suitable for dictionary -- cardinality: 5978388“ 所以修改了model, 没有定义rowkey, 对所有维度定义了全局字典,build成功,查询时报错: “AppendTrieDictionary can't retrive value from id“

Re: Re: merge

2016-11-30 Thread wang...@snqu.com
lin remind user here; If you think the empty segment is okay, you can forcely merge them. 2016-11-30 16:02 GMT+08:00 wang...@snqu.com <wang...@snqu.com>: > hi, > the merge information is : > > PARTITION DATE COLUMN DEFAULT.DMP_USER.TIMESTAMP > MERGE START SEGMENT 20161110

回复: merge

2016-11-30 Thread wang...@snqu.com
...@snqu.com 发件人: wang...@snqu.com 发送时间: 2016-11-30 15:28 收件人: dev 主题: merge Hi, I have a problem about merge when I do merge, the information is following: the two segments are build from the same cube and one same table, after click "submit' I got “empty cube segment

use RESTful API to create cube and model

2016-11-11 Thread wang...@snqu.com
Can use RESTful API to create cube and model? In RESTful API user manual, thers is no API to create cube and model. <http://kylin.apache.org/docs15/howto/howto_use_restapi.html> wang...@snqu.com

kylin supports complex data type?

2016-11-10 Thread wang...@snqu.com
Does Kylin 1.5.4 support complex data type(Map, array, struct) in Hive? wang...@snqu.com