You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Billy Liu (JIRA)" <ji...@apache.org> on 2018/01/24 11:23:00 UTC
[jira] [Resolved] (KYLIN-2649) Tableau could send "select *" on a
big table
[ https://issues.apache.org/jira/browse/KYLIN-2649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Billy Liu resolved KYLIN-2649.
------------------------------
Resolution: Fixed
Assignee: Roger Shi
Fix Version/s: v2.3.0
[https://github.com/apache/kylin/commit/a101229]
Enable “kylin.query.force-limit“ for select all statement
> Tableau could send "select *" on a big table
> --------------------------------------------
>
> Key: KYLIN-2649
> URL: https://issues.apache.org/jira/browse/KYLIN-2649
> Project: Kylin
> Issue Type: Improvement
> Reporter: liyang
> Assignee: Roger Shi
> Priority: Major
> Fix For: v2.3.0
>
>
> From 赵天烁 <zh...@meizu.com>
> 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.
> 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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)