update ceph source to reef 18.2.1

[ceph.git] / ceph / src / s3select / TPCDS / sample-queries-tpcds / query98.sql

diff --git a/ceph/src/s3select/TPCDS/sample-queries-tpcds/query98.sql b/ceph/src/s3select/TPCDS/sample-queries-tpcds/query98.sql
new file mode 100644 (file)
index 0000000..ef40558
--- /dev/null
+++ b/ceph/src/s3select/TPCDS/sample-queries-tpcds/query98.sql
@@ -0,0 +1,33 @@
+-- start query 1 in stream 0 using template query98.tpl and seed 345591136
+select i_item_id
+      ,i_item_desc 
+      ,i_category 
+      ,i_class 
+      ,i_current_price
+      ,sum(ss_ext_sales_price) as itemrevenue 
+      ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over
+          (partition by i_class) as revenueratio
+from   
+       store_sales
+       ,item 
+       ,date_dim
+where 
+       ss_item_sk = i_item_sk 
+       and i_category in ('Home', 'Sports', 'Men')
+       and ss_sold_date_sk = d_date_sk
+       and d_date between cast('2002-01-05' as date) 
+                               and (cast('2002-01-05' as date) + interval '30' day)
+group by 
+       i_item_id
+        ,i_item_desc 
+        ,i_category
+        ,i_class
+        ,i_current_price
+order by 
+       i_category
+        ,i_class
+        ,i_item_id
+        ,i_item_desc
+        ,revenueratio;
+
+-- end query 1 in stream 0 using template query98.tpl