Invention Grant
- Patent Title: Query processing using a distributed stop operator
-
Application No.: US17815389Application Date: 2022-07-27
-
Publication No.: US12153602B2Publication Date: 2024-11-26
- Inventor: Sebastian Breß , Moritz Eyssen , Max Heimel
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2455 ; G06F16/27

Abstract:
A global and local row count limit associated with a limit query are received by a stop operator of a first execution node among a set of execution nodes that are assigned to process the limit query. Local distributed row count data is generated based on a local row count corresponding to a number of rows output by the first execution node in processing the query. Based on determining the local row count satisfies the local limit, the first execution node buffers rows produced in processing the query. The local distributed row count data is updated based on remote distributed row count data received from a second execution node. A stopping condition is detected based on determining the global limit is satisfied based on updated local distributed row count data and query processing by the first execution node based on detecting the stopping condition.
Public/Granted literature
- US20220382782A1 QUERY PROCESSING USING A DISTRIBUTED STOP OPERATOR Public/Granted day:2022-12-01
Information query