US 12,248,485 B2
Fetching query result data using result batches
Harsha S. Kapre, San Mateo, CA (US); Mark T. Keller, San Mateo, CA (US); Srinath Shankar, Belmont, CA (US); and Kushan A Zaveri, North York (CA)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Jan. 22, 2024, as Appl. No. 18/419,165.
Application 18/419,165 is a continuation of application No. 17/813,662, filed on Jul. 20, 2022, granted, now 11,921,733.
Application 17/813,662 is a continuation of application No. 17/501,992, filed on Oct. 14, 2021, granted, now 11,449,520.
Prior Publication US 2024/0160636 A1, May 16, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/2458 (2019.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/2471 (2019.01) [G06F 16/24532 (2019.01); G06F 16/24561 (2019.01); G06F 16/256 (2019.01); G06F 16/258 (2019.01)] 30 Claims
OG exemplary drawing
 
1. A system comprising:
at least one hardware processor; and
at least one memory storing instructions that cause the at least one hardware processor to perform operations comprising:
retrieving query result information from a first computing node of a database system, the query result information including result data associated with a multi-stage execution of a query;
generating a plurality of result batches based on the query result information, the plurality of result batches corresponding to a plurality of execution stages of the multi-stage execution, and each result batch of the plurality of result batches including a retrieval function for a portion of the result data for a corresponding execution stage of the plurality of execution stages;
causing retrieval of the portion of the result data for each result batch of the plurality of result batches based on execution of the retrieval function by at least a second computing node of the database system; and
outputting the result data associated with the multi-stage execution of the query based on completion of the retrieval.