-
1.
公开(公告)号:US20240086397A1
公开(公告)日:2024-03-14
申请号:US18511204
申请日:2023-11-16
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Johan Harjono , Kunal Prafulla Nabar , Steven James Pelley
IPC: G06F16/23 , G06F16/2455
CPC classification number: G06F16/2365 , G06F16/2455
Abstract: Systems, methods, and devices for retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of an execution platform, the one or more execution nodes configured to execute the query on a first version of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query to the one or more execution nodes of the execution platform and determining whether a regression or an intermittent fault caused the execution of the query to be unsuccessful based at least in part on whether the first retry execution of the query was successful or unsuccessful.
-
公开(公告)号:US20230176909A1
公开(公告)日:2023-06-08
申请号:US18161044
申请日:2023-01-28
Applicant: Snowflake Inc.
Inventor: Johan Harjono , Daniel Geoffrey Karp , Kunal Prafulla Nabar , Rares Radut , Arthur Kelvin Shi
CPC classification number: G06F9/5005 , G06F9/3555 , G06F9/505 , G06F9/5077 , G06F9/5083
Abstract: Techniques described herein can optimize usage of computing resources in a data system. Dynamic throttling can be performed locally on a computing resource in the foreground and autoscaling can be performed in a centralized fashion in the background. Dynamic throttling can lower the load without overshooting while minimizing oscillation and reducing the throttle quickly. Autoscaling may involve scaling in or out the number of computing resources in a cluster as well as scaling up or down the type of computing resources to handle different types of situations.
-
公开(公告)号:US11640347B2
公开(公告)日:2023-05-02
申请号:US17809780
申请日:2022-06-29
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Johan Harjono , Simon Holm Jensen , Kunal Prafulla Nabar , Steven James Pelley
IPC: G06F11/30 , G06F16/2458 , G06F11/34 , G06F16/242
Abstract: Techniques for automated query retry in a database platform include decoding, by at least one hardware processor, a query directed to database data from a client account of a database platform. The method further includes decoding, by the at least one hardware processor, an indication that execution of the query on at least one computing node of the database platform results in a failed execution. The method further includes configuring a processing loop with continuous retry executions of the query on the at least one computing node based on the indication. The method further includes exiting the processing loop based on detecting a retry execution of the continuous retry executions results in at least one successful execution of the query. The method includes logging each attempt to execute the query during the continuous retry executions in a query status log until the at least one successful execution of the query.
-
公开(公告)号:US11347550B1
公开(公告)日:2022-05-31
申请号:US17463376
申请日:2021-08-31
Applicant: Snowflake Inc.
Inventor: Johan Harjono , Daniel Geoffrey Karp , Kunal Prafulla Nabar , Rares Radut , Arthur Kelvin Shi
IPC: G06F9/50
Abstract: Techniques described herein can optimize usage of computing resources in a data system. Dynamic throttling can be performed locally on a computing resource in the foreground and autoscaling can be performed in a centralized fashion in the background. Dynamic throttling can lower the load without overshooting while minimizing oscillation and reducing the throttle quickly. Autoscaling may involve scaling in or out the number of computing resources in a cluster as well as scaling up or down the type of computing resources to handle different types of situations.
-
公开(公告)号:US10997050B2
公开(公告)日:2021-05-04
申请号:US17082959
申请日:2020-10-28
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Johan Harjono , Simon Holm Jensen , Kunal Prafulla Nabar , Steven James Pelley
IPC: G06F11/30 , G06F16/2458 , G06F11/34 , G06F11/32 , G06F16/248 , G06F16/242
Abstract: Systems, methods, and devices for retrying a query. A method includes receiving from a client account a query directed to database data associated with the client account. The method includes determining that the attempt to execute the query is unsuccessful and making retry attempts to execute the query until making a retry attempt that is successful. The method includes logging each retry attempt and generating a filtered transaction log at least in part by filtering out from the transaction log each unsuccessful attempt to execute the query and providing the filtered transaction log to the client account.
-
公开(公告)号:US20210064498A1
公开(公告)日:2021-03-04
申请号:US17082959
申请日:2020-10-28
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Johan Harjono , Simon Holm Jensen , Kunal Prafulla Nabar , Steven James Pelley
IPC: G06F11/30 , G06F11/32 , G06F16/242 , G06F11/34 , G06F16/2458 , G06F16/248
Abstract: Systems, methods, and devices for automatically retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query on the first version of the database platform and assigning a second retry execution of the query on a second version of the database platform.
-
公开(公告)号:US10915418B1
公开(公告)日:2021-02-09
申请号:US16555951
申请日:2019-08-29
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Johan Harjono , Simon Holm Jensen , Kunal Prafulla Nabar , Steven James Pelley
IPC: G06F11/30 , G06F16/242 , G06F16/2458 , G06F11/32 , G06F16/248 , G06F11/34 , G06F11/14
Abstract: Systems, methods, and devices for automatically retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query on the first version of the database platform and assigning a second retry execution of the query on a second version of the database platform.
-
公开(公告)号:US11874824B2
公开(公告)日:2024-01-16
申请号:US17933082
申请日:2022-09-17
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Johan Harjono , Kunal Prafulla Nabar , Steven James Pelley
IPC: G06F16/24 , G06F16/23 , G06F16/2455
CPC classification number: G06F16/2365 , G06F16/2455
Abstract: Systems, methods, and devices for retrying a query. A method includes receiving a query directed to database data and assigning execution of the query to one or more execution nodes of an execution platform, the one or more execution nodes configured to execute the query on a first version of a database platform. The method includes determining that execution of the query was unsuccessful. The method includes assigning a first retry execution of the query to the one or more execution nodes of the execution platform and determining whether a regression or an intermittent fault caused the execution of the query to be unsuccessful based at least in part on whether the first retry execution of the query was successful or unsuccessful.
-
公开(公告)号:US20230325362A1
公开(公告)日:2023-10-12
申请号:US18326645
申请日:2023-05-31
Applicant: Snowflake Inc.
Inventor: Johan Harjono , Daniel Geoffrey Karp , Rares Radut , Samir Rehmtulla , Arthur Kelvin Shi , Thanakul Wattanawong
IPC: G06F16/182 , G06F16/28
CPC classification number: G06F16/1824 , G06F16/285
Abstract: The subject technology selects a particular zone among multiple zones based on a target skew to meet a global balancing of cluster instances. The subject technology deploys a particular type of cluster instance to the particular zone. The subject technology, for each zone from the multiple zones, determines a respective number of cluster instances. The subject technology identifies a second particular type of cluster instance to add based on a total number of the second particular type of cluster instance in the multiple zones and a second total number of the particular type of cluster instance in the multiple zones. The subject technology adds the second particular type of cluster instance to a second particular zone to meet the global balancing of cluster instances in the multiple zones.
-
公开(公告)号:US20220413913A1
公开(公告)日:2022-12-29
申请号:US17463366
申请日:2021-08-31
Applicant: Snowflake Inc.
Inventor: Johan Harjono , Daniel Geoffrey Karp , Kunal Prafulla Nabar , Rares Radut , Arthur Kelvin Shi
IPC: G06F9/50
Abstract: Techniques described herein can optimize usage of computing resources in a data system. Dynamic throttling can be performed locally on a computing resource in the foreground and autoscaling can be performed in a centralized fashion in the background. Dynamic throttling can lower the load without overshooting while minimizing oscillation and reducing the throttle quickly. Autoscaling may involve scaling in or out the number of computing resources in a cluster as well as scaling up or down the type of computing resources to handle different types of situations.
-
-
-
-
-
-
-
-
-