Version 1.2 feels long time ago... try to answer with my poor memory. If you are running queries from Kylin GUI, it by default returns PARTIAL result, which is capped at 10000 rows as of version 1.2 if I remember correctly. It is a mean to protected careless queries from flooding the server and web browser. It won't affect queries from Rest API/JDBC/ODBC.
When the GUI is showing partial result, there should be message stating it, and a link nearby to let you run a full query. Or at least that's how it is for the latest version. Recommend to upgrade to 1.5 versions. On Thu, Jun 9, 2016 at 6:47 AM, raja chowdary <[email protected]> wrote: > Hi, > Kylin is not returning any results if my query includes limit and offset. > Ex: select a, b, c, from fact_table group by a, b order by a dsc offset > 10000 limit 30 > This query works well for rows upto 10K and beyond that it returns blank > rows. > > I also noticed that the total scan count is always 10001. > > If I don't use offset and limit I always get all rows. > KYLIN VERSION = 1.2 > > I appreciate any help. > > Thanks > Raja >
