Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Appearance settings
This repository was archived by the owner on May 7, 2026. It is now read-only.

chore: make tpch golden sql runable #2548

Closed
chelsea-lin wants to merge 1 commit into from
Closed

chore: make tpch golden sql runable #2548

Show file tree
Hide file tree
Changes from all commits
Commits
Show all changes
1 commit
Select commit
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
6 changes: 4 additions & 2 deletions 6 tests/unit/core/compile/sqlglot/tpch/conftest.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -107,10 +107,12 @@
def tpch_session():
from bigframes.testing import compiler_session

anonymous_dataset = bigquery.DatasetReference.from_string("bigframes-dev.tpch")
anonymous_dataset = bigquery.DatasetReference.from_string(
"bigframes-dev-perf.tpch_0001t"
)
location = "us-central1"

with freezegun.freeze_time("2026-03-10 18:00:00"):
with freezegun.freeze_time("2026-03-30 18:00:00"):
session = mocks.create_bigquery_session(
anonymous_dataset=anonymous_dataset,
location=location,
Expand Down
2 changes: 1 addition & 1 deletion 2 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/1/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -38,7 +38,7 @@ WITH `bfcte_0` AS (
) * (
1.0 + `L_TAX`
) AS `bfcol_47`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
WHERE
`L_SHIPDATE` <= CAST('1998-09-02' AS DATE)
), `bfcte_1` AS (
Expand Down
8 changes: 4 additions & 4 deletions 8 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/10/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -2,20 +2,20 @@ WITH `bfcte_0` AS (
SELECT
`N_NATIONKEY` AS `bfcol_0`,
`N_NAME` AS `bfcol_1`
FROM `bigframes-dev`.`tpch`.`NATION` AS `bft_3` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`NATION` AS `bft_3` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_1` AS (
SELECT
`L_ORDERKEY` AS `bfcol_2`,
`L_EXTENDEDPRICE` AS `bfcol_3`,
`L_DISCOUNT` AS `bfcol_4`,
`L_RETURNFLAG` AS `bfcol_5`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_2` AS (
SELECT
`O_ORDERKEY` AS `bfcol_6`,
`O_CUSTKEY` AS `bfcol_7`,
`O_ORDERDATE` AS `bfcol_8`
FROM `bigframes-dev`.`tpch`.`ORDERS` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`ORDERS` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_3` AS (
SELECT
`C_CUSTKEY` AS `bfcol_9`,
Expand All @@ -25,7 +25,7 @@ WITH `bfcte_0` AS (
`C_PHONE` AS `bfcol_13`,
`C_ACCTBAL` AS `bfcol_14`,
`C_COMMENT` AS `bfcol_15`
FROM `bigframes-dev`.`tpch`.`CUSTOMER` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`CUSTOMER` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_4` AS (
SELECT
`bfcol_9` AS `bfcol_16`,
Expand Down
8 changes: 4 additions & 4 deletions 8 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/11/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -7,23 +7,23 @@ WITH `bfcte_0` AS (
`PS_SUPPKEY` AS `bfcol_0`,
`PS_AVAILQTY` AS `bfcol_1`,
`PS_SUPPLYCOST` AS `bfcol_2`
FROM `bigframes-dev`.`tpch`.`PARTSUPP` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PARTSUPP` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_2` AS (
SELECT
`PS_PARTKEY` AS `bfcol_10`,
`PS_SUPPKEY` AS `bfcol_11`,
`PS_AVAILQTY` AS `bfcol_12`,
`PS_SUPPLYCOST` AS `bfcol_13`
FROM `bigframes-dev`.`tpch`.`PARTSUPP` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PARTSUPP` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_3` AS (
SELECT
`S_SUPPKEY` AS `bfcol_3`,
`S_NATIONKEY` AS `bfcol_4`
FROM `bigframes-dev`.`tpch`.`SUPPLIER` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`SUPPLIER` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_4` AS (
SELECT
`N_NATIONKEY` AS `bfcol_18`
FROM `bigframes-dev`.`tpch`.`NATION` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`NATION` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
WHERE
`N_NAME` = 'GERMANY'
), `bfcte_5` AS (
Expand Down
4 changes: 2 additions & 2 deletions 4 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/12/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -5,12 +5,12 @@ WITH `bfcte_0` AS (
`L_COMMITDATE` AS `bfcol_2`,
`L_RECEIPTDATE` AS `bfcol_3`,
`L_SHIPMODE` AS `bfcol_4`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_1` AS (
SELECT
`O_ORDERKEY` AS `bfcol_5`,
`O_ORDERPRIORITY` AS `bfcol_6`
FROM `bigframes-dev`.`tpch`.`ORDERS` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`ORDERS` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_2` AS (
SELECT
`bfcol_5`,
Expand Down
4 changes: 2 additions & 2 deletions 4 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/13/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -2,15 +2,15 @@ WITH `bfcte_0` AS (
SELECT
`O_ORDERKEY` AS `bfcol_10`,
`O_CUSTKEY` AS `bfcol_11`
FROM `bigframes-dev`.`tpch`.`ORDERS` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`ORDERS` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
WHERE
NOT (
REGEXP_CONTAINS(`O_COMMENT`, 'special.*requests')
)
), `bfcte_1` AS (
SELECT
`C_CUSTKEY` AS `bfcol_3`
FROM `bigframes-dev`.`tpch`.`CUSTOMER` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`CUSTOMER` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_2` AS (
SELECT
`bfcol_3`,
Expand Down
6 changes: 3 additions & 3 deletions 6 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/14/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -12,16 +12,16 @@ WITH `bfcte_0` AS (
`L_EXTENDEDPRICE` AS `bfcol_1`,
`L_DISCOUNT` AS `bfcol_2`,
`L_SHIPDATE` AS `bfcol_3`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_3` AS (
SELECT
`P_PARTKEY` AS `bfcol_4`
FROM `bigframes-dev`.`tpch`.`PART` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PART` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_4` AS (
SELECT
`P_PARTKEY` AS `bfcol_8`,
`P_TYPE` AS `bfcol_9`
FROM `bigframes-dev`.`tpch`.`PART` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PART` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_5` AS (
SELECT
`bfcol_4`,
Expand Down
6 changes: 3 additions & 3 deletions 6 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/15/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -21,7 +21,7 @@ WITH `bfcte_0` AS (
`L_EXTENDEDPRICE` * (
1 - `L_DISCOUNT`
) AS `bfcol_24`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
WHERE
(
`L_SHIPDATE` >= CAST('1996-01-01' AS DATE)
Expand All @@ -32,14 +32,14 @@ WITH `bfcte_0` AS (
), `bfcte_2` AS (
SELECT
`S_SUPPKEY` AS `bfcol_4`
FROM `bigframes-dev`.`tpch`.`SUPPLIER` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`SUPPLIER` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_3` AS (
SELECT
`S_SUPPKEY` AS `bfcol_8`,
`S_NAME` AS `bfcol_9`,
`S_ADDRESS` AS `bfcol_10`,
`S_PHONE` AS `bfcol_11`
FROM `bigframes-dev`.`tpch`.`SUPPLIER` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`SUPPLIER` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_4` AS (
SELECT
`bfcol_23`,
Expand Down
6 changes: 3 additions & 3 deletions 6 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/16/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -6,7 +6,7 @@ WITH `bfcte_0` AS (
NOT (
REGEXP_CONTAINS(`S_COMMENT`, 'Customer.*Complaints')
) AS `bfcol_9`
FROM `bigframes-dev`.`tpch`.`SUPPLIER` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`SUPPLIER` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
WHERE
NOT (
REGEXP_CONTAINS(`S_COMMENT`, 'Customer.*Complaints')
Expand All @@ -15,14 +15,14 @@ WITH `bfcte_0` AS (
SELECT
`PS_PARTKEY` AS `bfcol_2`,
`PS_SUPPKEY` AS `bfcol_3`
FROM `bigframes-dev`.`tpch`.`PARTSUPP` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PARTSUPP` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_2` AS (
SELECT
`P_PARTKEY` AS `bfcol_4`,
`P_BRAND` AS `bfcol_5`,
`P_TYPE` AS `bfcol_6`,
`P_SIZE` AS `bfcol_7`
FROM `bigframes-dev`.`tpch`.`PART` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PART` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_3` AS (
SELECT
`bfcol_8`
Expand Down
6 changes: 3 additions & 3 deletions 6 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/17/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -5,7 +5,7 @@ WITH `bfcte_0` AS (
), `bfcte_1` AS (
SELECT
`P_PARTKEY` AS `bfcol_15`
FROM `bigframes-dev`.`tpch`.`PART` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PART` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
WHERE
(
`P_BRAND` = 'Brand#23'
Expand All @@ -17,12 +17,12 @@ WITH `bfcte_0` AS (
`L_PARTKEY` AS `bfcol_3`,
`L_QUANTITY` AS `bfcol_4`,
`L_EXTENDEDPRICE` AS `bfcol_5`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_3` AS (
SELECT
`L_PARTKEY` AS `bfcol_6`,
`L_QUANTITY` AS `bfcol_7`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_4` AS (
SELECT
`bfcol_4` AS `bfcol_16`,
Expand Down
6 changes: 3 additions & 3 deletions 6 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/18/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -2,19 +2,19 @@ WITH `bfcte_0` AS (
SELECT
`C_CUSTKEY` AS `bfcol_0`,
`C_NAME` AS `bfcol_1`
FROM `bigframes-dev`.`tpch`.`CUSTOMER` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`CUSTOMER` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_1` AS (
SELECT
`L_ORDERKEY` AS `bfcol_2`,
`L_QUANTITY` AS `bfcol_3`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_2` AS (
SELECT
`O_ORDERKEY` AS `bfcol_4`,
`O_CUSTKEY` AS `bfcol_5`,
`O_TOTALPRICE` AS `bfcol_6`,
`O_ORDERDATE` AS `bfcol_7`
FROM `bigframes-dev`.`tpch`.`ORDERS` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`ORDERS` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_3` AS (
SELECT
`bfcol_2`,
Expand Down
4 changes: 2 additions & 2 deletions 4 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/19/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -10,14 +10,14 @@ WITH `bfcte_0` AS (
`L_DISCOUNT` AS `bfcol_4`,
`L_SHIPINSTRUCT` AS `bfcol_5`,
`L_SHIPMODE` AS `bfcol_6`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_2` AS (
SELECT
`P_PARTKEY` AS `bfcol_7`,
`P_BRAND` AS `bfcol_8`,
`P_SIZE` AS `bfcol_9`,
`P_CONTAINER` AS `bfcol_10`
FROM `bigframes-dev`.`tpch`.`PART` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PART` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_3` AS (
SELECT
`bfcol_7`,
Expand Down
16 changes: 8 additions & 8 deletions 16 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/2/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -2,18 +2,18 @@ WITH `bfcte_0` AS (
SELECT
`R_REGIONKEY` AS `bfcol_0`,
`R_NAME` AS `bfcol_1`
FROM `bigframes-dev`.`tpch`.`REGION` AS `bft_4` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`REGION` AS `bft_4` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_1` AS (
SELECT
`N_NATIONKEY` AS `bfcol_2`,
`N_NAME` AS `bfcol_3`,
`N_REGIONKEY` AS `bfcol_4`
FROM `bigframes-dev`.`tpch`.`NATION` AS `bft_3` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`NATION` AS `bft_3` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_2` AS (
SELECT
`N_NATIONKEY` AS `bfcol_19`,
`N_REGIONKEY` AS `bfcol_20`
FROM `bigframes-dev`.`tpch`.`NATION` AS `bft_3` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`NATION` AS `bft_3` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_3` AS (
SELECT
`S_SUPPKEY` AS `bfcol_5`,
Expand All @@ -23,31 +23,31 @@ WITH `bfcte_0` AS (
`S_PHONE` AS `bfcol_9`,
`S_ACCTBAL` AS `bfcol_10`,
`S_COMMENT` AS `bfcol_11`
FROM `bigframes-dev`.`tpch`.`SUPPLIER` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`SUPPLIER` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_4` AS (
SELECT
`S_SUPPKEY` AS `bfcol_21`,
`S_NATIONKEY` AS `bfcol_22`
FROM `bigframes-dev`.`tpch`.`SUPPLIER` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`SUPPLIER` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_5` AS (
SELECT
`PS_PARTKEY` AS `bfcol_12`,
`PS_SUPPKEY` AS `bfcol_13`,
`PS_SUPPLYCOST` AS `bfcol_14`
FROM `bigframes-dev`.`tpch`.`PARTSUPP` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PARTSUPP` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_6` AS (
SELECT
`P_PARTKEY` AS `bfcol_15`,
`P_MFGR` AS `bfcol_16`,
`P_TYPE` AS `bfcol_17`,
`P_SIZE` AS `bfcol_18`
FROM `bigframes-dev`.`tpch`.`PART` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PART` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_7` AS (
SELECT
`P_PARTKEY` AS `bfcol_23`,
`P_TYPE` AS `bfcol_24`,
`P_SIZE` AS `bfcol_25`
FROM `bigframes-dev`.`tpch`.`PART` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PART` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_8` AS (
SELECT
`bfcol_15` AS `bfcol_26`,
Expand Down
10 changes: 5 additions & 5 deletions 10 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/20/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -4,15 +4,15 @@ WITH `bfcte_0` AS (
`P_NAME`,
`P_PARTKEY` AS `bfcol_15`,
STARTS_WITH(`P_NAME`, 'forest') AS `bfcol_16`
FROM `bigframes-dev`.`tpch`.`PART` AS `bft_4` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PART` AS `bft_4` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
WHERE
STARTS_WITH(`P_NAME`, 'forest')
), `bfcte_1` AS (
SELECT
`PS_PARTKEY` AS `bfcol_2`,
`PS_SUPPKEY` AS `bfcol_3`,
`PS_AVAILQTY` AS `bfcol_4`
FROM `bigframes-dev`.`tpch`.`PARTSUPP` AS `bft_3` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`PARTSUPP` AS `bft_3` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_2` AS (
SELECT
`L_PARTKEY`,
Expand All @@ -28,7 +28,7 @@ WITH `bfcte_0` AS (
AND (
`L_SHIPDATE` < CAST('1995-01-01' AS DATE)
) AS `bfcol_20`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
WHERE
(
`L_SHIPDATE` >= CAST('1994-01-01' AS DATE)
Expand All @@ -39,7 +39,7 @@ WITH `bfcte_0` AS (
), `bfcte_3` AS (
SELECT
`N_NATIONKEY` AS `bfcol_35`
FROM `bigframes-dev`.`tpch`.`NATION` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`NATION` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
WHERE
`N_NAME` = 'CANADA'
), `bfcte_4` AS (
Expand All @@ -48,7 +48,7 @@ WITH `bfcte_0` AS (
`S_NAME` AS `bfcol_12`,
`S_ADDRESS` AS `bfcol_13`,
`S_NATIONKEY` AS `bfcol_14`
FROM `bigframes-dev`.`tpch`.`SUPPLIER` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`SUPPLIER` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_5` AS (
SELECT
`bfcol_15`
Expand Down
12 changes: 6 additions & 6 deletions 12 tests/unit/core/compile/sqlglot/tpch/snapshots/test_tpch/test_tpch_query/21/out.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -2,33 +2,33 @@ WITH `bfcte_0` AS (
SELECT
`O_ORDERKEY` AS `bfcol_0`,
`O_ORDERSTATUS` AS `bfcol_1`
FROM `bigframes-dev`.`tpch`.`ORDERS` AS `bft_3` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`ORDERS` AS `bft_3` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_1` AS (
SELECT
`N_NATIONKEY` AS `bfcol_2`,
`N_NAME` AS `bfcol_3`
FROM `bigframes-dev`.`tpch`.`NATION` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`NATION` AS `bft_2` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_2` AS (
SELECT
`S_SUPPKEY` AS `bfcol_4`,
`S_NAME` AS `bfcol_5`,
`S_NATIONKEY` AS `bfcol_6`
FROM `bigframes-dev`.`tpch`.`SUPPLIER` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`SUPPLIER` AS `bft_1` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_3` AS (
SELECT
`L_ORDERKEY` AS `bfcol_30`,
`L_SUPPKEY` AS `bfcol_31`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
WHERE
`L_RECEIPTDATE` > `L_COMMITDATE`
), `bfcte_4` AS (
SELECT
`L_ORDERKEY`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
), `bfcte_5` AS (
SELECT
`L_ORDERKEY` AS `bfcol_32`
FROM `bigframes-dev`.`tpch`.`LINEITEM` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-10T18:00:00'
FROM `bigframes-dev-perf`.`tpch_0001t`.`LINEITEM` AS `bft_0` FOR SYSTEM_TIME AS OF '2026-03-30T18:00:00'
WHERE
`L_RECEIPTDATE` > `L_COMMITDATE`
), `bfcte_6` AS (
Expand Down
Loading
Loading
Morty Proxy This is a proxified and sanitized view of the page, visit original site.