Invention Grant
- Patent Title: Quiesce notifications for query retries
-
Application No.: US17823877Application Date: 2022-08-31
-
Publication No.: US11704200B2Publication Date: 2023-07-18
- Inventor: Ata E. Husain Bohra , Daniel Geoffrey Karp
- 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: G06F11/14
- IPC: G06F11/14 ; G06F16/245 ; G06F16/25 ; G06F9/50

Abstract:
The subject technology retrieves information related to a set of instances of compute service managers, each instance of a particular compute service manager being associated with a set of virtual warehouses. The subject technology filters the information to determine a set of candidates from the set of instances of compute service managers. The subject technology sorts the set of candidates based at least in part on each workload of each of the set of candidates. The subject technology selects a candidate compute service manager from the set of instances of compute service managers to issue a query restart by randomly selecting an execution node, the execution node being included in a particular virtual warehouse associated with the candidate compute service manager, the selecting facilitating improving utilization of cluster resources and improving query execution on the selected candidate compute service manager.
Public/Granted literature
- US20230030636A1 QUIESCE NOTIFICATIONS FOR QUERY RETRIES Public/Granted day:2023-02-02
Information query