Write Primitives merge_error_handling
Write Primitives benchmark · all Write Primitives queries
Representative SQL
Rendered for DataFusion with default parameters.
MERGE INTO merge_ops_target AS targetUSING ( SELECT * FROM orders WHERE o_orderkey BETWEEN 1 AND 50 UNION ALL SELECT * FROM orders WHERE o_orderkey BETWEEN 45 AND 55) AS sourceON target.o_orderkey = source.o_orderkeyWHEN MATCHED THEN UPDATE SET o_comment = 'merge_with_dups'WHEN NOT MATCHED THEN INSERTRepresentative 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 factorqueries = bench.get_queries(dialect="datafusion") # your platform's dialect; drop dialect= for native SQLprint(queries['merge_error_handling'])Source
Query text: benchbox/core/write_primitives/operations.py