drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From s..@apache.org
Subject [1/2] drill git commit: DRILL-3268: queries with empty OVER() clause return empty result set
Date Thu, 18 Jun 2015 20:13:00 GMT
Repository: drill
Updated Branches:
  refs/heads/master 437706f75 -> a027f692b


http://git-wip-us.apache.org/repos/asf/drill/blob/a027f692/exec/java-exec/src/test/resources/window/b4.p4.pby.tsv
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b4.p4.pby.tsv b/exec/java-exec/src/test/resources/window/b4.p4.pby.tsv
new file mode 100644
index 0000000..b2bd5e1
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b4.p4.pby.tsv
@@ -0,0 +1,80 @@
+10	126
+10	126
+10	126
+10	126
+10	126
+10	126
+10	126
+10	126
+10	126
+10	126
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+30	490
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	391
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429
+20	429

http://git-wip-us.apache.org/repos/asf/drill/blob/a027f692/exec/java-exec/src/test/resources/window/b4.p4.subs.tsv
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b4.p4.subs.tsv b/exec/java-exec/src/test/resources/window/b4.p4.subs.tsv
deleted file mode 100644
index c13597b..0000000
--- a/exec/java-exec/src/test/resources/window/b4.p4.subs.tsv
+++ /dev/null
@@ -1,80 +0,0 @@
-1	11	1	1	1	0.1	0.0
-3	35	2	2	2	0.3	0.1111111111111111
-3	35	3	2	2	0.3	0.1111111111111111
-10	126	4	4	3	1.0	0.3333333333333333
-10	126	5	4	3	1.0	0.3333333333333333
-10	126	6	4	3	1.0	0.3333333333333333
-10	126	7	4	3	1.0	0.3333333333333333
-10	126	8	4	3	1.0	0.3333333333333333
-10	126	9	4	3	1.0	0.3333333333333333
-10	126	10	4	3	1.0	0.3333333333333333
-3	39	1	1	1	0.1	0.0
-3	39	2	1	1	0.1	0.0
-3	39	3	1	1	0.1	0.0
-7	95	4	4	2	0.23333333333333334	0.10344827586206896
-7	95	5	4	2	0.23333333333333334	0.10344827586206896
-7	95	6	4	2	0.23333333333333334	0.10344827586206896
-7	95	7	4	2	0.23333333333333334	0.10344827586206896
-12	170	8	8	3	0.4	0.2413793103448276
-12	170	9	8	3	0.4	0.2413793103448276
-12	170	10	8	3	0.4	0.2413793103448276
-12	170	11	8	3	0.4	0.2413793103448276
-12	170	12	8	3	0.4	0.2413793103448276
-18	266	13	13	4	0.6	0.41379310344827586
-18	266	14	13	4	0.6	0.41379310344827586
-18	266	15	13	4	0.6	0.41379310344827586
-18	266	16	13	4	0.6	0.41379310344827586
-18	266	17	13	4	0.6	0.41379310344827586
-18	266	18	13	4	0.6	0.41379310344827586
-25	385	19	19	5	0.8333333333333334	0.6206896551724138
-25	385	20	19	5	0.8333333333333334	0.6206896551724138
-25	385	21	19	5	0.8333333333333334	0.6206896551724138
-25	385	22	19	5	0.8333333333333334	0.6206896551724138
-25	385	23	19	5	0.8333333333333334	0.6206896551724138
-25	385	24	19	5	0.8333333333333334	0.6206896551724138
-25	385	25	19	5	0.8333333333333334	0.6206896551724138
-30	475	26	26	6	1.0	0.8620689655172413
-30	475	27	26	6	1.0	0.8620689655172413
-30	475	28	26	6	1.0	0.8620689655172413
-30	475	29	26	6	1.0	0.8620689655172413
-30	475	30	26	6	1.0	0.8620689655172413
-8	144	1	1	1	0.4	0.0
-8	144	2	1	1	0.4	0.0
-8	144	3	1	1	0.4	0.0
-8	144	4	1	1	0.4	0.0
-8	144	5	1	1	0.4	0.0
-8	144	6	1	1	0.4	0.0
-8	144	7	1	1	0.4	0.0
-8	144	8	1	1	0.4	0.0
-17	315	9	9	2	0.85	0.42105263157894735
-17	315	10	9	2	0.85	0.42105263157894735
-17	315	11	9	2	0.85	0.42105263157894735
-17	315	12	9	2	0.85	0.42105263157894735
-17	315	13	9	2	0.85	0.42105263157894735
-17	315	14	9	2	0.85	0.42105263157894735
-17	315	15	9	2	0.85	0.42105263157894735
-17	315	16	9	2	0.85	0.42105263157894735
-17	315	17	9	2	0.85	0.42105263157894735
-20	375	18	18	3	1.0	0.8947368421052632
-20	375	19	18	3	1.0	0.8947368421052632
-20	375	20	18	3	1.0	0.8947368421052632
-10	200	1	1	1	0.5	0.0
-10	200	2	1	1	0.5	0.0
-10	200	3	1	1	0.5	0.0
-10	200	4	1	1	0.5	0.0
-10	200	5	1	1	0.5	0.0
-10	200	6	1	1	0.5	0.0
-10	200	7	1	1	0.5	0.0
-10	200	8	1	1	0.5	0.0
-10	200	9	1	1	0.5	0.0
-10	200	10	1	1	0.5	0.0
-20	410	11	11	2	1.0	0.5263157894736842
-20	410	12	11	2	1.0	0.5263157894736842
-20	410	13	11	2	1.0	0.5263157894736842
-20	410	14	11	2	1.0	0.5263157894736842
-20	410	15	11	2	1.0	0.5263157894736842
-20	410	16	11	2	1.0	0.5263157894736842
-20	410	17	11	2	1.0	0.5263157894736842
-20	410	18	11	2	1.0	0.5263157894736842
-20	410	19	11	2	1.0	0.5263157894736842
-20	410	20	11	2	1.0	0.5263157894736842

http://git-wip-us.apache.org/repos/asf/drill/blob/a027f692/exec/java-exec/src/test/resources/window/b4.p4.tsv
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b4.p4.tsv b/exec/java-exec/src/test/resources/window/b4.p4.tsv
index 29c57ae..1731fe9 100644
--- a/exec/java-exec/src/test/resources/window/b4.p4.tsv
+++ b/exec/java-exec/src/test/resources/window/b4.p4.tsv
@@ -1,80 +1,80 @@
-10	126
-10	126
-10	126
-10	126
-10	126
-10	126
-10	126
-10	126
-10	126
-10	126
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-30	475
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	375
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
-20	410
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436
+80	1436

http://git-wip-us.apache.org/repos/asf/drill/blob/a027f692/exec/java-exec/src/test/resources/window/b4.p4/0.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b4.p4/0.data.json b/exec/java-exec/src/test/resources/window/b4.p4/0.data.json
index c40697c..e91a75c 100644
--- a/exec/java-exec/src/test/resources/window/b4.p4/0.data.json
+++ b/exec/java-exec/src/test/resources/window/b4.p4/0.data.json
@@ -1,24 +1,24 @@
 // partition rows 10, subs [1, 2, 3]
-// partition rows 30, subs [3, 4, 5, 6, 7, 8]
-// partition rows 20, subs [8, 9, 10]
-// partition rows 20, subs [10, 11]
-{ "employee_id":37, "position_id":2, "sub":8, "salary":18 }
-{ "employee_id":52, "position_id":3, "sub":9, "salary":19 }
-{ "employee_id":16, "position_id":2, "sub":4, "salary":14 }
-{ "employee_id":20, "position_id":2, "sub":5, "salary":15 }
-{ "employee_id":5, "position_id":1, "sub":3, "salary":13 }
-{ "employee_id":45, "position_id":3, "sub":8, "salary":18 }
-{ "employee_id":40, "position_id":3, "sub":8, "salary":18 }
-{ "employee_id":1, "position_id":1, "sub":2, "salary":12 }
-{ "employee_id":48, "position_id":3, "sub":9, "salary":19 }
-{ "employee_id":13, "position_id":2, "sub":4, "salary":14 }
+// partition rows 30, subs [4, 5, 6, 7, 8]
+// partition rows 20, subs [9, 10]
+// partition rows 20, subs [11, 12]
+{ "employee_id":10, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":0, "position_id":1, "sub":1, "salary":11 }
+{ "employee_id":61, "position_id":4, "sub":11, "salary":21 }
 { "employee_id":70, "position_id":4, "sub":11, "salary":21 }
-{ "employee_id":47, "position_id":3, "sub":8, "salary":18 }
-{ "employee_id":24, "position_id":2, "sub":6, "salary":16 }
-{ "employee_id":8, "position_id":1, "sub":3, "salary":13 }
-{ "employee_id":63, "position_id":4, "sub":10, "salary":20 }
-{ "employee_id":32, "position_id":2, "sub":7, "salary":17 }
-{ "employee_id":58, "position_id":3, "sub":10, "salary":20 }
-{ "employee_id":10, "position_id":2, "sub":3, "salary":13 }
+{ "employee_id":20, "position_id":2, "sub":6, "salary":16 }
 { "employee_id":22, "position_id":2, "sub":6, "salary":16 }
-{ "employee_id":61, "position_id":4, "sub":10, "salary":20 }
+{ "employee_id":49, "position_id":3, "sub":10, "salary":20 }
+{ "employee_id":34, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":8, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":24, "position_id":2, "sub":6, "salary":16 }
+{ "employee_id":38, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":29, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":23, "position_id":2, "sub":6, "salary":16 }
+{ "employee_id":2, "position_id":1, "sub":2, "salary":12 }
+{ "employee_id":56, "position_id":3, "sub":10, "salary":20 }
+{ "employee_id":9, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":26, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":1, "position_id":1, "sub":2, "salary":12 }
+{ "employee_id":27, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":39, "position_id":2, "sub":8, "salary":18 }

http://git-wip-us.apache.org/repos/asf/drill/blob/a027f692/exec/java-exec/src/test/resources/window/b4.p4/1.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b4.p4/1.data.json b/exec/java-exec/src/test/resources/window/b4.p4/1.data.json
index 472c9b5..52f375b 100644
--- a/exec/java-exec/src/test/resources/window/b4.p4/1.data.json
+++ b/exec/java-exec/src/test/resources/window/b4.p4/1.data.json
@@ -1,20 +1,20 @@
-{ "employee_id":74, "position_id":4, "sub":11, "salary":21 }
-{ "employee_id":6, "position_id":1, "sub":3, "salary":13 }
-{ "employee_id":15, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":5, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":52, "position_id":3, "sub":10, "salary":20 }
+{ "employee_id":50, "position_id":3, "sub":10, "salary":20 }
 { "employee_id":36, "position_id":2, "sub":8, "salary":18 }
-{ "employee_id":34, "position_id":2, "sub":7, "salary":17 }
-{ "employee_id":41, "position_id":3, "sub":8, "salary":18 }
-{ "employee_id":14, "position_id":2, "sub":4, "salary":14 }
-{ "employee_id":75, "position_id":4, "sub":11, "salary":21 }
-{ "employee_id":53, "position_id":3, "sub":9, "salary":19 }
-{ "employee_id":0, "position_id":1, "sub":1, "salary":11 }
-{ "employee_id":7, "position_id":1, "sub":3, "salary":13 }
-{ "employee_id":23, "position_id":2, "sub":6, "salary":16 }
-{ "employee_id":60, "position_id":4, "sub":10, "salary":20 }
-{ "employee_id":55, "position_id":3, "sub":9, "salary":19 }
-{ "employee_id":46, "position_id":3, "sub":8, "salary":18 }
-{ "employee_id":65, "position_id":4, "sub":10, "salary":20 }
+{ "employee_id":76, "position_id":4, "sub":12, "salary":22 }
+{ "employee_id":54, "position_id":3, "sub":10, "salary":20 }
+{ "employee_id":79, "position_id":4, "sub":12, "salary":22 }
+{ "employee_id":33, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":15, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":30, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":72, "position_id":4, "sub":12, "salary":22 }
+{ "employee_id":64, "position_id":4, "sub":11, "salary":21 }
+{ "employee_id":74, "position_id":4, "sub":12, "salary":22 }
+{ "employee_id":73, "position_id":4, "sub":12, "salary":22 }
+{ "employee_id":47, "position_id":3, "sub":9, "salary":19 }
 { "employee_id":3, "position_id":1, "sub":3, "salary":13 }
-{ "employee_id":59, "position_id":3, "sub":10, "salary":20 }
-{ "employee_id":35, "position_id":2, "sub":8, "salary":18 }
-{ "employee_id":69, "position_id":4, "sub":10, "salary":20 }
+{ "employee_id":44, "position_id":3, "sub":9, "salary":19 }
+{ "employee_id":11, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":69, "position_id":4, "sub":11, "salary":21 }
+{ "employee_id":48, "position_id":3, "sub":9, "salary":19 }

http://git-wip-us.apache.org/repos/asf/drill/blob/a027f692/exec/java-exec/src/test/resources/window/b4.p4/2.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b4.p4/2.data.json b/exec/java-exec/src/test/resources/window/b4.p4/2.data.json
index 292200c..9ecc5ed 100644
--- a/exec/java-exec/src/test/resources/window/b4.p4/2.data.json
+++ b/exec/java-exec/src/test/resources/window/b4.p4/2.data.json
@@ -1,20 +1,20 @@
-{ "employee_id":9, "position_id":1, "sub":3, "salary":13 }
-{ "employee_id":38, "position_id":2, "sub":8, "salary":18 }
-{ "employee_id":11, "position_id":2, "sub":3, "salary":13 }
-{ "employee_id":42, "position_id":3, "sub":8, "salary":18 }
-{ "employee_id":78, "position_id":4, "sub":11, "salary":21 }
-{ "employee_id":77, "position_id":4, "sub":11, "salary":21 }
-{ "employee_id":21, "position_id":2, "sub":5, "salary":15 }
-{ "employee_id":49, "position_id":3, "sub":9, "salary":19 }
-{ "employee_id":57, "position_id":3, "sub":10, "salary":20 }
-{ "employee_id":66, "position_id":4, "sub":10, "salary":20 }
-{ "employee_id":4, "position_id":1, "sub":3, "salary":13 }
-{ "employee_id":73, "position_id":4, "sub":11, "salary":21 }
+{ "employee_id":68, "position_id":4, "sub":11, "salary":21 }
+{ "employee_id":6, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":42, "position_id":3, "sub":9, "salary":19 }
+{ "employee_id":53, "position_id":3, "sub":10, "salary":20 }
+{ "employee_id":46, "position_id":3, "sub":9, "salary":19 }
+{ "employee_id":58, "position_id":3, "sub":10, "salary":20 }
+{ "employee_id":71, "position_id":4, "sub":12, "salary":22 }
+{ "employee_id":21, "position_id":2, "sub":6, "salary":16 }
+{ "employee_id":59, "position_id":3, "sub":10, "salary":20 }
+{ "employee_id":16, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":41, "position_id":3, "sub":9, "salary":19 }
+{ "employee_id":14, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":25, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":60, "position_id":4, "sub":11, "salary":21 }
+{ "employee_id":7, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":55, "position_id":3, "sub":10, "salary":20 }
+{ "employee_id":75, "position_id":4, "sub":12, "salary":22 }
 { "employee_id":28, "position_id":2, "sub":7, "salary":17 }
-{ "employee_id":71, "position_id":4, "sub":11, "salary":21 }
-{ "employee_id":31, "position_id":2, "sub":7, "salary":17 }
-{ "employee_id":2, "position_id":1, "sub":2, "salary":12 }
-{ "employee_id":26, "position_id":2, "sub":6, "salary":16 }
-{ "employee_id":68, "position_id":4, "sub":10, "salary":20 }
-{ "employee_id":64, "position_id":4, "sub":10, "salary":20 }
-{ "employee_id":25, "position_id":2, "sub":6, "salary":16 }
+{ "employee_id":4, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":67, "position_id":4, "sub":11, "salary":21 }

http://git-wip-us.apache.org/repos/asf/drill/blob/a027f692/exec/java-exec/src/test/resources/window/b4.p4/3.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b4.p4/3.data.json b/exec/java-exec/src/test/resources/window/b4.p4/3.data.json
index cd9008c..32d2ad1 100644
--- a/exec/java-exec/src/test/resources/window/b4.p4/3.data.json
+++ b/exec/java-exec/src/test/resources/window/b4.p4/3.data.json
@@ -1,20 +1,20 @@
-{ "employee_id":33, "position_id":2, "sub":7, "salary":17 }
-{ "employee_id":44, "position_id":3, "sub":8, "salary":18 }
-{ "employee_id":50, "position_id":3, "sub":9, "salary":19 }
-{ "employee_id":67, "position_id":4, "sub":10, "salary":20 }
-{ "employee_id":79, "position_id":4, "sub":11, "salary":21 }
 { "employee_id":17, "position_id":2, "sub":5, "salary":15 }
-{ "employee_id":54, "position_id":3, "sub":9, "salary":19 }
-{ "employee_id":51, "position_id":3, "sub":9, "salary":19 }
-{ "employee_id":62, "position_id":4, "sub":10, "salary":20 }
-{ "employee_id":56, "position_id":3, "sub":9, "salary":19 }
-{ "employee_id":43, "position_id":3, "sub":8, "salary":18 }
-{ "employee_id":12, "position_id":2, "sub":3, "salary":13 }
-{ "employee_id":19, "position_id":2, "sub":5, "salary":15 }
-{ "employee_id":29, "position_id":2, "sub":7, "salary":17 }
-{ "employee_id":39, "position_id":2, "sub":8, "salary":18 }
-{ "employee_id":30, "position_id":2, "sub":7, "salary":17 }
-{ "employee_id":27, "position_id":2, "sub":6, "salary":16 }
-{ "employee_id":72, "position_id":4, "sub":11, "salary":21 }
-{ "employee_id":76, "position_id":4, "sub":11, "salary":21 }
 { "employee_id":18, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":35, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":37, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":45, "position_id":3, "sub":9, "salary":19 }
+{ "employee_id":65, "position_id":4, "sub":11, "salary":21 }
+{ "employee_id":31, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":40, "position_id":3, "sub":9, "salary":19 }
+{ "employee_id":63, "position_id":4, "sub":11, "salary":21 }
+{ "employee_id":43, "position_id":3, "sub":9, "salary":19 }
+{ "employee_id":19, "position_id":2, "sub":6, "salary":16 }
+{ "employee_id":51, "position_id":3, "sub":10, "salary":20 }
+{ "employee_id":12, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":32, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":66, "position_id":4, "sub":11, "salary":21 }
+{ "employee_id":13, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":78, "position_id":4, "sub":12, "salary":22 }
+{ "employee_id":62, "position_id":4, "sub":11, "salary":21 }
+{ "employee_id":57, "position_id":3, "sub":10, "salary":20 }
+{ "employee_id":77, "position_id":4, "sub":12, "salary":22 }

http://git-wip-us.apache.org/repos/asf/drill/blob/a027f692/exec/java-exec/src/test/resources/window/q1.sql
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/q1.sql b/exec/java-exec/src/test/resources/window/q1.sql
index 053b701..401ee97 100644
--- a/exec/java-exec/src/test/resources/window/q1.sql
+++ b/exec/java-exec/src/test/resources/window/q1.sql
@@ -3,4 +3,4 @@ select
   sum(salary) over pos_win `sum`
 from
   dfs_test.`%s/window/%s`
-window pos_win as (partition by position_id)
\ No newline at end of file
+window pos_win as %s
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/a027f692/exec/java-exec/src/test/resources/window/q2.sql
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/q2.sql b/exec/java-exec/src/test/resources/window/q2.sql
index 0e661a7..beae8e0 100644
--- a/exec/java-exec/src/test/resources/window/q2.sql
+++ b/exec/java-exec/src/test/resources/window/q2.sql
@@ -7,4 +7,4 @@ select
   cume_dist() over pos_win `cume_dist`,
   percent_rank() over pos_win `percent_rank`
 from dfs_test.`%s/window/%s`
-window pos_win as (partition by position_id order by sub)
\ No newline at end of file
+window pos_win as %s
\ No newline at end of file


Mime
View raw message