It seams kylin2.1 not supports hbase0.98,can I use kylin2.0? Are there many difference between kylin2.0 and kylin 2.1?
来自 魅族 PRO 6s -------- 原始邮件 -------- 发件人:Billy Liu <[email protected]> 时间:周三 8月30日 11:46 收件人:dev <[email protected]> 主题:Re: use tableau connect to kylin >The upgrade is always suggested. New version provides better performance >and bug fixes. > >2017-08-30 11:26 GMT+08:00 shendandan2015yeah <[email protected]>: > >> 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 >> >> >> > >> >> >> >> >> > >> >> >> > >> >
