diff options
Diffstat (limited to 'exec/java-exec/src/test/resources/queries/tpch/04.sql')
| -rw-r--r-- | exec/java-exec/src/test/resources/queries/tpch/04.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/exec/java-exec/src/test/resources/queries/tpch/04.sql b/exec/java-exec/src/test/resources/queries/tpch/04.sql new file mode 100644 index 000000000..3c5957209 --- /dev/null +++ b/exec/java-exec/src/test/resources/queries/tpch/04.sql @@ -0,0 +1,24 @@ +-- tpch4 using 1395599672 as a seed to the RNG
+select
+ o_orderpriority,
+ count(*) as order_count
+from
+ cp.`tpch/orders.parquet`
+
+where
+-- o_orderdate >= date '1996-10-01'
+-- and o_orderdate < date '1996-10-01' + interval '3' month
+-- and
+ exists (
+ select
+ *
+ from
+ cp.`tpch/lineitem.parquet`
+ where
+ l_orderkey = o_orderkey
+ and l_commitdate < l_receiptdate
+ )
+group by
+ o_orderpriority
+order by
+ o_orderpriority;
|