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