You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Dong Li (JIRA)" <ji...@apache.org> on 2017/10/19 15:23:00 UTC
[jira] [Commented] (KYLIN-2756) Let "LIMIT" be optional in
"Inspect" page
[ https://issues.apache.org/jira/browse/KYLIN-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16211196#comment-16211196 ]
Dong Li commented on KYLIN-2756:
--------------------------------
[~bob123] Please set "Fix version" when you resolve this JIRA.
If patch merged to master branch, set to v2.3.0
If patch merged to 2.2.x branch, set to v2.2.0
> Let "LIMIT" be optional in "Inspect" page
> -----------------------------------------
>
> Key: KYLIN-2756
> URL: https://issues.apache.org/jira/browse/KYLIN-2756
> Project: Kylin
> Issue Type: Bug
> Components: Web
> Reporter: Shaofeng SHI
> Assignee: Zhixiong Chen
> Attachments: 0001-KYLIN-2756-Let-LIMIT-be-optional-in-inspect-page.patch
>
>
> Kylin's "Inspect" page will append a LIMIT clause for queries if the query doesn't have "LIMIT";
> While this will make some query be invalid because "LIMIT" not always appear in the last position. For example:
> select * from KYLIN_SALES OFFSET 100 ROWS FETCH FIRST 10 ROWS ONLY
> According to Calcite's SQL reference, LIMIT should be before OFFSET clause.
> So, Kylin should give user the option of not append the "LIMIT".
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)