TPC-Havoc Q11_v9

TPC-Havoc benchmark · all TPC-Havoc queries

Representative SQL

Rendered for DataFusion with default parameters.

WITH inventory_values AS (
  SELECT DISTINCT
    ps_partkey,
    SUM(ps_supplycost * ps_availqty) OVER (PARTITION BY ps_partkey) AS value
  FROM partsupp, supplier, nation
  WHERE
    ps_suppkey = s_suppkey AND s_nationkey = n_nationkey AND n_name = 'GERMANY'
), inventory_threshold AS (
  SELECT
    SUM(ps_supplycost * ps_availqty) * 0.0100000000 AS threshold
  FROM partsupp, supplier, nation
  WHERE
    ps_suppkey = s_suppkey AND s_nationkey = n_nationkey AND n_name = 'GERMANY'
)
SELECT
  ps_partkey,
  value
FROM inventory_values, inventory_threshold
WHERE
  value > threshold
ORDER BY
  value DESC

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 TPCHavoc

bench = TPCHavoc(scale_factor=0.01)            # your scale factor
queries = bench.get_queries(dialect="datafusion")   # your platform's dialect; drop dialect= for native SQL
print(queries['11_v9'])

Source

Query text: benchbox/core/tpchavoc/variant_sets/q11.py