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?