You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2017/07/25 07:01:11 UTC

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

Shaofeng SHI created KYLIN-2756:
-----------------------------------

             Summary: 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: Zhong,Jason


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)