Paging on search GUI

We are using flex tables on vertica with couple of materialized columns and __raw__ column and we are about to develop a web based search GUI for vertica. The problem we faced is to divide the huge search result into multiple pages. Vertica returns whole result to web server which causes web server to crash. Is there a function or method to pull the result set in chunks of for example 500 rows, and then next 500 rows?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file