Write Primitives insert_batch_values_10

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
VALUES
  (
    9000010,
    1,
    1,
    1,
    10.0,
    1000.0,
    0.05,
    0.02,
    'N',
    'O',
    CAST('1998-01-01' AS DATE),
    CAST('1998-01-15' AS DATE),
    CAST('1998-01-20' AS DATE),
    'DELIVER IN PERSON',
    'TRUCK',
    'batch 1'
  ),
  (
    9000011,
    2,
    2,
    1,
    20.0,
    2000.0,
    0.05,
    0.02,
    'N',
    'O',
    CAST('1998-01-01' AS DATE),
    CAST('1998-01-15' AS DATE),
    CAST('1998-01-20' AS DATE),
    'DELIVER IN PERSON',
    'TRUCK',
    'batch 2'
  ),
  (
    9000012,
    3,
    3,
    1,
    30.0,
    3000.0,
    0.05,
    0.02,
    'N',
    'O',
    CAST('1998-01-01' AS DATE),
    CAST('1998-01-15' AS DATE),
    CAST('1998-01-20' AS DATE),
    'DELIVER IN PERSON',
    'TRUCK',
    'batch 3'
  ),
  (
    9000013,
    4,
    4,
    1,
    40.0,
    4000.0,
    0.05,
    0.02,
    'N',
    'O',
    CAST('1998-01-01' AS DATE),
    CAST('1998-01-15' AS DATE),
    CAST('1998-01-20' AS DATE),
    'DELIVER IN PERSON',
    'TRUCK',
    'batch 4'
  ),
  (
    9000014,
    5,
    5,
    1,
    50.0,
    5000.0,
    0.05,
    0.02,
    'N',
    'O',
    CAST('1998-01-01' AS DATE),
    CAST('1998-01-15' AS DATE),
    CAST('1998-01-20' AS DATE),
    'DELIVER IN PERSON',
    'TRUCK',
    'batch 5'
  ),
  (
    9000015,
    6,
    6,
    1,
    60.0,
    6000.0,
    0.05,
    0.02,
    'N',
    'O',
    CAST('1998-01-01' AS DATE),
    CAST('1998-01-15' AS DATE),
    CAST('1998-01-20' AS DATE),
    'DELIVER IN PERSON',
    'TRUCK',
    'batch 6'
  ),
  (
    9000016,
    7,
    7,
    1,
    70.0,
    7000.0,
    0.05,
    0.02,
    'N',
    'O',
    CAST('1998-01-01' AS DATE),
    CAST('1998-01-15' AS DATE),
    CAST('1998-01-20' AS DATE),
    'DELIVER IN PERSON',
    'TRUCK',
    'batch 7'
  ),
  (
    9000017,
    8,
    8,
    1,
    80.0,
    8000.0,
    0.05,
    0.02,
    'N',
    'O',
    CAST('1998-01-01' AS DATE),
    CAST('1998-01-15' AS DATE),
    CAST('1998-01-20' AS DATE),
    'DELIVER IN PERSON',
    'TRUCK',
    'batch 8'
  ),
  (
    9000018,
    9,
    9,
    1,
    90.0,
    9000.0,
    0.05,
    0.02,
    'N',
    'O',
    CAST('1998-01-01' AS DATE),
    CAST('1998-01-15' AS DATE),
    CAST('1998-01-20' AS DATE),
    'DELIVER IN PERSON',
    'TRUCK',
    'batch 9'
  ),
  (
    9000019,
    10,
    10,
    1,
    100.0,
    10000.0,
    0.05,
    0.02,
    'N',
    'O',
    CAST('1998-01-01' AS DATE),
    CAST('1998-01-15' AS DATE),
    CAST('1998-01-20' AS DATE),
    'DELIVER IN PERSON',
    'TRUCK',
    'batch 10'
  )

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_batch_values_10'])

Source

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