You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2017/07/25 07:05:00 UTC

[jira] [Assigned] (KYLIN-2756) Let "LIMIT" be optional in "Inspect" page

     [ https://issues.apache.org/jira/browse/KYLIN-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shaofeng SHI reassigned KYLIN-2756:
-----------------------------------

    Assignee: Zhixiong Chen  (was: Zhong,Jason)

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