Mailing-List: contact dev-help@kylin.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@kylin.apache.org
MIME-Version: 1.0
In-Reply-To: <201707211759333072873@163.com>
References: <201707211759333072873@163.com>
From: ShaoFeng Shi <shaofengshi@apache.org>
Date: Sat, 22 Jul 2017 11:11:22 +0800
Message-ID: <CANfpUcsXw18aajWJpmf1wk125tEnELVZN1vYjnBuOK_KXTttqQ@mail.gmail.com>
Subject: Re: paged query
To: dev <dev@kylin.apache.org>, jhyde@apache.org
Content-Type: multipart/alternative; boundary="001a11499f687ae4920554df5835"
archived-at: Sat, 22 Jul 2017 03:12:07 -0000

--001a11499f687ae4920554df5835
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

The following SQL works in my side:

select * from KYLIN_SALES  LIMIT 100
OFFSET  1 ROWS  FETCH FIRST 10 ROWS ONLY

Here are two tricky things:

1) In Kylin's web GUI, it will automatically append a "LIMIT" after each
SQL if "LIMIT" wasn't appeared (this is to avoid too much data returned to
the web client); But in Calcite's grammer, "LIMIT" should appear before
"OFFSET"; so to bypass it I add the LIMIT here. If you send the query from
JDBC/ODBC or Rest API, there should be no such issue.

2) Calcite's document misses the "ONLY" keyword after "ROWS".

@Julian, can you confirm the issue 2)? thanks!


2017-07-21 17:59 GMT+08:00 apache_dev@163.com <apache_dev@163.com>:

> Hi,
>
>   Kylin can support paged query? This  sql can't work
>
>
>      select * from KYLIN_SALES   OFFSET  100 ROWS  FETCH FIRST 10 ROWS
>
>
>
> Calcite doc:
>
>   query:
> values | WITH withItem [ , withItem ]* query | { select |
> selectWithoutFrom | query UNION [ ALL | DISTINCT ] query | query EXCEPT [
> ALL | DISTINCT ] query | query MINUS [ ALL | DISTINCT ] query | query
> INTERSECT [ ALL | DISTINCT ] query } [ ORDER BY orderItem [, orderItem ]*=
 ]
> [ LIMIT { count | ALL } ] [ OFFSET start { ROW | ROWS } ] [ FETCH { FIRST=
 |
> NEXT } [ count ] { ROW | ROWS } ]
>
>
>
> apache_dev@163.com
>


--=20
Best regards,

Shaofeng Shi =E5=8F=B2=E5=B0=91=E9=94=8B

--001a11499f687ae4920554df5835--