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