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

commit_hash:bf8be6eaf53bc3065d37ec3eeb7b664ca9d6b76d

1 files changed, 26 insertions, 0 deletions

diff --git a/yt/yql/tests/sql/suites/pg-tpch/q04.sql b/yt/yql/tests/sql/suites/pg-tpch/q04.sql
new file mode 100644
index 0000000000..40718918ee
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg-tpch/q04.sql
@@ -0,0 +1,26 @@
+--!syntax_pg
+--ignore runonopt plan diff
+--TPC-H Q4
+
+
+select
+o_orderpriority, 
+count(*) as order_count
+from 
+plato."orders"
+where 
+o_orderdate >= date '1993-07-01'
+and o_orderdate < date '1993-07-01' + interval '3' month
+and exists (
+select 
+*
+from 
+plato."lineitem"
+where 
+l_orderkey = o_orderkey
+and l_commitdate < l_receiptdate
+)
+group by 
+o_orderpriority
+order by 
+o_orderpriority;