Are these two attributes？ kylin.query.scan.threshold=10000000 kylin.query.mem.budget=3221225472
来自 魅族 PRO 6s -------- 原始邮件 -------- 发件人：Billy Liu <[email protected]> 时间：周二 8月29日 19:42 收件人：dev <[email protected]> 主题：Re: use tableau connect to kylin >Queries like "select * from fact" tend to scan a lot of cube data. To make >them fail fast, you can decrease: > > 1. kylin.query.max-scan-bytes (by default INTEGER.MAX) to allow less > bytes scanned at query level > 2. kylin.storage.partition.max-scan-bytes (by default 3221225472) to > allow less bytes scanned at partition level > > >2017-08-29 18:48 GMT+08:00 shendandan2015yeah <[email protected]>: > >> >> >> >> 来自 魅族 PRO 6s >> >> -------- 原始邮件 -------- >> 发件人：shendandan2015yeah <[email protected]> >> 时间：周二 8月29日 18:40 >> 收件人：Billy Liu <[email protected]> >> 主题：Re: use tableau connect to kylin >> >> >in kylin.log, "select * from fact_table" takes the most time,because >> there are millon records. Then how to optimize the cube？ >> > >> >Thanks Billy. >> > >> >来自 魅族 PRO 6s >> > >> >-------- 原始邮件 -------- >> >发件人：Billy Liu <[email protected]> >> >时间：周二 8月29日 10:27 >> >收件人：dev <[email protected]> >> >主题：Re: use tableau connect to kylin >> > >> >1. Find the slow query sent from Tableau in kylin.log >> >2. Optimize the cube in Kylin >> > >> >2017-08-29 10:00 GMT+08:00 shendandan2015yeah <[email protected] >> >: >> > >> >> hello,I use tableau connect to kylin,and publish some reports to tableau >> >> server. But these reports open slowly. >> >> How can I improve this situation? >> >> Thank you. >> >> >> >> >> >> 来自 魅族 PRO 6s >> > >> >
