But I use kylin1.6,not kylin2.1. Should I upgrade the version？And my hbase is 0.98.
来自 魅族 PRO 6s -------- 原始邮件 -------- 发件人：Billy Liu <[email protected]> 时间：周三 8月30日 10:54 收件人：dev <[email protected]> 主题：Re: use tableau connect to kylin >Following parameter works for Kylin 2.1 >kylin.query.max-scan-bytes & kylin.storage.partition.max-scan-bytes > >kylin.query.scan.threshold has been deprecated >And there is no kylin.query.mem.budget parameter. > >2017-08-30 9:18 GMT+08:00 shendandan2015yeah <[email protected]>: > >> 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 >> >> > >> >> >> > >> >
