Change "devtools/contrib/piglet/projects/ydblib/config.yaml"

commit_hash:bf8be6eaf53bc3065d37ec3eeb7b664ca9d6b76d

1 files changed, 31 insertions, 0 deletions

diff --git a/yt/yql/tests/sql/suites/pg-tpcds/q32.sql b/yt/yql/tests/sql/suites/pg-tpcds/q32.sql
new file mode 100644
index 0000000000..babfacba04
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg-tpcds/q32.sql
@@ -0,0 +1,31 @@
+--!syntax_pg
+--TPC-DS Q32
+
+-- start query 1 in stream 0 using template ../query_templates/query32.tpl
+select  sum(cs_ext_discount_amt)  as "excess discount amount" 
+from 
+   plato.catalog_sales 
+   ,plato.item 
+   ,plato.date_dim
+where
+i_manufact_id = 269
+and i_item_sk = cs_item_sk 
+and d_date between '1998-03-18'::date and 
+        (cast('1998-03-18' as date) + interval '90' day)::date
+and d_date_sk = cs_sold_date_sk 
+and cs_ext_discount_amt  
+     > ( 
+         select 
+            1.3::numeric * avg(cs_ext_discount_amt) 
+         from 
+            plato.catalog_sales 
+           ,plato.date_dim
+         where 
+              cs_item_sk = i_item_sk 
+          and d_date between '1998-03-18'::date and
+                             (cast('1998-03-18' as date) + interval '90' day)::date
+          and d_date_sk = cs_sold_date_sk 
+      ) 
+limit 100;
+
+-- end query 1 in stream 0 using template ../query_templates/query32.tpl