Thanks! JIRA created https://issues.apache.org/jira/browse/KYLIN-2649
On Sun, May 14, 2017 at 5:34 PM, 赵天烁 <[email protected]> wrote: > forgot to mention that we do have some dimension table with 10x million > records,add a filter on that will also cause the same issue > > > > 来自 赵天烁的 魅族 MX > > > > -------- 原始邮件 -------- > 发件人：赵天烁 <[email protected]> > 时间：周日 5月14日 17:28 > 收件人：[email protected] > 主题：Re: BadQueryDetector (Please ignore the last post) > > you can try to add a filter on a colum of some big fact table,before you > try to pick some colum value as filter, tableau will send a select * query > without any limit clause to list all the column value for you to choose > from.and that is where it cause this problem. > > > > 来自 赵天烁的 魅族 MX > > > > -------- 原始邮件 -------- > 发件人：Li Yang <[email protected]> > 时间：周日 5月14日 17:01 > 收件人：[email protected] > 主题：Re: BadQueryDetector (Please ignore the last post) > > Could any one provide more details to reproduce this problem? At least I > didn't spot "select * from fact" when using Tableau+Kylin. > > Cheers > Yang > > On Sun, May 14, 2017 at 10:31 AM, 赵天烁 <[email protected]> wrote: > > > we have the same issue.... > > > > > > > > 来自 赵天烁的 魅族 MX > > > > > > > > -------- 原始邮件 -------- > > 发件人：Li Yang <[email protected]> > > 时间：周日 5月14日 10:12 > > 收件人：[email protected] > > 主题：Re: BadQueryDetector (Please ignore the last post) > > > > My impression is, when connecting live, Tableau will "select * from" > > DIMENSION table. And that is affordable. Tableau shall never "select * > > from" the FACT table. Could you verify? > > > > On Tue, May 9, 2017 at 1:59 PM, Billy Liu <[email protected]> wrote: > > > > > Have you checked the “Direct Mode” on Tableau? Have you asked for help > > from > > > Tableau community? > > > > > > 2017-04-25 23:12 GMT+08:00 rahulsingh <[email protected]>: > > > > > > > Hi all, > > > > > > > > We are using Tableau Desktop 10.2.1 with Kylin 1.6. We got success to > > > > connect kylin with tableau wia ODBC driver. > > > > We have one table in kylin having 41 columns and around 5 milion > > records. > > > > And we use this table as a data source in tableau. > > > > When we prepare report in Tableau with some rows and columns, it is > > > firing > > > > “select * from > > > > ” query on Kylin. Ideally Tableau should only fire specific group by > > > querys > > > > based on the reports. > > > > And because we have so many data in the cube, the “select * from > > > > ” query on kyline make the Kylin hangup and then it is not > responding. > > > > > > > > How should we handle this “select * from > > > > ” query from Tableau ? Do we have some settings that block this type > > of * > > > > query. > > > > > > > > Thank You, > > > > Rahul Singh > > > > > > > > -- > > > > View this message in context: http://apache-kylin.74782.x6. > > > > nabble.com/BadQueryDetector-Please-ignore-the-last-post-tp7770.html > > > > Sent from the Apache Kylin mailing list archive at Nabble.com. > > > > > > > > > >
