TPC-DS-OBT Q12
TPC-DS-OBT benchmark · all TPC-DS-OBT queries
Representative SQL
Rendered for DataFusion with default parameters.
SELECT obt.item_i_item_id, obt.item_i_item_desc, obt.item_i_category, obt.item_i_class, obt.item_i_current_price, SUM(obt.ext_sales_price) AS itemrevenue, CAST(SUM(obt.ext_sales_price) * 100 AS DOUBLE PRECISION) / SUM(SUM(obt.ext_sales_price)) OVER (PARTITION BY obt.item_i_class) AS revenueratioFROM tpcds_sales_returns_obt AS obtWHERE ( obt.item_sk = obt.item_i_item_sk AND obt.item_i_category IN ('Jewelry', 'Sports', 'Books') AND obt.sold_date_sk = obt.sold_date_d_date_sk AND obt.sold_date_d_date BETWEEN CAST('2001-01-12' AS DATE) AND ( CAST('2001-01-12' AS DATE) + INTERVAL '30 DAY' ) ) AND channel = 'web'GROUP BY obt.item_i_item_id, obt.item_i_item_desc, obt.item_i_category, obt.item_i_class, obt.item_i_current_priceORDER BY obt.item_i_category, obt.item_i_class, obt.item_i_item_id, obt.item_i_item_desc, revenueratioLIMIT 100Representative 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 TPCDSOBT
bench = TPCDSOBT(scale_factor=1.0) # your scale factorqueries = bench.get_queries(dialect="datafusion") # your platform's dialect; drop dialect= for native SQLprint(queries['12'])Source
Query text: benchbox/core/tpcds_obt/queries.py