Write Primitives merge_with_join_condition

Write Primitives benchmark · all Write Primitives queries

Representative SQL

Rendered in the benchmark’s native SQL with default parameters (no dialect translation available).

MERGE INTO merge_ops_lineitem_target AS target
USING (
  SELECT
    l.*,
    o.o_custkey
  FROM lineitem AS l
  JOIN orders AS o
    ON l.l_orderkey = o.o_orderkey
  WHERE
    l.l_orderkey BETWEEN 1 AND 10
) AS source
ON target.l_orderkey = source.l_orderkey
AND target.l_linenumber = source.l_linenumber
WHEN MATCHED THEN UPDATE SET
  l_comment = 'merge_multi_key'
WHEN NOT MATCHED THEN INSERT VALUES (
  source.l_orderkey,
  source.l_partkey,
  source.l_suppkey,
  source.l_linenumber,
  source.l_quantity,
  source.l_extendedprice,
  source.l_discount,
  source.l_tax,
  source.l_returnflag,
  source.l_linestatus,
  source.l_shipdate,
  source.l_commitdate,
  source.l_receiptdate,
  source.l_shipinstruct,
  source.l_shipmode,
  source.l_comment
)

Representative DataFrame

No DataFrame implementation is registered for this query.

Get the exact query for your run

The blocks above are representative. To get the precise statement a specific platform runs at a specific scale, substitute your own values:

from benchbox import WritePrimitives

bench = WritePrimitives(scale_factor=0.01)            # your scale factor
print(bench.get_queries()['merge_with_join_condition'])

Source

Query text: benchbox/core/write_primitives/operations.py