Executes a GAQ and returns the result as an Arrow stream.
Executes a GAQ on the specified cube and branch, with given measures, coordinates, filters, context, and timeout. The result is returned as an Apache Arrow stream.
Body
The name of the cube to query.
The list of measures to include in the query.
The specific branch of the cube to query. By default, the branch set by activeviam.branch.master property.
Additional context values to configure query execution. Supported context values include:
queriesTimeLimit: Query timeout in seconds (e.g., "30")queriesResultLimit: Maximum number of cells to return (e.g., "10000")
Context values are applied during query execution and reset after the query completes.
The coordinates for the query, mapping level descriptions to level members.
Use null or the wildcard string as the value to express a wildcard (all members) for a given level. The wildcard string defaults to [*] and can be configured via the activepivot.location.wildcard system property. For example: {"Currency@Currency@Currency": ["[*]"]}.
Filter conditions to apply to the query.
Pagination window over the rows. When set, the server keeps a materialized view of the result and streams only the rows in [offset, offset + limit) as a full window snapshot on every update.
Ordering applied to the streamed rows. Sorting is only available for continuous queries. A one-shot query rejects a non-empty value. Each entry references either a requested measure (by name) or an expressed level (by its description, the same string form used as a coordinates key) and a direction. Entries are applied in order: the first is the primary key, the next break ties. Null values always sort last, regardless of direction. The ordering applies to the initial result, full-refresh updates, and the added rows of delta updates; removed rows of a delta update are ordered by the level keys only, since they carry no measure value. When omitted or empty, rows are ordered by the query's coordinate levels in ascending order, following the order they appear in coordinates.
The timeout for the query in seconds.
Response
Successful execution of the GAQ.
The response is of type string.