Is there any way to paging query using plyql?

13 views
Skip to first unread message

Y H

unread,
Sep 23, 2021, 4:41:03 AMSep 23
to Druid User
hi, i make some program using plyql ( https://plywood.imply.io/plyql )


and i can't find any docs to paging using plyql

pls let me know how to if there is way to do 
thanks! 

Sergio Ferragut

unread,
Oct 11, 2021, 8:22:16 PMOct 11
to Druid User
Have you tried OFFSET / LIMIT, here is the SQL documentation that describes it.
Essentially you can use 
SELECT .... OFFSET x LIMIT y
where x is the starting point of a page and y is the number of rows you want in return.
Note that the docs mentions a few of cautions, including:
- If the data changes between consecutive queries for different pages (i.e. new streaming data is ingested), the contents may not be consistently paged because the data that is being paged through has changed.
- Skipped rows still need to be generated internally and then discarded, meaning that raising offsets to high values can cause queries to use additional resources.
Reply all
Reply to author
Forward
0 new messages