count(distinct case when condittion) &count(distinct) return same result

Hi there, Use kylin insight submit below sentence, --select sentence-- select count(distinct memberid) as memberid, count(distinct case when issuccess=1 then memberid else -1 end) as Xmemberid from tables where istest

Re: 答复: Kylin job killed by admin

hi 答复, Thank you for the solution. Now the cube is building properly without any issue. Thank You. -- View this message in context: http://apache-kylin.74782.x6.nabble.com/Kylin-job-killed-by-admin-tp7390p7397.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: Hive table design (multiple fact tables or rolled up)

In Kylin 1.x as it only allow one Fact table, you have to join multiple big tables as one before using in Cube. Of course you can do that with a Hive view, so all joins are over fly when Kylin fetches data from Hive. The impact is, when query Kylin you need to use the name of the joined table, inst

答复: Kylin job killed by admin

Hi Rahul, As the error log says, the job container was killed by the NM after the map task used much more memory than allowed. However you can adjust cube level MR parameters "mapreduce.map.memory.mb" and "mapreduce.map.java.opts" with " kylin.job.mr.config.override " as item prefix to overrid

?????? How kylin limit mapreduce task Memory!!!!

thx, I will contact my hadoop administrator. -- -- ??: "ShaoFeng Shi";; : 2017??3??8??(??) 10:13 ??: "dev"; : Re: How kylin limit mapreduce task Memory hi jian, the error message is already very clear, if you don't un

Re: How kylin limit mapreduce task Memory!!!!

hi jian, the error message is already very clear, if you don't understand, suggest you check document of hadoop/yarn or contact your hadoop administrator. 2017-03-08 20:04 GMT+08:00 《秦殇》！健 : > I adjust the value of yarn.app.mapreduce..am.resource.mb 120 to 60, all > everything keep going. > Why??

[jira] [Created] (KYLIN-2492) kylin fact table is not getting incremental from hive using curl command to build?

prasannaP created KYLIN-2492: Summary: kylin fact table is not getting incremental from hive using curl command to build? Key: KYLIN-2492 URL: https://issues.apache.org/jira/browse/KYLIN-2492 Project: Kyl

?????? How kylin limit mapreduce task Memory!!!!

I adjust the value of yarn.app.mapreduce..am.resource.mb 120 to 60, all everything keep going. Why??? -- -- ??: "";; : 2017??3??8??(??) 6:34 ??: "dev"; : ?? How kylin limit mapreduce task Memory I check

Kylin job killed by admin

hi all, A kylin job failed with message: killed by admin MAP capability required is more than the supported max container capability in the cluster. Killing the Job. mapResourceRequest: maxContainerCapability: Job received Kill while in RUNNING state. Thank You -- View this message in context:

?????? How kylin limit mapreduce task Memory!!!!

I checked my cube , the errors happened in Step3 Extract Fact Table Distinck Columns and had a warn message that security.UserGroupInfomation:1696: PriviledgedActionException as:jianye (Auth:SIMPLE) case java.io.IOException: my fact table has 131157 rows. Can found some questions? --

?????? How kylin limit mapreduce task Memory!!!!

I checked my cube , the errors happened in Step3 Extract Fact Table Distinck Columns. my fact table has 131157 rows. Can found some questions? -- -- ??: "Alberto Ram??n";; : 2017??3??8??(??) 3:52 ??: "dev"; : Re: How kyli