Kylin Performance

I made a small tech notes about my performance tests, the doc is unfinished (I need more time, test and knowledge) Review my English mistakes is pending If somebody have any comment, test, more experience , ... feel free make any suggestion Alb

Re: Re: kylin 1.6 supports SQL right join

excute sql: (select cate1 from kylinlabel.USER_TAG group by cate1) as t5 left join (select t3.CATE1,count(*) from (select CATE1 ,CATE2 from kylinlabel.USER_TAG group by CATE1 ,CATE2) as t3 group by t3.CATE1) as t4 on (t4.cate1=t5.cate1) get error: Encountered "as" at line 1, column 56. Was

Re: Table 'AFFILIATE_VALID_CLICK' not found. Sometimes table notfound,Why?

I merge all segments of this cube, it is not ok. Then i refresh this cube(rebuild), the query is ok. I do not konw why. The info of model and cube is blow: The model info: { "uuid": "0cecfa23-d4fc-485b-a271-ae2d3aee4668", "last_modified": 1479707363914, "version": "1.6.0", "name":

kylin 1.6 supports SQL right join

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"

Re: kylin 1.6 supports SQL right join

Kylin supports left join and inner join. The right join could be rewritten into left join. Could you have a try? 2016-12-21 11:52 GMT+08:00 wang...@snqu.com : > Hi > when I excute the sql: > (select t3.CATE1,count(*) from (select CATE1 ,CATE2 from > kylinlabel.USER_TAG

Re: Failed with "Build Cube" in 18 step

I think more detail about the failed job is needed. 2016-12-20 16:11 GMT+08:00 Luke_Selina : > Hei guys! > Just now I have build a Cube with SSB data, and only 10 dimensions > used. > But the cube build failed, I saw the MR logs, it shows the build failed in >

Table 'AFFILIATE_VALID_CLICK' not found. Sometimes table not found,Why?

2016-12-20 01:42:12,525 INFO [Query c4a5ddd0-7a64-4aa1-a8b0-5c4b4f710101-70] service.QueryService:336 : Using project: affiliate_report 2016-12-20 01:42:12,525 INFO [Query c4a5ddd0-7a64-4aa1-a8b0-5c4b4f710101-70] service.QueryService:337 : The original query: SELECT sum(counter) FROM

[jira] [Created] (KYLIN-2302) push the value in statement.setMaxRows(10) to storage

hongbin ma created KYLIN-2302: - Summary: push the value in statement.setMaxRows(10) to storage Key: KYLIN-2302 URL: https://issues.apache.org/jira/browse/KYLIN-2302 Project: Kylin Issue Type:

[jira] [Created] (KYLIN-2303) Step Convert Cuboid Data to HFile always get high CPU

hoangle created KYLIN-2303: -- Summary: Step Convert Cuboid Data to HFile always get high CPU Key: KYLIN-2303 URL: https://issues.apache.org/jira/browse/KYLIN-2303 Project: Kylin Issue Type: Bug

Table 'AFFILIATE_VALID_CLICK' not found. Sometimes table not found,Why?

2016-12-20 01:42:12,525 INFO [Query c4a5ddd0-7a64-4aa1-a8b0-5c4b4f710101-70] service.QueryService:336 : Using project: affiliate_report 2016-12-20 01:42:12,525 INFO [Query c4a5ddd0-7a64-4aa1-a8b0-5c4b4f710101-70] service.QueryService:337 : The original query: SELECT sum(counter) FROM

Failed with "Build Cube" in 18 step

Hei guys! Just now I have build a Cube with SSB data, and only 10 dimensions used. But the cube build failed, I saw the MR logs, it shows the build failed in reduce period, how can I config to make the reduce can use more memory, or with less number of reduce? Thank you! -- View this

[jira] [Created] (KYLIN-2304) Only copy latest version dict for global dict

kangkaisen created KYLIN-2304: - Summary: Only copy latest version dict for global dict Key: KYLIN-2304 URL: https://issues.apache.org/jira/browse/KYLIN-2304 Project: Kylin Issue Type:

[jira] [Created] (KYLIN-2305) Unable to use long searchBase/Pattern for LDAP

mathias kluba created KYLIN-2305: Summary: Unable to use long searchBase/Pattern for LDAP Key: KYLIN-2305 URL: https://issues.apache.org/jira/browse/KYLIN-2305 Project: Kylin Issue Type: Bug

Re: Failed with "Build Cube" in 18 step

I change the default *kylin.job.mapreduce.default.reduce.input.mb = 500 --> 5* then the build have successed! But the mr log shows it have failed two time in convert the cuboid to hfile(19 step), so how many time will the mr job try before the task failed, is it configured? But I still

Re: Table 'AFFILIATE_VALID_CLICK' not found. Sometimes table not found,Why?

The error is so obviously, your sql can't realize your table 'AFFILIATE_VALID_CLICK', so you may try you fix it by the following steps 1. make sure table name is true 2. try figure out your cube built with this table If all these are right , paste your model, cube info here. -- View this message