Patent ID: 11921716
Assignee: SNOWFLAKE INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 10:
11. 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:
parsing a query to determine a plurality of data processing operations associated with the query, the plurality of data processing operations comprising an AS OF JOIN operation between first time series data in a first table and second time series data in a second table;
generating a query plan of the query, the query plan including a plurality of nodes corresponding to the plurality of data processing operations, and at least one node of the plurality of nodes corresponding to the AS OF JOIN operation;
modifying the at least one node corresponding to the AS OF JOIN operation to generate a modified query plan of the query, the modifying 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; and
scheduling execution of the query by at least one of a plurality of computing nodes based on the modified query plan.