Hi, Kylin developers We further investigate our query, and when I change my SQL query and remove the count(distinct) , it work fine , and from our query only return 231 records. When add the count(distinct) measure should not increase the return records, but I don’t know how kylin work inside to calucate the count(distinct), it seem need scan more many record to return the result? How to solve this problem?
Ps: right now we are using kylin version 1.3 [cid:[email protected]] B.R Austin.Woo 发件人: 吴钰彬 发送时间: 2016年5月31日 10:35 收件人: '[email protected]' <[email protected]> 抄送: '[email protected]' <[email protected]>; 李欣 <[email protected]>; 亓庆国 <[email protected]> 主题: how to extend the threshold for kylin query?(from baixing.com) Hi, Kylin developers. This is Austin, DW team lead from Baixing.com. thanks for reading this mail. Right now we are research on kylin solution adopt for our big data query engine to consume our website click and event data, When we build some cube and try query from them, we face an issue as below. [cid:[email protected]] But when we check the configure in /conf/kylin.properties set as below l Kylin.query.scan.threshold=40000000 Can you help advise is there anything we missing here? Looking forward your reply, and many thanks for your time. B.R Austin.Woo
