Write Primitives insert_select_from_multiple

Write Primitives benchmark · all Write Primitives queries

Representative SQL

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

INSERT INTO insert_ops_lineitem_enriched (
  l_orderkey,
  l_partkey,
  l_suppkey,
  l_quantity,
  l_extendedprice,
  o_orderdate,
  c_name,
  s_name,
  p_name
)
SELECT
  l.l_orderkey,
  l.l_partkey,
  l.l_suppkey,
  l.l_quantity,
  l.l_extendedprice,
  o.o_orderdate,
  c.c_name,
  s.s_name,
  p.p_name
FROM lineitem AS l
JOIN orders AS o
  ON l.l_orderkey = o.o_orderkey
JOIN customer AS c
  ON o.o_custkey = c.c_custkey
JOIN supplier AS s
  ON l.l_suppkey = s.s_suppkey
JOIN part AS p
  ON l.l_partkey = p.p_partkey
WHERE
  l.l_orderkey BETWEEN 1 AND 50

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()['insert_select_from_multiple'])

Source

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