diff options
Diffstat (limited to 'src/s3select/TPCDS/sample-queries-tpcds/query22.sql')
| -rw-r--r-- | src/s3select/TPCDS/sample-queries-tpcds/query22.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/src/s3select/TPCDS/sample-queries-tpcds/query22.sql b/src/s3select/TPCDS/sample-queries-tpcds/query22.sql new file mode 100644 index 000000000..07c4869a4 --- /dev/null +++ b/src/s3select/TPCDS/sample-queries-tpcds/query22.sql @@ -0,0 +1,20 @@ +-- start query 1 in stream 0 using template query22.tpl and seed 1819994127 +select i_product_name + ,i_brand + ,i_class + ,i_category + ,avg(inv_quantity_on_hand) qoh + from inventory + ,date_dim + ,item + where inv_date_sk=d_date_sk + and inv_item_sk=i_item_sk + and d_month_seq between 1186 and 1186 + 11 + group by rollup(i_product_name + ,i_brand + ,i_class + ,i_category) +order by qoh, i_product_name, i_brand, i_class, i_category +limit 100; + +-- end query 1 in stream 0 using template query22.tpl |