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