Re: paged query

2017-07-25 Thread ShaoFeng Shi
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_...@163.com : > > &g

Re: paged query

2017-07-24 Thread Julian Hyde
ould 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_...@163.com : > >> Hi, >> >> Kylin can su

Re: paged query

2017-07-21 Thread ShaoFeng Shi
ONLY" keyword after "ROWS". @Julian, can you confirm the issue 2)? thanks! 2017-07-21 17:59 GMT+08:00 apache_...@163.com : > Hi, > > Kylin can support paged query? This sql can't work > > > select * from KYLIN_SALES OFFSET 100 ROWS FETCH FI

paged query

2017-07-21 Thread apache_...@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 E