Skip to content

Write Primitives bulk_load_quoted_fields

Write Primitives benchmark · all Write Primitives queries

Representative SQL

Rendered for DataFusion with default parameters.

TRUNCATE TABLE bulk_load_ops_target;
COPY bulk_load_ops_target
FROM '{file_path}/csv_quoted_fields.csv' WITH (
FORMAT CSV,
HEADER TRUE,
QUOTE '"',
ESCAPE '"'
)

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
queries = bench.get_queries(dialect="datafusion") # your platform's dialect; drop dialect= for native SQL
print(queries['bulk_load_quoted_fields'])

Source

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