update ceph source to reef 18.2.1

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

diff --git a/ceph/src/s3select/TPCDS/sample-queries-tpcds/query1.sql b/ceph/src/s3select/TPCDS/sample-queries-tpcds/query1.sql
new file mode 100644 (file)
index 0000000..c201f73
--- /dev/null
+++ b/ceph/src/s3select/TPCDS/sample-queries-tpcds/query1.sql
@@ -0,0 +1,25 @@
+-- start query 1 in stream 0 using template query1.tpl and seed 2031708268
+with customer_total_return as
+(select sr_customer_sk as ctr_customer_sk
+,sr_store_sk as ctr_store_sk
+,sum(SR_FEE) as ctr_total_return
+from store_returns
+,date_dim
+where sr_returned_date_sk = d_date_sk
+and d_year =2000
+group by sr_customer_sk
+,sr_store_sk)
+ select  c_customer_id
+from customer_total_return ctr1
+,store
+,customer
+where ctr1.ctr_total_return > (select avg(ctr_total_return)*1.2
+from customer_total_return ctr2
+where ctr1.ctr_store_sk = ctr2.ctr_store_sk)
+and s_store_sk = ctr1.ctr_store_sk
+and s_state = 'NM'
+and ctr1.ctr_customer_sk = c_customer_sk
+order by c_customer_id
+limit 100;
+
+-- end query 1 in stream 0 using template query1.tpl