kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Billy Liu (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (KYLIN-2649) Tableau could send "select *" on a big table
Date Wed, 24 Jan 2018 11:23:00 GMT

     [ 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 	赵天烁 <zhaotianshuo@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)

Mime
View raw message