kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Yang <liy...@apache.org>
Subject Re: BadQueryDetector (Please ignore the last post)
Date Fri, 26 May 2017 08:46:34 GMT
Thanks!

JIRA created https://issues.apache.org/jira/browse/KYLIN-2649

On Sun, May 14, 2017 at 5:34 PM, 赵天烁 <zhaotianshuo@meizu.com> 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
>
>
>
> -------- 原始邮件 --------
> 发件人:赵天烁 <zhaotianshuo@meizu.com>
> 时间:周日 5月14日 17:28
> 收件人:dev@kylin.apache.org
> 主题: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 <liyang@apache.org>
> 时间:周日 5月14日 17:01
> 收件人:dev@kylin.apache.org
> 主题: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, 赵天烁 <zhaotianshuo@meizu.com> wrote:
>
> > we have the same issue....
> >
> >
> >
> > 来自 赵天烁的 魅族 MX
> >
> >
> >
> > -------- 原始邮件 --------
> > 发件人:Li Yang <liyang@apache.org>
> > 时间:周日 5月14日 10:12
> > 收件人:dev@kylin.apache.org
> > 主题: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 <billyliu@apache.org> 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 <rahul.singh@i-link.co.in>:
> > >
> > > > 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.
> > > >
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message