公开(公告)号：US20250068628A1

公开(公告)日：2025-02-27

申请号：US18392385

申请日：2023-12-21

Applicant: Snowflake Inc.

Inventor： Hossein Ahmandi ,  Jayanta Das ,  Joshua Klahr ,  Boyung Lee ,  Wenye Li ,  Abdul Q. Munir ,  Yi Pan

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/27

Abstract: A method includes generating, by at least one hardware processor, a query plan of a query. The query includes a JOIN operation between first time series data and second time series data. At least one node in the query plan corresponding to the JOIN operation is modified to generate a modified query plan. The modifying is based on replacing the at least one node with a new node including a UNION operation. The UNION operation is based on the first time series data and the second time series data. Execution of the query is scheduled based on the modified query plan.

公开(公告)号：US11921716B1

公开(公告)日：2024-03-05

申请号：US18453079

申请日：2023-08-21

Applicant: Snowflake Inc.

Inventor： Hossein Ahmandi ,  Jayanta Das ,  Joshua Klahr ,  Boyung Lee ,  Wenye Li ,  Abdul Q. Munir ,  Yi Pan

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/27

CPC classification number: G06F16/24537 ,  G06F16/2456 ,  G06F16/278 ,  G06F16/24544

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.