The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Mar. 05, 2024
Filed:
Aug. 21, 2023
Snowflake Inc., Bozeman, MT (US);
Hossein Ahmandi, Seattle, WA (US);
Jayanta Das, Bellevue, WA (US);
Joshua Klahr, San Carlos, CA (US);
Boyung Lee, Kirkland, WA (US);
Wenye Li, Bellevue, WA (US);
Abdul Q. Munir, Bozeman, MT (US);
Yi Pan, San Jose, CA (US);
Snowflake Inc., Bozeman, MT (US);
Abstract
A method includes parsing a query to determine a plurality of data processing operations associated with the query and including an AS OF JOIN operation between first time series data in a first table and second time series data in a second table. A query plan of the query is generated. The query plan includes a plurality of nodes corresponding to the plurality of data processing operations. At least one of the plurality of nodes corresponding to the AS OF JOIN operation is modified to generate a modified query plan of the query. The modifying is based on applying a UNION operation on at least a first portion of column data in the first table and the second table to obtain a combined table. Execution of the query by at least one of a plurality of computing nodes is scheduled based on the modified query plan.