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 > >> >> > > >> >> > >> > > >> > > >
