Continue paged query
hana_query_next_pageFetch the next page of a truncated query result using a snapshotId from a previous execution. Use the same SQL and parameters, respecting the snapshot TTL.
Instructions
Fetch the next page of a truncated SELECT using snapshotId from a previous hana_execute_query result (same SQL and parameters; TTL HANA_QUERY_SNAPSHOT_TTL_MS).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| offset | Yes | Offset for this page (usually prior nextOffset) | |
| max_rows | No | Optional page size override (capped by server) | |
| snapshot_id | Yes | snapshotId from structuredContent of a truncated query result |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| kind | Yes | ||
| rows | Yes | ||
| offset | Yes | ||
| columns | Yes | ||
| maxRows | Yes | ||
| elapsedMs | No | ||
| totalRows | No | ||
| truncated | Yes | ||
| nextOffset | No | ||
| snapshotId | No | ||
| appliedWrap | Yes | ||
| returnedRows | Yes | ||
| columnsOmitted | Yes |