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

[Shaofeng SHI (JIRA)]

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)