drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From j..@apache.org
Subject [1/2] drill git commit: DRILL-3200: Add Window functions: ROW_NUMBER, RANK, PERCENT_RANK, DENSE_RANK and CUME_DIST
Date Thu, 11 Jun 2015 18:30:51 GMT
Repository: drill
Updated Branches:
  refs/heads/master 453f6f7a8 -> 3bccec911


http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b1.p1/0.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b1.p1/0.data.json b/exec/java-exec/src/test/resources/window/b1.p1/0.data.json
new file mode 100644
index 0000000..cd34641
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b1.p1/0.data.json
@@ -0,0 +1,21 @@
+// partition rows 20, subs [1, 2, 3, 4, 5, 6]
+{ "employee_id":8, "position_id":1, "sub":4, "salary":14 }
+{ "employee_id":7, "position_id":1, "sub":4, "salary":14 }
+{ "employee_id":14, "position_id":1, "sub":5, "salary":15 }
+{ "employee_id":18, "position_id":1, "sub":6, "salary":16 }
+{ "employee_id":4, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":5, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":16, "position_id":1, "sub":6, "salary":16 }
+{ "employee_id":19, "position_id":1, "sub":6, "salary":16 }
+{ "employee_id":0, "position_id":1, "sub":1, "salary":11 }
+{ "employee_id":17, "position_id":1, "sub":6, "salary":16 }
+{ "employee_id":12, "position_id":1, "sub":5, "salary":15 }
+{ "employee_id":2, "position_id":1, "sub":2, "salary":12 }
+{ "employee_id":11, "position_id":1, "sub":5, "salary":15 }
+{ "employee_id":6, "position_id":1, "sub":4, "salary":14 }
+{ "employee_id":13, "position_id":1, "sub":5, "salary":15 }
+{ "employee_id":9, "position_id":1, "sub":4, "salary":14 }
+{ "employee_id":15, "position_id":1, "sub":6, "salary":16 }
+{ "employee_id":10, "position_id":1, "sub":5, "salary":15 }
+{ "employee_id":3, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":1, "position_id":1, "sub":2, "salary":12 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b1.p2.subs.tsv
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b1.p2.subs.tsv b/exec/java-exec/src/test/resources/window/b1.p2.subs.tsv
new file mode 100644
index 0000000..edc4b6a
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b1.p2.subs.tsv
@@ -0,0 +1,20 @@
+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
+6	74	4	4	3	0.6	0.3333333333333333
+6	74	5	4	3	0.6	0.3333333333333333
+6	74	6	4	3	0.6	0.3333333333333333
+10	130	7	7	4	1.0	0.6666666666666666
+10	130	8	7	4	1.0	0.6666666666666666
+10	130	9	7	4	1.0	0.6666666666666666
+10	130	10	7	4	1.0	0.6666666666666666
+4	56	1	1	1	0.4	0.0
+4	56	2	1	1	0.4	0.0
+4	56	3	1	1	0.4	0.0
+4	56	4	1	1	0.4	0.0
+9	131	5	5	2	0.9	0.4444444444444444
+9	131	6	5	2	0.9	0.4444444444444444
+9	131	7	5	2	0.9	0.4444444444444444
+9	131	8	5	2	0.9	0.4444444444444444
+9	131	9	5	2	0.9	0.4444444444444444
+10	147	10	10	3	1.0	1.0

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b1.p2.tsv
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b1.p2.tsv b/exec/java-exec/src/test/resources/window/b1.p2.tsv
new file mode 100644
index 0000000..2bd0010
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b1.p2.tsv
@@ -0,0 +1,20 @@
+10	130
+10	130
+10	130
+10	130
+10	130
+10	130
+10	130
+10	130
+10	130
+10	130
+10	147
+10	147
+10	147
+10	147
+10	147
+10	147
+10	147
+10	147
+10	147
+10	147

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b1.p2/0.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b1.p2/0.data.json b/exec/java-exec/src/test/resources/window/b1.p2/0.data.json
new file mode 100644
index 0000000..b70cf91
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b1.p2/0.data.json
@@ -0,0 +1,22 @@
+// partition rows 10, subs [1, 2, 3, 4]
+// partition rows 10, subs [4, 5, 6]
+{ "employee_id":19, "position_id":2, "sub":6, "salary":16 }
+{ "employee_id":7, "position_id":1, "sub":4, "salary":14 }
+{ "employee_id":17, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":9, "position_id":1, "sub":4, "salary":14 }
+{ "employee_id":16, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":0, "position_id":1, "sub":1, "salary":11 }
+{ "employee_id":13, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":18, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":3, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":10, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":2, "position_id":1, "sub":2, "salary":12 }
+{ "employee_id":11, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":15, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":4, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":12, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":14, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":6, "position_id":1, "sub":4, "salary":14 }
+{ "employee_id":8, "position_id":1, "sub":4, "salary":14 }
+{ "employee_id":1, "position_id":1, "sub":2, "salary":12 }
+{ "employee_id":5, "position_id":1, "sub":3, "salary":13 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b2.p2.subs.tsv
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b2.p2.subs.tsv b/exec/java-exec/src/test/resources/window/b2.p2.subs.tsv
new file mode 100644
index 0000000..153efaf
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b2.p2.subs.tsv
@@ -0,0 +1,40 @@
+3	39	1	1	1	0.15	0.0
+3	39	2	1	1	0.15	0.0
+3	39	3	1	1	0.15	0.0
+8	114	4	4	2	0.4	0.15789473684210525
+8	114	5	4	2	0.4	0.15789473684210525
+8	114	6	4	2	0.4	0.15789473684210525
+8	114	7	4	2	0.4	0.15789473684210525
+8	114	8	4	2	0.4	0.15789473684210525
+20	342	9	9	3	1.0	0.42105263157894735
+20	342	10	9	3	1.0	0.42105263157894735
+20	342	11	9	3	1.0	0.42105263157894735
+20	342	12	9	3	1.0	0.42105263157894735
+20	342	13	9	3	1.0	0.42105263157894735
+20	342	14	9	3	1.0	0.42105263157894735
+20	342	15	9	3	1.0	0.42105263157894735
+20	342	16	9	3	1.0	0.42105263157894735
+20	342	17	9	3	1.0	0.42105263157894735
+20	342	18	9	3	1.0	0.42105263157894735
+20	342	19	9	3	1.0	0.42105263157894735
+20	342	20	9	3	1.0	0.42105263157894735
+9	171	1	1	1	0.45	0.0
+9	171	2	1	1	0.45	0.0
+9	171	3	1	1	0.45	0.0
+9	171	4	1	1	0.45	0.0
+9	171	5	1	1	0.45	0.0
+9	171	6	1	1	0.45	0.0
+9	171	7	1	1	0.45	0.0
+9	171	8	1	1	0.45	0.0
+9	171	9	1	1	0.45	0.0
+20	391	10	10	2	1.0	0.47368421052631576
+20	391	11	10	2	1.0	0.47368421052631576
+20	391	12	10	2	1.0	0.47368421052631576
+20	391	13	10	2	1.0	0.47368421052631576
+20	391	14	10	2	1.0	0.47368421052631576
+20	391	15	10	2	1.0	0.47368421052631576
+20	391	16	10	2	1.0	0.47368421052631576
+20	391	17	10	2	1.0	0.47368421052631576
+20	391	18	10	2	1.0	0.47368421052631576
+20	391	19	10	2	1.0	0.47368421052631576
+20	391	20	10	2	1.0	0.47368421052631576

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b2.p2.tsv
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b2.p2.tsv b/exec/java-exec/src/test/resources/window/b2.p2.tsv
new file mode 100644
index 0000000..9e62ba7
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b2.p2.tsv
@@ -0,0 +1,40 @@
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+20	342
+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

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b2.p2/0.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b2.p2/0.data.json b/exec/java-exec/src/test/resources/window/b2.p2/0.data.json
new file mode 100644
index 0000000..3e7efda
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b2.p2/0.data.json
@@ -0,0 +1,22 @@
+// partition rows 20, subs [3, 5, 9]
+// partition rows 20, subs [9, 10]
+{ "employee_id":18, "position_id":1, "sub":9, "salary":19 }
+{ "employee_id":31, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":39, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":32, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":8, "position_id":1, "sub":9, "salary":19 }
+{ "employee_id":34, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":24, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":1, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":10, "position_id":1, "sub":9, "salary":19 }
+{ "employee_id":22, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":36, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":15, "position_id":1, "sub":9, "salary":19 }
+{ "employee_id":4, "position_id":1, "sub":5, "salary":15 }
+{ "employee_id":2, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":11, "position_id":1, "sub":9, "salary":19 }
+{ "employee_id":33, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":37, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":9, "position_id":1, "sub":9, "salary":19 }
+{ "employee_id":30, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":23, "position_id":2, "sub":9, "salary":19 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b2.p2/1.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b2.p2/1.data.json b/exec/java-exec/src/test/resources/window/b2.p2/1.data.json
new file mode 100644
index 0000000..acdd419
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b2.p2/1.data.json
@@ -0,0 +1,20 @@
+{ "employee_id":27, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":13, "position_id":1, "sub":9, "salary":19 }
+{ "employee_id":21, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":0, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":25, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":3, "position_id":1, "sub":5, "salary":15 }
+{ "employee_id":5, "position_id":1, "sub":5, "salary":15 }
+{ "employee_id":17, "position_id":1, "sub":9, "salary":19 }
+{ "employee_id":12, "position_id":1, "sub":9, "salary":19 }
+{ "employee_id":29, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":6, "position_id":1, "sub":5, "salary":15 }
+{ "employee_id":7, "position_id":1, "sub":5, "salary":15 }
+{ "employee_id":16, "position_id":1, "sub":9, "salary":19 }
+{ "employee_id":35, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":38, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":20, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":19, "position_id":1, "sub":9, "salary":19 }
+{ "employee_id":14, "position_id":1, "sub":9, "salary":19 }
+{ "employee_id":28, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":26, "position_id":2, "sub":9, "salary":19 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b2.p4.subs.tsv
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b2.p4.subs.tsv b/exec/java-exec/src/test/resources/window/b2.p4.subs.tsv
new file mode 100644
index 0000000..62def92
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b2.p4.subs.tsv
@@ -0,0 +1,40 @@
+1	11	1	1	1	0.2	0.0
+3	35	2	2	2	0.6	0.25
+3	35	3	2	2	0.6	0.25
+5	61	4	4	3	1.0	0.75
+5	61	5	4	3	1.0	0.75
+3	39	1	1	1	0.3	0.0
+3	39	2	1	1	0.3	0.0
+3	39	3	1	1	0.3	0.0
+7	95	4	4	2	0.7	0.3333333333333333
+7	95	5	4	2	0.7	0.3333333333333333
+7	95	6	4	2	0.7	0.3333333333333333
+7	95	7	4	2	0.7	0.3333333333333333
+10	140	8	8	3	1.0	0.7777777777777778
+10	140	9	8	3	1.0	0.7777777777777778
+10	140	10	8	3	1.0	0.7777777777777778
+5	75	1	1	1	0.3333333333333333	0.0
+5	75	2	1	1	0.3333333333333333	0.0
+5	75	3	1	1	0.3333333333333333	0.0
+5	75	4	1	1	0.3333333333333333	0.0
+5	75	5	1	1	0.3333333333333333	0.0
+11	171	6	6	2	0.7333333333333333	0.35714285714285715
+11	171	7	6	2	0.7333333333333333	0.35714285714285715
+11	171	8	6	2	0.7333333333333333	0.35714285714285715
+11	171	9	6	2	0.7333333333333333	0.35714285714285715
+11	171	10	6	2	0.7333333333333333	0.35714285714285715
+11	171	11	6	2	0.7333333333333333	0.35714285714285715
+15	239	12	12	3	1.0	0.7857142857142857
+15	239	13	12	3	1.0	0.7857142857142857
+15	239	14	12	3	1.0	0.7857142857142857
+15	239	15	12	3	1.0	0.7857142857142857
+7	119	1	1	1	0.7	0.0
+7	119	2	1	1	0.7	0.0
+7	119	3	1	1	0.7	0.0
+7	119	4	1	1	0.7	0.0
+7	119	5	1	1	0.7	0.0
+7	119	6	1	1	0.7	0.0
+7	119	7	1	1	0.7	0.0
+10	173	8	8	2	1.0	0.7777777777777778
+10	173	9	8	2	1.0	0.7777777777777778
+10	173	10	8	2	1.0	0.7777777777777778

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b2.p4.tsv
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b2.p4.tsv b/exec/java-exec/src/test/resources/window/b2.p4.tsv
new file mode 100644
index 0000000..a9302c6
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b2.p4.tsv
@@ -0,0 +1,40 @@
+5	61
+5	61
+5	61
+5	61
+5	61
+10	140
+10	140
+10	140
+10	140
+10	140
+10	140
+10	140
+10	140
+10	140
+10	140
+15	239
+15	239
+15	239
+15	239
+15	239
+15	239
+15	239
+15	239
+15	239
+15	239
+15	239
+15	239
+15	239
+15	239
+15	239
+10	173
+10	173
+10	173
+10	173
+10	173
+10	173
+10	173
+10	173
+10	173
+10	173

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b2.p4/0.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b2.p4/0.data.json b/exec/java-exec/src/test/resources/window/b2.p4/0.data.json
new file mode 100644
index 0000000..02da7b8
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b2.p4/0.data.json
@@ -0,0 +1,24 @@
+// partition rows 5, subs [1, 2, 3]
+// partition rows 10, subs [3, 4, 5]
+// partition rows 15, subs [5, 6, 7]
+// partition rows 10, subs [7, 8]
+{ "employee_id":3, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":31, "position_id":4, "sub":7, "salary":17 }
+{ "employee_id":2, "position_id":1, "sub":2, "salary":12 }
+{ "employee_id":37, "position_id":4, "sub":8, "salary":18 }
+{ "employee_id":13, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":15, "position_id":3, "sub":5, "salary":15 }
+{ "employee_id":26, "position_id":3, "sub":7, "salary":17 }
+{ "employee_id":38, "position_id":4, "sub":8, "salary":18 }
+{ "employee_id":4, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":16, "position_id":3, "sub":5, "salary":15 }
+{ "employee_id":21, "position_id":3, "sub":6, "salary":16 }
+{ "employee_id":12, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":29, "position_id":3, "sub":7, "salary":17 }
+{ "employee_id":5, "position_id":2, "sub":3, "salary":13 }
+{ "employee_id":14, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":30, "position_id":4, "sub":7, "salary":17 }
+{ "employee_id":27, "position_id":3, "sub":7, "salary":17 }
+{ "employee_id":10, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":33, "position_id":4, "sub":7, "salary":17 }
+{ "employee_id":6, "position_id":2, "sub":3, "salary":13 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b2.p4/1.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b2.p4/1.data.json b/exec/java-exec/src/test/resources/window/b2.p4/1.data.json
new file mode 100644
index 0000000..3ed76af
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b2.p4/1.data.json
@@ -0,0 +1,20 @@
+{ "employee_id":1, "position_id":1, "sub":2, "salary":12 }
+{ "employee_id":36, "position_id":4, "sub":7, "salary":17 }
+{ "employee_id":19, "position_id":3, "sub":5, "salary":15 }
+{ "employee_id":22, "position_id":3, "sub":6, "salary":16 }
+{ "employee_id":34, "position_id":4, "sub":7, "salary":17 }
+{ "employee_id":11, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":23, "position_id":3, "sub":6, "salary":16 }
+{ "employee_id":9, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":28, "position_id":3, "sub":7, "salary":17 }
+{ "employee_id":18, "position_id":3, "sub":5, "salary":15 }
+{ "employee_id":32, "position_id":4, "sub":7, "salary":17 }
+{ "employee_id":8, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":17, "position_id":3, "sub":5, "salary":15 }
+{ "employee_id":0, "position_id":1, "sub":1, "salary":11 }
+{ "employee_id":39, "position_id":4, "sub":8, "salary":18 }
+{ "employee_id":20, "position_id":3, "sub":6, "salary":16 }
+{ "employee_id":25, "position_id":3, "sub":6, "salary":16 }
+{ "employee_id":24, "position_id":3, "sub":6, "salary":16 }
+{ "employee_id":35, "position_id":4, "sub":7, "salary":17 }
+{ "employee_id":7, "position_id":2, "sub":3, "salary":13 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b3.p2.subs.tsv
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b3.p2.subs.tsv b/exec/java-exec/src/test/resources/window/b3.p2.subs.tsv
new file mode 100644
index 0000000..3e735aa
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b3.p2.subs.tsv
@@ -0,0 +1,60 @@
+1	11	1	1	1	0.2	0.0
+3	35	2	2	2	0.6	0.25
+3	35	3	2	2	0.6	0.25
+5	61	4	4	3	1.0	0.75
+5	61	5	4	3	1.0	0.75
+4	56	1	1	1	0.07272727272727272	0.0
+4	56	2	1	1	0.07272727272727272	0.0
+4	56	3	1	1	0.07272727272727272	0.0
+4	56	4	1	1	0.07272727272727272	0.0
+9	131	5	5	2	0.16363636363636364	0.07407407407407407
+9	131	6	5	2	0.16363636363636364	0.07407407407407407
+9	131	7	5	2	0.16363636363636364	0.07407407407407407
+9	131	8	5	2	0.16363636363636364	0.07407407407407407
+9	131	9	5	2	0.16363636363636364	0.07407407407407407
+16	250	10	10	3	0.2909090909090909	0.16666666666666666
+16	250	11	10	3	0.2909090909090909	0.16666666666666666
+16	250	12	10	3	0.2909090909090909	0.16666666666666666
+16	250	13	10	3	0.2909090909090909	0.16666666666666666
+16	250	14	10	3	0.2909090909090909	0.16666666666666666
+16	250	15	10	3	0.2909090909090909	0.16666666666666666
+16	250	16	10	3	0.2909090909090909	0.16666666666666666
+24	394	17	17	4	0.43636363636363634	0.2962962962962963
+24	394	18	17	4	0.43636363636363634	0.2962962962962963
+24	394	19	17	4	0.43636363636363634	0.2962962962962963
+24	394	20	17	4	0.43636363636363634	0.2962962962962963
+24	394	21	17	4	0.43636363636363634	0.2962962962962963
+24	394	22	17	4	0.43636363636363634	0.2962962962962963
+24	394	23	17	4	0.43636363636363634	0.2962962962962963
+24	394	24	17	4	0.43636363636363634	0.2962962962962963
+33	565	25	25	5	0.6	0.4444444444444444
+33	565	26	25	5	0.6	0.4444444444444444
+33	565	27	25	5	0.6	0.4444444444444444
+33	565	28	25	5	0.6	0.4444444444444444
+33	565	29	25	5	0.6	0.4444444444444444
+33	565	30	25	5	0.6	0.4444444444444444
+33	565	31	25	5	0.6	0.4444444444444444
+33	565	32	25	5	0.6	0.4444444444444444
+33	565	33	25	5	0.6	0.4444444444444444
+43	765	34	34	6	0.7818181818181819	0.6111111111111112
+43	765	35	34	6	0.7818181818181819	0.6111111111111112
+43	765	36	34	6	0.7818181818181819	0.6111111111111112
+43	765	37	34	6	0.7818181818181819	0.6111111111111112
+43	765	38	34	6	0.7818181818181819	0.6111111111111112
+43	765	39	34	6	0.7818181818181819	0.6111111111111112
+43	765	40	34	6	0.7818181818181819	0.6111111111111112
+43	765	41	34	6	0.7818181818181819	0.6111111111111112
+43	765	42	34	6	0.7818181818181819	0.6111111111111112
+43	765	43	34	6	0.7818181818181819	0.6111111111111112
+54	996	44	44	7	0.9818181818181818	0.7962962962962963
+54	996	45	44	7	0.9818181818181818	0.7962962962962963
+54	996	46	44	7	0.9818181818181818	0.7962962962962963
+54	996	47	44	7	0.9818181818181818	0.7962962962962963
+54	996	48	44	7	0.9818181818181818	0.7962962962962963
+54	996	49	44	7	0.9818181818181818	0.7962962962962963
+54	996	50	44	7	0.9818181818181818	0.7962962962962963
+54	996	51	44	7	0.9818181818181818	0.7962962962962963
+54	996	52	44	7	0.9818181818181818	0.7962962962962963
+54	996	53	44	7	0.9818181818181818	0.7962962962962963
+54	996	54	44	7	0.9818181818181818	0.7962962962962963
+55	1018	55	55	8	1.0	1.0

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b3.p2.tsv
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b3.p2.tsv b/exec/java-exec/src/test/resources/window/b3.p2.tsv
new file mode 100644
index 0000000..ef32c2e
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b3.p2.tsv
@@ -0,0 +1,60 @@
+5	61
+5	61
+5	61
+5	61
+5	61
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018
+55	1018

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b3.p2/0.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b3.p2/0.data.json b/exec/java-exec/src/test/resources/window/b3.p2/0.data.json
new file mode 100644
index 0000000..39e285f
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b3.p2/0.data.json
@@ -0,0 +1,22 @@
+// partition rows 5, subs [1, 2, 3]
+// partition rows 55, subs [4, 5, 7, 8, 9, 10, 11, 12]
+{ "employee_id":56, "position_id":2, "sub":11, "salary":21 }
+{ "employee_id":42, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":53, "position_id":2, "sub":11, "salary":21 }
+{ "employee_id":28, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":33, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":25, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":23, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":41, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":50, "position_id":2, "sub":11, "salary":21 }
+{ "employee_id":27, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":35, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":54, "position_id":2, "sub":11, "salary":21 }
+{ "employee_id":4, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":9, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":15, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":13, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":31, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":12, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":57, "position_id":2, "sub":11, "salary":21 }
+{ "employee_id":45, "position_id":2, "sub":10, "salary":20 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b3.p2/1.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b3.p2/1.data.json b/exec/java-exec/src/test/resources/window/b3.p2/1.data.json
new file mode 100644
index 0000000..1d92e1a
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b3.p2/1.data.json
@@ -0,0 +1,20 @@
+{ "employee_id":26, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":6, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":19, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":7, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":51, "position_id":2, "sub":11, "salary":21 }
+{ "employee_id":47, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":21, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":44, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":46, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":59, "position_id":2, "sub":12, "salary":22 }
+{ "employee_id":36, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":30, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":1, "position_id":1, "sub":2, "salary":12 }
+{ "employee_id":5, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":40, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":32, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":11, "position_id":2, "sub":5, "salary":15 }
+{ "employee_id":0, "position_id":1, "sub":1, "salary":11 }
+{ "employee_id":49, "position_id":2, "sub":11, "salary":21 }
+{ "employee_id":48, "position_id":2, "sub":11, "salary":21 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/b3.p2/2.data.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/b3.p2/2.data.json b/exec/java-exec/src/test/resources/window/b3.p2/2.data.json
new file mode 100644
index 0000000..e0f5f3c
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b3.p2/2.data.json
@@ -0,0 +1,20 @@
+{ "employee_id":43, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":18, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":52, "position_id":2, "sub":11, "salary":21 }
+{ "employee_id":29, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":8, "position_id":2, "sub":4, "salary":14 }
+{ "employee_id":58, "position_id":2, "sub":11, "salary":21 }
+{ "employee_id":55, "position_id":2, "sub":11, "salary":21 }
+{ "employee_id":16, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":14, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":20, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":37, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":38, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":17, "position_id":2, "sub":7, "salary":17 }
+{ "employee_id":2, "position_id":1, "sub":2, "salary":12 }
+{ "employee_id":22, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":24, "position_id":2, "sub":8, "salary":18 }
+{ "employee_id":39, "position_id":2, "sub":10, "salary":20 }
+{ "employee_id":34, "position_id":2, "sub":9, "salary":19 }
+{ "employee_id":3, "position_id":1, "sub":3, "salary":13 }
+{ "employee_id":10, "position_id":2, "sub":5, "salary":15 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/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
new file mode 100644
index 0000000..c13597b
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b4.p4.subs.tsv
@@ -0,0 +1,80 @@
+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/3bccec91/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
new file mode 100644
index 0000000..29c57ae
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b4.p4.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	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

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/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
new file mode 100644
index 0000000..c40697c
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b4.p4/0.data.json
@@ -0,0 +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 }
+{ "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":22, "position_id":2, "sub":6, "salary":16 }
+{ "employee_id":61, "position_id":4, "sub":10, "salary":20 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/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
new file mode 100644
index 0000000..472c9b5
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b4.p4/1.data.json
@@ -0,0 +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":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":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 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/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
new file mode 100644
index 0000000..292200c
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b4.p4/2.data.json
@@ -0,0 +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":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 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/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
new file mode 100644
index 0000000..cd9008c
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/b4.p4/3.data.json
@@ -0,0 +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 }

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/mediumData.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/mediumData.json b/exec/java-exec/src/test/resources/window/mediumData.json
deleted file mode 100644
index ad86627..0000000
--- a/exec/java-exec/src/test/resources/window/mediumData.json
+++ /dev/null
@@ -1,1000 +0,0 @@
-{"id":814, "a": 1626, "group": 203}
-{"id":425, "a": 849, "group": 106}
-{"id":900, "a": 1800, "group": 225}
-{"id":156, "a": 312, "group": 39}
-{"id":348, "a": 696, "group": 87}
-{"id":987, "a": 1971, "group": 246}
-{"id":255, "a": 507, "group": 63}
-{"id":4, "a": 8, "group": 1}
-{"id":512, "a": 1024, "group": 128}
-{"id":341, "a": 681, "group": 85}
-{"id":113, "a": 225, "group": 28}
-{"id":311, "a": 619, "group": 77}
-{"id":906, "a": 1810, "group": 226}
-{"id":889, "a": 1777, "group": 222}
-{"id":611, "a": 1219, "group": 152}
-{"id":963, "a": 1923, "group": 240}
-{"id":522, "a": 1042, "group": 130}
-{"id":615, "a": 1227, "group": 153}
-{"id":227, "a": 451, "group": 56}
-{"id":365, "a": 729, "group": 91}
-{"id":73, "a": 145, "group": 18}
-{"id":747, "a": 1491, "group": 186}
-{"id":580, "a": 1160, "group": 145}
-{"id":552, "a": 1104, "group": 138}
-{"id":716, "a": 1432, "group": 179}
-{"id":982, "a": 1962, "group": 245}
-{"id":118, "a": 234, "group": 29}
-{"id":639, "a": 1275, "group": 159}
-{"id":273, "a": 545, "group": 68}
-{"id":679, "a": 1355, "group": 169}
-{"id":338, "a": 674, "group": 84}
-{"id":402, "a": 802, "group": 100}
-{"id":476, "a": 952, "group": 119}
-{"id":628, "a": 1256, "group": 157}
-{"id":325, "a": 649, "group": 81}
-{"id":749, "a": 1497, "group": 187}
-{"id":912, "a": 1824, "group": 228}
-{"id":995, "a": 1987, "group": 248}
-{"id":605, "a": 1209, "group": 151}
-{"id":141, "a": 281, "group": 35}
-{"id":700, "a": 1400, "group": 175}
-{"id":61, "a": 121, "group": 15}
-{"id":478, "a": 954, "group": 119}
-{"id":556, "a": 1112, "group": 139}
-{"id":229, "a": 457, "group": 57}
-{"id":487, "a": 971, "group": 121}
-{"id":824, "a": 1648, "group": 206}
-{"id":431, "a": 859, "group": 107}
-{"id":443, "a": 883, "group": 110}
-{"id":135, "a": 267, "group": 33}
-{"id":417, "a": 833, "group": 104}
-{"id":980, "a": 1960, "group": 245}
-{"id":785, "a": 1569, "group": 196}
-{"id":917, "a": 1833, "group": 229}
-{"id":656, "a": 1312, "group": 164}
-{"id":210, "a": 418, "group": 52}
-{"id":196, "a": 392, "group": 49}
-{"id":361, "a": 721, "group": 90}
-{"id":281, "a": 561, "group": 70}
-{"id":550, "a": 1098, "group": 137}
-{"id":558, "a": 1114, "group": 139}
-{"id":677, "a": 1353, "group": 169}
-{"id":604, "a": 1208, "group": 151}
-{"id":8, "a": 16, "group": 2}
-{"id":290, "a": 578, "group": 72}
-{"id":932, "a": 1864, "group": 233}
-{"id":731, "a": 1459, "group": 182}
-{"id":477, "a": 953, "group": 119}
-{"id":859, "a": 1715, "group": 214}
-{"id":291, "a": 579, "group": 72}
-{"id":531, "a": 1059, "group": 132}
-{"id":499, "a": 995, "group": 124}
-{"id":389, "a": 777, "group": 97}
-{"id":182, "a": 362, "group": 45}
-{"id":959, "a": 1915, "group": 239}
-{"id":523, "a": 1043, "group": 130}
-{"id":81, "a": 161, "group": 20}
-{"id":439, "a": 875, "group": 109}
-{"id":228, "a": 456, "group": 57}
-{"id":301, "a": 601, "group": 75}
-{"id":208, "a": 416, "group": 52}
-{"id":370, "a": 738, "group": 92}
-{"id":383, "a": 763, "group": 95}
-{"id":209, "a": 417, "group": 52}
-{"id":462, "a": 922, "group": 115}
-{"id":729, "a": 1457, "group": 182}
-{"id":602, "a": 1202, "group": 150}
-{"id":936, "a": 1872, "group": 234}
-{"id":750, "a": 1498, "group": 187}
-{"id":871, "a": 1739, "group": 217}
-{"id":120, "a": 240, "group": 30}
-{"id":843, "a": 1683, "group": 210}
-{"id":260, "a": 520, "group": 65}
-{"id":240, "a": 480, "group": 60}
-{"id":976, "a": 1952, "group": 244}
-{"id":344, "a": 688, "group": 86}
-{"id":385, "a": 769, "group": 96}
-{"id":410, "a": 818, "group": 102}
-{"id":931, "a": 1859, "group": 232}
-{"id":891, "a": 1779, "group": 222}
-{"id":745, "a": 1489, "group": 186}
-{"id":813, "a": 1625, "group": 203}
-{"id":129, "a": 257, "group": 32}
-{"id":596, "a": 1192, "group": 149}
-{"id":517, "a": 1033, "group": 129}
-{"id":755, "a": 1507, "group": 188}
-{"id":663, "a": 1323, "group": 165}
-{"id":233, "a": 465, "group": 58}
-{"id":401, "a": 801, "group": 100}
-{"id":473, "a": 945, "group": 118}
-{"id":990, "a": 1978, "group": 247}
-{"id":384, "a": 768, "group": 96}
-{"id":178, "a": 354, "group": 44}
-{"id":446, "a": 890, "group": 111}
-{"id":828, "a": 1656, "group": 207}
-{"id":356, "a": 712, "group": 89}
-{"id":249, "a": 497, "group": 62}
-{"id":553, "a": 1105, "group": 138}
-{"id":378, "a": 754, "group": 94}
-{"id":126, "a": 250, "group": 31}
-{"id":806, "a": 1610, "group": 201}
-{"id":540, "a": 1080, "group": 135}
-{"id":545, "a": 1089, "group": 136}
-{"id":398, "a": 794, "group": 99}
-{"id":848, "a": 1696, "group": 212}
-{"id":493, "a": 985, "group": 123}
-{"id":928, "a": 1856, "group": 232}
-{"id":408, "a": 816, "group": 102}
-{"id":285, "a": 569, "group": 71}
-{"id":795, "a": 1587, "group": 198}
-{"id":74, "a": 146, "group": 18}
-{"id":332, "a": 664, "group": 83}
-{"id":712, "a": 1424, "group": 178}
-{"id":858, "a": 1714, "group": 214}
-{"id":961, "a": 1921, "group": 240}
-{"id":212, "a": 424, "group": 53}
-{"id":11, "a": 19, "group": 2}
-{"id":839, "a": 1675, "group": 209}
-{"id":302, "a": 602, "group": 75}
-{"id":117, "a": 233, "group": 29}
-{"id":852, "a": 1704, "group": 213}
-{"id":528, "a": 1056, "group": 132}
-{"id":829, "a": 1657, "group": 207}
-{"id":563, "a": 1123, "group": 140}
-{"id":968, "a": 1936, "group": 242}
-{"id":658, "a": 1314, "group": 164}
-{"id":49, "a": 97, "group": 12}
-{"id":52, "a": 104, "group": 13}
-{"id":186, "a": 370, "group": 46}
-{"id":407, "a": 811, "group": 101}
-{"id":98, "a": 194, "group": 24}
-{"id":377, "a": 753, "group": 94}
-{"id":195, "a": 387, "group": 48}
-{"id":826, "a": 1650, "group": 206}
-{"id":783, "a": 1563, "group": 195}
-{"id":284, "a": 568, "group": 71}
-{"id":34, "a": 66, "group": 8}
-{"id":752, "a": 1504, "group": 188}
-{"id":472, "a": 944, "group": 118}
-{"id":500, "a": 1000, "group": 125}
-{"id":812, "a": 1624, "group": 203}
-{"id":300, "a": 600, "group": 75}
-{"id":691, "a": 1379, "group": 172}
-{"id":435, "a": 867, "group": 108}
-{"id":693, "a": 1385, "group": 173}
-{"id":847, "a": 1691, "group": 211}
-{"id":235, "a": 467, "group": 58}
-{"id":45, "a": 89, "group": 11}
-{"id":947, "a": 1891, "group": 236}
-{"id":184, "a": 368, "group": 46}
-{"id":996, "a": 1992, "group": 249}
-{"id":150, "a": 298, "group": 37}
-{"id":413, "a": 825, "group": 103}
-{"id":952, "a": 1904, "group": 238}
-{"id":594, "a": 1186, "group": 148}
-{"id":133, "a": 265, "group": 33}
-{"id":587, "a": 1171, "group": 146}
-{"id":612, "a": 1224, "group": 153}
-{"id":515, "a": 1027, "group": 128}
-{"id":718, "a": 1434, "group": 179}
-{"id":884, "a": 1768, "group": 221}
-{"id":887, "a": 1771, "group": 221}
-{"id":585, "a": 1169, "group": 146}
-{"id":695, "a": 1387, "group": 173}
-{"id":965, "a": 1929, "group": 241}
-{"id":591, "a": 1179, "group": 147}
-{"id":374, "a": 746, "group": 93}
-{"id":780, "a": 1560, "group": 195}
-{"id":305, "a": 609, "group": 76}
-{"id":71, "a": 139, "group": 17}
-{"id":84, "a": 168, "group": 21}
-{"id":58, "a": 114, "group": 14}
-{"id":12, "a": 24, "group": 3}
-{"id":315, "a": 627, "group": 78}
-{"id":131, "a": 259, "group": 32}
-{"id":362, "a": 722, "group": 90}
-{"id":490, "a": 978, "group": 122}
-{"id":234, "a": 466, "group": 58}
-{"id":349, "a": 697, "group": 87}
-{"id":688, "a": 1376, "group": 172}
-{"id":379, "a": 755, "group": 94}
-{"id":561, "a": 1121, "group": 140}
-{"id":363, "a": 723, "group": 90}
-{"id":287, "a": 571, "group": 71}
-{"id":770, "a": 1538, "group": 192}
-{"id":127, "a": 251, "group": 31}
-{"id":583, "a": 1163, "group": 145}
-{"id":471, "a": 939, "group": 117}
-{"id":788, "a": 1576, "group": 197}
-{"id":897, "a": 1793, "group": 224}
-{"id":916, "a": 1832, "group": 229}
-{"id":956, "a": 1912, "group": 239}
-{"id":224, "a": 448, "group": 56}
-{"id":787, "a": 1571, "group": 196}
-{"id":173, "a": 345, "group": 43}
-{"id":47, "a": 91, "group": 11}
-{"id":180, "a": 360, "group": 45}
-{"id":488, "a": 976, "group": 122}
-{"id":764, "a": 1528, "group": 191}
-{"id":112, "a": 224, "group": 28}
-{"id":781, "a": 1561, "group": 195}
-{"id":14, "a": 26, "group": 3}
-{"id":204, "a": 408, "group": 51}
-{"id":317, "a": 633, "group": 79}
-{"id":784, "a": 1568, "group": 196}
-{"id":796, "a": 1592, "group": 199}
-{"id":375, "a": 747, "group": 93}
-{"id":618, "a": 1234, "group": 154}
-{"id":207, "a": 411, "group": 51}
-{"id":179, "a": 355, "group": 44}
-{"id":297, "a": 593, "group": 74}
-{"id":838, "a": 1674, "group": 209}
-{"id":699, "a": 1395, "group": 174}
-{"id":320, "a": 640, "group": 80}
-{"id":675, "a": 1347, "group": 168}
-{"id":925, "a": 1849, "group": 231}
-{"id":684, "a": 1368, "group": 171}
-{"id":986, "a": 1970, "group": 246}
-{"id":930, "a": 1858, "group": 232}
-{"id":911, "a": 1819, "group": 227}
-{"id":977, "a": 1953, "group": 244}
-{"id":48, "a": 96, "group": 12}
-{"id":496, "a": 992, "group": 124}
-{"id":794, "a": 1586, "group": 198}
-{"id":867, "a": 1731, "group": 216}
-{"id":520, "a": 1040, "group": 130}
-{"id":621, "a": 1241, "group": 155}
-{"id":475, "a": 947, "group": 118}
-{"id":270, "a": 538, "group": 67}
-{"id":648, "a": 1296, "group": 162}
-{"id":842, "a": 1682, "group": 210}
-{"id":200, "a": 400, "group": 50}
-{"id":924, "a": 1848, "group": 231}
-{"id":466, "a": 930, "group": 116}
-{"id":40, "a": 80, "group": 10}
-{"id":600, "a": 1200, "group": 150}
-{"id":883, "a": 1763, "group": 220}
-{"id":221, "a": 441, "group": 55}
-{"id":106, "a": 210, "group": 26}
-{"id":313, "a": 625, "group": 78}
-{"id":761, "a": 1521, "group": 190}
-{"id":800, "a": 1600, "group": 200}
-{"id":241, "a": 481, "group": 60}
-{"id":640, "a": 1280, "group": 160}
-{"id":358, "a": 714, "group": 89}
-{"id":960, "a": 1920, "group": 240}
-{"id":347, "a": 691, "group": 86}
-{"id":646, "a": 1290, "group": 161}
-{"id":236, "a": 472, "group": 59}
-{"id":920, "a": 1840, "group": 230}
-{"id":586, "a": 1170, "group": 146}
-{"id":175, "a": 347, "group": 43}
-{"id":371, "a": 739, "group": 92}
-{"id":741, "a": 1481, "group": 185}
-{"id":652, "a": 1304, "group": 163}
-{"id":164, "a": 328, "group": 41}
-{"id":444, "a": 888, "group": 111}
-{"id":949, "a": 1897, "group": 237}
-{"id":115, "a": 227, "group": 28}
-{"id":893, "a": 1785, "group": 223}
-{"id":940, "a": 1880, "group": 235}
-{"id":261, "a": 521, "group": 65}
-{"id":105, "a": 209, "group": 26}
-{"id":449, "a": 897, "group": 112}
-{"id":94, "a": 186, "group": 23}
-{"id":810, "a": 1618, "group": 202}
-{"id":252, "a": 504, "group": 63}
-{"id":946, "a": 1890, "group": 236}
-{"id":136, "a": 272, "group": 34}
-{"id":70, "a": 138, "group": 17}
-{"id":203, "a": 403, "group": 50}
-{"id":276, "a": 552, "group": 69}
-{"id":703, "a": 1403, "group": 175}
-{"id":714, "a": 1426, "group": 178}
-{"id":144, "a": 288, "group": 36}
-{"id":763, "a": 1523, "group": 190}
-{"id":142, "a": 282, "group": 35}
-{"id":406, "a": 810, "group": 101}
-{"id":225, "a": 449, "group": 56}
-{"id":93, "a": 185, "group": 23}
-{"id":622, "a": 1242, "group": 155}
-{"id":461, "a": 921, "group": 115}
-{"id":923, "a": 1843, "group": 230}
-{"id":971, "a": 1939, "group": 242}
-{"id":748, "a": 1496, "group": 187}
-{"id":687, "a": 1371, "group": 171}
-{"id":340, "a": 680, "group": 85}
-{"id":223, "a": 443, "group": 55}
-{"id":625, "a": 1249, "group": 156}
-{"id":895, "a": 1787, "group": 223}
-{"id":738, "a": 1474, "group": 184}
-{"id":35, "a": 67, "group": 8}
-{"id":159, "a": 315, "group": 39}
-{"id":981, "a": 1961, "group": 245}
-{"id":521, "a": 1041, "group": 130}
-{"id":36, "a": 72, "group": 9}
-{"id":360, "a": 720, "group": 90}
-{"id":194, "a": 386, "group": 48}
-{"id":333, "a": 665, "group": 83}
-{"id":816, "a": 1632, "group": 204}
-{"id":805, "a": 1609, "group": 201}
-{"id":122, "a": 242, "group": 30}
-{"id":67, "a": 131, "group": 16}
-{"id":866, "a": 1730, "group": 216}
-{"id":219, "a": 435, "group": 54}
-{"id":274, "a": 546, "group": 68}
-{"id":102, "a": 202, "group": 25}
-{"id":951, "a": 1899, "group": 237}
-{"id":836, "a": 1672, "group": 209}
-{"id":191, "a": 379, "group": 47}
-{"id":337, "a": 673, "group": 84}
-{"id":841, "a": 1681, "group": 210}
-{"id":92, "a": 184, "group": 23}
-{"id":481, "a": 961, "group": 120}
-{"id":970, "a": 1938, "group": 242}
-{"id":878, "a": 1754, "group": 219}
-{"id":294, "a": 586, "group": 73}
-{"id":386, "a": 770, "group": 96}
-{"id":484, "a": 968, "group": 121}
-{"id":789, "a": 1577, "group": 197}
-{"id":492, "a": 984, "group": 123}
-{"id":19, "a": 35, "group": 4}
-{"id":263, "a": 523, "group": 65}
-{"id":514, "a": 1026, "group": 128}
-{"id":352, "a": 704, "group": 88}
-{"id":503, "a": 1003, "group": 125}
-{"id":726, "a": 1450, "group": 181}
-{"id":890, "a": 1778, "group": 222}
-{"id":926, "a": 1850, "group": 231}
-{"id":707, "a": 1411, "group": 176}
-{"id":216, "a": 432, "group": 54}
-{"id":807, "a": 1611, "group": 201}
-{"id":942, "a": 1882, "group": 235}
-{"id":678, "a": 1354, "group": 169}
-{"id":354, "a": 706, "group": 88}
-{"id":77, "a": 153, "group": 19}
-{"id":75, "a": 147, "group": 18}
-{"id":830, "a": 1658, "group": 207}
-{"id":215, "a": 427, "group": 53}
-{"id":966, "a": 1930, "group": 241}
-{"id":603, "a": 1203, "group": 150}
-{"id":137, "a": 273, "group": 34}
-{"id":17, "a": 33, "group": 4}
-{"id":991, "a": 1979, "group": 247}
-{"id":299, "a": 595, "group": 74}
-{"id":643, "a": 1283, "group": 160}
-{"id":190, "a": 378, "group": 47}
-{"id":967, "a": 1931, "group": 241}
-{"id":169, "a": 337, "group": 42}
-{"id":460, "a": 920, "group": 115}
-{"id":330, "a": 658, "group": 82}
-{"id":436, "a": 872, "group": 109}
-{"id":393, "a": 785, "group": 98}
-{"id":329, "a": 657, "group": 82}
-{"id":80, "a": 160, "group": 20}
-{"id":395, "a": 787, "group": 98}
-{"id":623, "a": 1243, "group": 155}
-{"id":110, "a": 218, "group": 27}
-{"id":213, "a": 425, "group": 53}
-{"id":448, "a": 896, "group": 112}
-{"id":671, "a": 1339, "group": 167}
-{"id":751, "a": 1499, "group": 187}
-{"id":606, "a": 1210, "group": 151}
-{"id":624, "a": 1248, "group": 156}
-{"id":766, "a": 1530, "group": 191}
-{"id":31, "a": 59, "group": 7}
-{"id":649, "a": 1297, "group": 162}
-{"id":863, "a": 1723, "group": 215}
-{"id":328, "a": 656, "group": 82}
-{"id":686, "a": 1370, "group": 171}
-{"id":343, "a": 683, "group": 85}
-{"id":418, "a": 834, "group": 104}
-{"id":850, "a": 1698, "group": 212}
-{"id":892, "a": 1784, "group": 223}
-{"id":657, "a": 1313, "group": 164}
-{"id":880, "a": 1760, "group": 220}
-{"id":988, "a": 1976, "group": 247}
-{"id":772, "a": 1544, "group": 193}
-{"id":909, "a": 1817, "group": 227}
-{"id":394, "a": 786, "group": 98}
-{"id":999, "a": 1995, "group": 249}
-{"id":161, "a": 321, "group": 40}
-{"id":754, "a": 1506, "group": 188}
-{"id":56, "a": 112, "group": 14}
-{"id":733, "a": 1465, "group": 183}
-{"id":870, "a": 1738, "group": 217}
-{"id":456, "a": 912, "group": 114}
-{"id":114, "a": 226, "group": 28}
-{"id":571, "a": 1139, "group": 142}
-{"id":567, "a": 1131, "group": 141}
-{"id":827, "a": 1651, "group": 206}
-{"id":757, "a": 1513, "group": 189}
-{"id":720, "a": 1440, "group": 180}
-{"id":709, "a": 1417, "group": 177}
-{"id":831, "a": 1659, "group": 207}
-{"id":773, "a": 1545, "group": 193}
-{"id":201, "a": 401, "group": 50}
-{"id":23, "a": 43, "group": 5}
-{"id":421, "a": 841, "group": 105}
-{"id":516, "a": 1032, "group": 129}
-{"id":22, "a": 42, "group": 5}
-{"id":538, "a": 1074, "group": 134}
-{"id":588, "a": 1176, "group": 147}
-{"id":326, "a": 650, "group": 81}
-{"id":815, "a": 1627, "group": 203}
-{"id":319, "a": 635, "group": 79}
-{"id":440, "a": 880, "group": 110}
-{"id":875, "a": 1747, "group": 218}
-{"id":634, "a": 1266, "group": 158}
-{"id":172, "a": 344, "group": 43}
-{"id":694, "a": 1386, "group": 173}
-{"id":767, "a": 1531, "group": 191}
-{"id":324, "a": 648, "group": 81}
-{"id":33, "a": 65, "group": 8}
-{"id":935, "a": 1867, "group": 233}
-{"id":667, "a": 1331, "group": 166}
-{"id":91, "a": 179, "group": 22}
-{"id":719, "a": 1435, "group": 179}
-{"id":582, "a": 1162, "group": 145}
-{"id":739, "a": 1475, "group": 184}
-{"id":635, "a": 1267, "group": 158}
-{"id":367, "a": 731, "group": 91}
-{"id":636, "a": 1272, "group": 159}
-{"id":743, "a": 1483, "group": 185}
-{"id":463, "a": 923, "group": 115}
-{"id":834, "a": 1666, "group": 208}
-{"id":532, "a": 1064, "group": 133}
-{"id":704, "a": 1408, "group": 176}
-{"id":387, "a": 771, "group": 96}
-{"id":57, "a": 113, "group": 14}
-{"id":153, "a": 305, "group": 38}
-{"id":364, "a": 728, "group": 91}
-{"id":905, "a": 1809, "group": 226}
-{"id":578, "a": 1154, "group": 144}
-{"id":265, "a": 529, "group": 66}
-{"id":642, "a": 1282, "group": 160}
-{"id":689, "a": 1377, "group": 172}
-{"id":574, "a": 1146, "group": 143}
-{"id":318, "a": 634, "group": 79}
-{"id":519, "a": 1035, "group": 129}
-{"id":411, "a": 819, "group": 102}
-{"id":465, "a": 929, "group": 116}
-{"id":174, "a": 346, "group": 43}
-{"id":286, "a": 570, "group": 71}
-{"id":162, "a": 322, "group": 40}
-{"id":894, "a": 1786, "group": 223}
-{"id":445, "a": 889, "group": 111}
-{"id":295, "a": 587, "group": 73}
-{"id":599, "a": 1195, "group": 149}
-{"id":1000, "a": 2000, "group": 250}
-{"id":491, "a": 979, "group": 122}
-{"id":539, "a": 1075, "group": 134}
-{"id":664, "a": 1328, "group": 166}
-{"id":771, "a": 1539, "group": 192}
-{"id":244, "a": 488, "group": 61}
-{"id":123, "a": 243, "group": 30}
-{"id":230, "a": 458, "group": 57}
-{"id":149, "a": 297, "group": 37}
-{"id":467, "a": 931, "group": 116}
-{"id":372, "a": 744, "group": 93}
-{"id":921, "a": 1841, "group": 230}
-{"id":388, "a": 776, "group": 97}
-{"id":898, "a": 1794, "group": 224}
-{"id":239, "a": 475, "group": 59}
-{"id":390, "a": 778, "group": 97}
-{"id":903, "a": 1803, "group": 225}
-{"id":382, "a": 762, "group": 95}
-{"id":715, "a": 1427, "group": 178}
-{"id":774, "a": 1546, "group": 193}
-{"id":259, "a": 515, "group": 64}
-{"id":419, "a": 835, "group": 104}
-{"id":51, "a": 99, "group": 12}
-{"id":929, "a": 1857, "group": 232}
-{"id":455, "a": 907, "group": 113}
-{"id":404, "a": 808, "group": 101}
-{"id":526, "a": 1050, "group": 131}
-{"id":985, "a": 1969, "group": 246}
-{"id":518, "a": 1034, "group": 129}
-{"id":323, "a": 643, "group": 80}
-{"id":821, "a": 1641, "group": 205}
-{"id":427, "a": 851, "group": 106}
-{"id":833, "a": 1665, "group": 208}
-{"id":723, "a": 1443, "group": 180}
-{"id":973, "a": 1945, "group": 243}
-{"id":555, "a": 1107, "group": 138}
-{"id":513, "a": 1025, "group": 128}
-{"id":251, "a": 499, "group": 62}
-{"id":217, "a": 433, "group": 54}
-{"id":581, "a": 1161, "group": 145}
-{"id":345, "a": 689, "group": 86}
-{"id":498, "a": 994, "group": 124}
-{"id":637, "a": 1273, "group": 159}
-{"id":955, "a": 1907, "group": 238}
-{"id":680, "a": 1360, "group": 170}
-{"id":310, "a": 618, "group": 77}
-{"id":817, "a": 1633, "group": 204}
-{"id":346, "a": 690, "group": 86}
-{"id":958, "a": 1914, "group": 239}
-{"id":506, "a": 1010, "group": 126}
-{"id":403, "a": 803, "group": 100}
-{"id":865, "a": 1729, "group": 216}
-{"id":666, "a": 1330, "group": 166}
-{"id":264, "a": 528, "group": 66}
-{"id":258, "a": 514, "group": 64}
-{"id":944, "a": 1888, "group": 236}
-{"id":422, "a": 842, "group": 105}
-{"id":914, "a": 1826, "group": 228}
-{"id":862, "a": 1722, "group": 215}
-{"id":405, "a": 809, "group": 101}
-{"id":250, "a": 498, "group": 62}
-{"id":541, "a": 1081, "group": 135}
-{"id":644, "a": 1288, "group": 161}
-{"id":423, "a": 843, "group": 105}
-{"id":480, "a": 960, "group": 120}
-{"id":28, "a": 56, "group": 7}
-{"id":734, "a": 1466, "group": 183}
-{"id":452, "a": 904, "group": 113}
-{"id":268, "a": 536, "group": 67}
-{"id":708, "a": 1416, "group": 177}
-{"id":451, "a": 899, "group": 112}
-{"id":535, "a": 1067, "group": 133}
-{"id":1, "a": 1, "group": 0}
-{"id":943, "a": 1883, "group": 235}
-{"id":510, "a": 1018, "group": 127}
-{"id":464, "a": 928, "group": 116}
-{"id":705, "a": 1409, "group": 176}
-{"id":381, "a": 761, "group": 95}
-{"id":6, "a": 10, "group": 1}
-{"id":257, "a": 513, "group": 64}
-{"id":851, "a": 1699, "group": 212}
-{"id":938, "a": 1874, "group": 234}
-{"id":835, "a": 1667, "group": 208}
-{"id":501, "a": 1001, "group": 125}
-{"id":296, "a": 592, "group": 74}
-{"id":818, "a": 1634, "group": 204}
-{"id":577, "a": 1153, "group": 144}
-{"id":730, "a": 1458, "group": 182}
-{"id":450, "a": 898, "group": 112}
-{"id":391, "a": 779, "group": 97}
-{"id":256, "a": 512, "group": 64}
-{"id":544, "a": 1088, "group": 136}
-{"id":629, "a": 1257, "group": 157}
-{"id":189, "a": 377, "group": 47}
-{"id":304, "a": 608, "group": 76}
-{"id":508, "a": 1016, "group": 127}
-{"id":681, "a": 1361, "group": 170}
-{"id":86, "a": 170, "group": 21}
-{"id":901, "a": 1801, "group": 225}
-{"id":55, "a": 107, "group": 13}
-{"id":647, "a": 1291, "group": 161}
-{"id":737, "a": 1473, "group": 184}
-{"id":5, "a": 9, "group": 1}
-{"id":879, "a": 1755, "group": 219}
-{"id":913, "a": 1825, "group": 228}
-{"id":557, "a": 1113, "group": 139}
-{"id":430, "a": 858, "group": 107}
-{"id":30, "a": 58, "group": 7}
-{"id":779, "a": 1555, "group": 194}
-{"id":237, "a": 473, "group": 59}
-{"id":238, "a": 474, "group": 59}
-{"id":69, "a": 137, "group": 17}
-{"id":165, "a": 329, "group": 41}
-{"id":804, "a": 1608, "group": 201}
-{"id":672, "a": 1344, "group": 168}
-{"id":904, "a": 1808, "group": 226}
-{"id":20, "a": 40, "group": 5}
-{"id":650, "a": 1298, "group": 162}
-{"id":124, "a": 248, "group": 31}
-{"id":819, "a": 1635, "group": 204}
-{"id":76, "a": 152, "group": 19}
-{"id":918, "a": 1834, "group": 229}
-{"id":855, "a": 1707, "group": 213}
-{"id":922, "a": 1842, "group": 230}
-{"id":562, "a": 1122, "group": 140}
-{"id":101, "a": 201, "group": 25}
-{"id":96, "a": 192, "group": 24}
-{"id":357, "a": 713, "group": 89}
-{"id":279, "a": 555, "group": 69}
-{"id":759, "a": 1515, "group": 189}
-{"id":293, "a": 585, "group": 73}
-{"id":653, "a": 1305, "group": 163}
-{"id":108, "a": 216, "group": 27}
-{"id":254, "a": 506, "group": 63}
-{"id":655, "a": 1307, "group": 163}
-{"id":945, "a": 1889, "group": 236}
-{"id":572, "a": 1144, "group": 143}
-{"id":756, "a": 1512, "group": 189}
-{"id":822, "a": 1642, "group": 205}
-{"id":288, "a": 576, "group": 72}
-{"id":641, "a": 1281, "group": 160}
-{"id":275, "a": 547, "group": 68}
-{"id":654, "a": 1306, "group": 163}
-{"id":896, "a": 1792, "group": 224}
-{"id":192, "a": 384, "group": 48}
-{"id":885, "a": 1769, "group": 221}
-{"id":660, "a": 1320, "group": 165}
-{"id":573, "a": 1145, "group": 143}
-{"id":163, "a": 323, "group": 40}
-{"id":802, "a": 1602, "group": 200}
-{"id":874, "a": 1746, "group": 218}
-{"id":791, "a": 1579, "group": 197}
-{"id":303, "a": 603, "group": 75}
-{"id":267, "a": 531, "group": 66}
-{"id":529, "a": 1057, "group": 132}
-{"id":811, "a": 1619, "group": 202}
-{"id":713, "a": 1425, "group": 178}
-{"id":193, "a": 385, "group": 48}
-{"id":886, "a": 1770, "group": 221}
-{"id":416, "a": 832, "group": 104}
-{"id":786, "a": 1570, "group": 196}
-{"id":15, "a": 27, "group": 3}
-{"id":626, "a": 1250, "group": 156}
-{"id":83, "a": 163, "group": 20}
-{"id":231, "a": 459, "group": 57}
-{"id":777, "a": 1553, "group": 194}
-{"id":78, "a": 154, "group": 19}
-{"id":877, "a": 1753, "group": 219}
-{"id":232, "a": 464, "group": 58}
-{"id":607, "a": 1211, "group": 151}
-{"id":525, "a": 1049, "group": 131}
-{"id":322, "a": 642, "group": 80}
-{"id":41, "a": 81, "group": 10}
-{"id":882, "a": 1762, "group": 220}
-{"id":957, "a": 1913, "group": 239}
-{"id":21, "a": 41, "group": 5}
-{"id":728, "a": 1456, "group": 182}
-{"id":206, "a": 410, "group": 51}
-{"id":775, "a": 1547, "group": 193}
-{"id":2, "a": 2, "group": 0}
-{"id":673, "a": 1345, "group": 168}
-{"id":64, "a": 128, "group": 16}
-{"id":309, "a": 617, "group": 77}
-{"id":415, "a": 827, "group": 103}
-{"id":537, "a": 1073, "group": 134}
-{"id":597, "a": 1193, "group": 149}
-{"id":458, "a": 914, "group": 114}
-{"id":872, "a": 1744, "group": 218}
-{"id":355, "a": 707, "group": 88}
-{"id":638, "a": 1274, "group": 159}
-{"id":546, "a": 1090, "group": 136}
-{"id":140, "a": 280, "group": 35}
-{"id":331, "a": 659, "group": 82}
-{"id":697, "a": 1393, "group": 174}
-{"id":9, "a": 17, "group": 2}
-{"id":60, "a": 120, "group": 15}
-{"id":849, "a": 1697, "group": 212}
-{"id":119, "a": 235, "group": 29}
-{"id":316, "a": 632, "group": 79}
-{"id":782, "a": 1562, "group": 195}
-{"id":565, "a": 1129, "group": 141}
-{"id":494, "a": 986, "group": 123}
-{"id":437, "a": 873, "group": 109}
-{"id":856, "a": 1712, "group": 214}
-{"id":397, "a": 793, "group": 99}
-{"id":742, "a": 1482, "group": 185}
-{"id":692, "a": 1384, "group": 173}
-{"id":854, "a": 1706, "group": 213}
-{"id":68, "a": 136, "group": 17}
-{"id":869, "a": 1737, "group": 217}
-{"id":280, "a": 560, "group": 70}
-{"id":242, "a": 482, "group": 60}
-{"id":66, "a": 130, "group": 16}
-{"id":823, "a": 1643, "group": 205}
-{"id":964, "a": 1928, "group": 241}
-{"id":158, "a": 314, "group": 39}
-{"id":690, "a": 1378, "group": 172}
-{"id":185, "a": 369, "group": 46}
-{"id":619, "a": 1235, "group": 154}
-{"id":400, "a": 800, "group": 100}
-{"id":908, "a": 1816, "group": 227}
-{"id":109, "a": 217, "group": 27}
-{"id":54, "a": 106, "group": 13}
-{"id":511, "a": 1019, "group": 127}
-{"id":111, "a": 219, "group": 27}
-{"id":125, "a": 249, "group": 31}
-{"id":85, "a": 169, "group": 21}
-{"id":617, "a": 1233, "group": 154}
-{"id":798, "a": 1594, "group": 199}
-{"id":399, "a": 795, "group": 99}
-{"id":470, "a": 938, "group": 117}
-{"id":645, "a": 1289, "group": 161}
-{"id":187, "a": 371, "group": 46}
-{"id":474, "a": 946, "group": 118}
-{"id":134, "a": 266, "group": 33}
-{"id":335, "a": 667, "group": 83}
-{"id":711, "a": 1419, "group": 177}
-{"id":145, "a": 289, "group": 36}
-{"id":157, "a": 313, "group": 39}
-{"id":177, "a": 353, "group": 44}
-{"id":808, "a": 1616, "group": 202}
-{"id":662, "a": 1322, "group": 165}
-{"id":420, "a": 840, "group": 105}
-{"id":568, "a": 1136, "group": 142}
-{"id":130, "a": 258, "group": 32}
-{"id":864, "a": 1728, "group": 216}
-{"id":542, "a": 1082, "group": 135}
-{"id":89, "a": 177, "group": 22}
-{"id":26, "a": 50, "group": 6}
-{"id":969, "a": 1937, "group": 242}
-{"id":366, "a": 730, "group": 91}
-{"id":575, "a": 1147, "group": 143}
-{"id":368, "a": 736, "group": 92}
-{"id":308, "a": 616, "group": 77}
-{"id":941, "a": 1881, "group": 235}
-{"id":590, "a": 1178, "group": 147}
-{"id":825, "a": 1649, "group": 206}
-{"id":732, "a": 1464, "group": 183}
-{"id":569, "a": 1137, "group": 142}
-{"id":601, "a": 1201, "group": 150}
-{"id":746, "a": 1490, "group": 186}
-{"id":246, "a": 490, "group": 61}
-{"id":116, "a": 232, "group": 29}
-{"id":873, "a": 1745, "group": 218}
-{"id":181, "a": 361, "group": 45}
-{"id":876, "a": 1752, "group": 219}
-{"id":632, "a": 1264, "group": 158}
-{"id":336, "a": 672, "group": 84}
-{"id":128, "a": 256, "group": 32}
-{"id":292, "a": 584, "group": 73}
-{"id":205, "a": 409, "group": 51}
-{"id":429, "a": 857, "group": 107}
-{"id":845, "a": 1689, "group": 211}
-{"id":143, "a": 283, "group": 35}
-{"id":668, "a": 1336, "group": 167}
-{"id":744, "a": 1488, "group": 186}
-{"id":630, "a": 1258, "group": 157}
-{"id":53, "a": 105, "group": 13}
-{"id":792, "a": 1584, "group": 198}
-{"id":593, "a": 1185, "group": 148}
-{"id":803, "a": 1603, "group": 200}
-{"id":899, "a": 1795, "group": 224}
-{"id":253, "a": 505, "group": 63}
-{"id":243, "a": 483, "group": 60}
-{"id":245, "a": 489, "group": 61}
-{"id":82, "a": 162, "group": 20}
-{"id":497, "a": 993, "group": 124}
-{"id":95, "a": 187, "group": 23}
-{"id":7, "a": 11, "group": 1}
-{"id":919, "a": 1835, "group": 229}
-{"id":710, "a": 1418, "group": 177}
-{"id":351, "a": 699, "group": 87}
-{"id":651, "a": 1299, "group": 162}
-{"id":954, "a": 1906, "group": 238}
-{"id":170, "a": 338, "group": 42}
-{"id":32, "a": 64, "group": 8}
-{"id":222, "a": 442, "group": 55}
-{"id":479, "a": 955, "group": 119}
-{"id":706, "a": 1410, "group": 176}
-{"id":564, "a": 1128, "group": 141}
-{"id":769, "a": 1537, "group": 192}
-{"id":524, "a": 1048, "group": 131}
-{"id":46, "a": 90, "group": 11}
-{"id":793, "a": 1585, "group": 198}
-{"id":837, "a": 1673, "group": 209}
-{"id":979, "a": 1955, "group": 244}
-{"id":962, "a": 1922, "group": 240}
-{"id":740, "a": 1480, "group": 185}
-{"id":282, "a": 562, "group": 70}
-{"id":724, "a": 1448, "group": 181}
-{"id":509, "a": 1017, "group": 127}
-{"id":266, "a": 530, "group": 66}
-{"id":271, "a": 539, "group": 67}
-{"id":155, "a": 307, "group": 38}
-{"id":18, "a": 34, "group": 4}
-{"id":339, "a": 675, "group": 84}
-{"id":598, "a": 1194, "group": 149}
-{"id":948, "a": 1896, "group": 237}
-{"id":910, "a": 1818, "group": 227}
-{"id":846, "a": 1690, "group": 211}
-{"id":138, "a": 274, "group": 34}
-{"id":760, "a": 1520, "group": 190}
-{"id":853, "a": 1705, "group": 213}
-{"id":860, "a": 1720, "group": 215}
-{"id":283, "a": 563, "group": 70}
-{"id":188, "a": 376, "group": 47}
-{"id":613, "a": 1225, "group": 153}
-{"id":321, "a": 641, "group": 80}
-{"id":148, "a": 296, "group": 37}
-{"id":674, "a": 1346, "group": 168}
-{"id":226, "a": 450, "group": 56}
-{"id":994, "a": 1986, "group": 248}
-{"id":998, "a": 1994, "group": 249}
-{"id":97, "a": 193, "group": 24}
-{"id":160, "a": 320, "group": 40}
-{"id":616, "a": 1232, "group": 154}
-{"id":424, "a": 848, "group": 106}
-{"id":937, "a": 1873, "group": 234}
-{"id":392, "a": 784, "group": 98}
-{"id":25, "a": 49, "group": 6}
-{"id":88, "a": 176, "group": 22}
-{"id":534, "a": 1066, "group": 133}
-{"id":536, "a": 1072, "group": 134}
-{"id":530, "a": 1058, "group": 132}
-{"id":289, "a": 577, "group": 72}
-{"id":861, "a": 1721, "group": 215}
-{"id":376, "a": 752, "group": 94}
-{"id":682, "a": 1362, "group": 170}
-{"id":327, "a": 651, "group": 81}
-{"id":566, "a": 1130, "group": 141}
-{"id":199, "a": 395, "group": 49}
-{"id":902, "a": 1802, "group": 225}
-{"id":433, "a": 865, "group": 108}
-{"id":13, "a": 25, "group": 3}
-{"id":103, "a": 203, "group": 25}
-{"id":907, "a": 1811, "group": 226}
-{"id":989, "a": 1977, "group": 247}
-{"id":974, "a": 1946, "group": 243}
-{"id":978, "a": 1954, "group": 244}
-{"id":107, "a": 211, "group": 26}
-{"id":722, "a": 1442, "group": 180}
-{"id":38, "a": 74, "group": 9}
-{"id":549, "a": 1097, "group": 137}
-{"id":485, "a": 969, "group": 121}
-{"id":218, "a": 434, "group": 54}
-{"id":927, "a": 1851, "group": 231}
-{"id":725, "a": 1449, "group": 181}
-{"id":702, "a": 1402, "group": 175}
-{"id":198, "a": 394, "group": 49}
-{"id":214, "a": 426, "group": 53}
-{"id":373, "a": 745, "group": 93}
-{"id":147, "a": 291, "group": 36}
-{"id":63, "a": 123, "group": 15}
-{"id":79, "a": 155, "group": 19}
-{"id":543, "a": 1083, "group": 135}
-{"id":334, "a": 666, "group": 83}
-{"id":59, "a": 115, "group": 14}
-{"id":459, "a": 915, "group": 114}
-{"id":495, "a": 987, "group": 123}
-{"id":211, "a": 419, "group": 52}
-{"id":554, "a": 1106, "group": 138}
-{"id":62, "a": 122, "group": 15}
-{"id":758, "a": 1514, "group": 189}
-{"id":272, "a": 544, "group": 68}
-{"id":727, "a": 1451, "group": 181}
-{"id":868, "a": 1736, "group": 217}
-{"id":631, "a": 1259, "group": 157}
-{"id":152, "a": 304, "group": 38}
-{"id":669, "a": 1337, "group": 167}
-{"id":840, "a": 1680, "group": 210}
-{"id":983, "a": 1963, "group": 245}
-{"id":595, "a": 1187, "group": 148}
-{"id":685, "a": 1369, "group": 171}
-{"id":441, "a": 881, "group": 110}
-{"id":527, "a": 1051, "group": 131}
-{"id":820, "a": 1640, "group": 205}
-{"id":434, "a": 866, "group": 108}
-{"id":277, "a": 553, "group": 69}
-{"id":90, "a": 178, "group": 22}
-{"id":676, "a": 1352, "group": 169}
-{"id":627, "a": 1251, "group": 156}
-{"id":614, "a": 1226, "group": 153}
-{"id":432, "a": 864, "group": 108}
-{"id":350, "a": 698, "group": 87}
-{"id":247, "a": 491, "group": 61}
-{"id":551, "a": 1099, "group": 137}
-{"id":29, "a": 57, "group": 7}
-{"id":104, "a": 208, "group": 26}
-{"id":801, "a": 1601, "group": 200}
-{"id":589, "a": 1177, "group": 147}
-{"id":409, "a": 817, "group": 102}
-{"id":248, "a": 496, "group": 62}
-{"id":39, "a": 75, "group": 9}
-{"id":953, "a": 1905, "group": 238}
-{"id":438, "a": 874, "group": 109}
-{"id":278, "a": 554, "group": 69}
-{"id":447, "a": 891, "group": 111}
-{"id":16, "a": 32, "group": 4}
-{"id":426, "a": 850, "group": 106}
-{"id":950, "a": 1898, "group": 237}
-{"id":533, "a": 1065, "group": 133}
-{"id":171, "a": 339, "group": 42}
-{"id":482, "a": 962, "group": 120}
-{"id":933, "a": 1865, "group": 233}
-{"id":701, "a": 1401, "group": 175}
-{"id":428, "a": 856, "group": 107}
-{"id":915, "a": 1827, "group": 228}
-{"id":972, "a": 1944, "group": 243}
-{"id":857, "a": 1713, "group": 214}
-{"id":844, "a": 1688, "group": 211}
-{"id":683, "a": 1363, "group": 170}
-{"id":3, "a": 3, "group": 0}
-{"id":65, "a": 129, "group": 16}
-{"id":121, "a": 241, "group": 30}
-{"id":202, "a": 402, "group": 50}
-{"id":753, "a": 1505, "group": 188}
-{"id":369, "a": 737, "group": 92}
-{"id":765, "a": 1529, "group": 191}
-{"id":661, "a": 1321, "group": 165}
-{"id":342, "a": 682, "group": 85}
-{"id":442, "a": 882, "group": 110}
-{"id":592, "a": 1184, "group": 148}
-{"id":717, "a": 1433, "group": 179}
-{"id":608, "a": 1216, "group": 152}
-{"id":72, "a": 144, "group": 18}
-{"id":698, "a": 1394, "group": 174}
-{"id":560, "a": 1120, "group": 140}
-{"id":809, "a": 1617, "group": 202}
-{"id":721, "a": 1441, "group": 180}
-{"id":176, "a": 352, "group": 44}
-{"id":87, "a": 171, "group": 21}
-{"id":10, "a": 18, "group": 2}
-{"id":414, "a": 826, "group": 103}
-{"id":548, "a": 1096, "group": 137}
-{"id":37, "a": 73, "group": 9}
-{"id":183, "a": 363, "group": 45}
-{"id":559, "a": 1115, "group": 139}
-{"id":736, "a": 1472, "group": 184}
-{"id":146, "a": 290, "group": 36}
-{"id":776, "a": 1552, "group": 194}
-{"id":505, "a": 1009, "group": 126}
-{"id":993, "a": 1985, "group": 248}
-{"id":992, "a": 1984, "group": 248}
-{"id":312, "a": 624, "group": 78}
-{"id":166, "a": 330, "group": 41}
-{"id":696, "a": 1392, "group": 174}
-{"id":27, "a": 51, "group": 6}
-{"id":269, "a": 537, "group": 67}
-{"id":139, "a": 275, "group": 34}
-{"id":504, "a": 1008, "group": 126}
-{"id":43, "a": 83, "group": 10}
-{"id":469, "a": 937, "group": 117}
-{"id":832, "a": 1664, "group": 208}
-{"id":380, "a": 760, "group": 95}
-{"id":168, "a": 336, "group": 42}
-{"id":768, "a": 1536, "group": 192}
-{"id":42, "a": 82, "group": 10}
-{"id":489, "a": 977, "group": 122}
-{"id":396, "a": 792, "group": 99}
-{"id":584, "a": 1168, "group": 146}
-{"id":975, "a": 1947, "group": 243}
-{"id":359, "a": 715, "group": 89}
-{"id":220, "a": 440, "group": 55}
-{"id":797, "a": 1593, "group": 199}
-{"id":298, "a": 594, "group": 74}
-{"id":486, "a": 970, "group": 121}
-{"id":997, "a": 1993, "group": 249}
-{"id":790, "a": 1578, "group": 197}
-{"id":453, "a": 905, "group": 113}
-{"id":735, "a": 1467, "group": 183}
-{"id":24, "a": 48, "group": 6}
-{"id":502, "a": 1002, "group": 125}
-{"id":939, "a": 1875, "group": 234}
-{"id":314, "a": 626, "group": 78}
-{"id":457, "a": 913, "group": 114}
-{"id":132, "a": 264, "group": 33}
-{"id":50, "a": 98, "group": 12}
-{"id":454, "a": 906, "group": 113}
-{"id":576, "a": 1152, "group": 144}
-{"id":881, "a": 1761, "group": 220}
-{"id":633, "a": 1265, "group": 158}
-{"id":353, "a": 705, "group": 88}
-{"id":934, "a": 1866, "group": 233}
-{"id":620, "a": 1240, "group": 155}
-{"id":167, "a": 331, "group": 41}
-{"id":579, "a": 1155, "group": 144}
-{"id":99, "a": 195, "group": 24}
-{"id":799, "a": 1595, "group": 199}
-{"id":762, "a": 1522, "group": 190}
-{"id":547, "a": 1091, "group": 136}
-{"id":100, "a": 200, "group": 25}
-{"id":154, "a": 306, "group": 38}
-{"id":778, "a": 1554, "group": 194}
-{"id":151, "a": 299, "group": 37}
-{"id":570, "a": 1138, "group": 142}
-{"id":888, "a": 1776, "group": 222}
-{"id":665, "a": 1329, "group": 166}
-{"id":44, "a": 88, "group": 11}
-{"id":670, "a": 1338, "group": 167}
-{"id":412, "a": 824, "group": 103}
-{"id":984, "a": 1968, "group": 246}
-{"id":659, "a": 1315, "group": 164}
-{"id":307, "a": 611, "group": 76}
-{"id":197, "a": 393, "group": 49}
-{"id":306, "a": 610, "group": 76}
-{"id":468, "a": 936, "group": 117}
-{"id":262, "a": 522, "group": 65}
-{"id":483, "a": 963, "group": 120}
-{"id":610, "a": 1218, "group": 152}
-{"id":507, "a": 1011, "group": 126}
-{"id":609, "a": 1217, "group": 152}

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/oneKeyCount.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/oneKeyCount.json b/exec/java-exec/src/test/resources/window/oneKeyCount.json
deleted file mode 100644
index fa5cd8c..0000000
--- a/exec/java-exec/src/test/resources/window/oneKeyCount.json
+++ /dev/null
@@ -1,43 +0,0 @@
-{
-    head:{
-        type:"APACHE_DRILL_PHYSICAL",
-        version:"1",
-        generator:{
-            type:"manual"
-        }
-    },
-	graph:[
-        {
-                  @id:1,
-                  pop:"fs-scan",
-                  format: {type: "json"},
-                  storage:{type: "file", connection: "file:///"},
-                  files:["#{DATA_FILE}"]
-         },
-        {
-            @id:2,
-            child: 1,
-            pop:"external-sort",
-            orderings: [
-              {expr: "a"}
-            ]
-        },
-        {
-            @id:3,
-            child: 2,
-            pop:"window",
-            within: [
-              { ref: "a", expr: "a" }
-            ],
-            aggregations: [
-              { ref: "cnt", expr:"count(1)" },
-              { ref: "sum", expr:"sum(b)" }
-            ]
-        },
-        {
-            @id: 4,
-            child: 3,
-            pop: "screen"
-        }
-    ]
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/oneKeyCountData.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/oneKeyCountData.json b/exec/java-exec/src/test/resources/window/oneKeyCountData.json
deleted file mode 100644
index 3c0115e..0000000
--- a/exec/java-exec/src/test/resources/window/oneKeyCountData.json
+++ /dev/null
@@ -1,4 +0,0 @@
-{"a": 1, "b": 100}
-                 {"a": 1, "b": 50}
-                 {"a": 2, "b": 25}
-                 {"a": 2, "b": 50}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/oneKeyCountMultiBatch.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/oneKeyCountMultiBatch.json b/exec/java-exec/src/test/resources/window/oneKeyCountMultiBatch.json
deleted file mode 100644
index 09a405c..0000000
--- a/exec/java-exec/src/test/resources/window/oneKeyCountMultiBatch.json
+++ /dev/null
@@ -1,72 +0,0 @@
-{
-  "head" : {
-    "version" : 1,
-    "generator" : {
-      "type" : "DefaultSqlHandler",
-      "info" : ""
-    },
-    "type" : "APACHE_DRILL_PHYSICAL",
-    "options" : [ ],
-    "resultMode" : "EXEC"
-  },
-  "graph" : [{
-                @id:1,
-                pop:"fs-scan",
-                format: {type: "json"},
-                storage:{type: "file", connection: "file:///"},
-                files:["#{DATA_FILE}"]
-             },
-             {
-                @id:2,
-                child: 1,
-                pop:"external-sort",
-                orderings: [
-                    {expr: "group"},
-                    {expr: "a"}
-                ]
-             },
-             {
-                "pop" : "window",
-                "@id" : 3,
-                "child" : 2,
-                "aggregations" : [ {
-                "ref" : "`w0$o0`",
-                "expr" : "count(`a`) "
-             }, {
-                "ref" : "`w0$o1`",
-                "expr" : "$sum0(`a`) "
-             } ],
-                "start" : -9223372036854775808,
-                "end" : -9223372036854775808,
-                "initialAllocation" : 1000000,
-                "maxAllocation" : 10000000000,
-                "withins" : [ {
-                    "ref" : "`group`",
-                    "expr" : "`group`"
-             } ]
-             }, {
-                "pop" : "project",
-                "@id" : 4,
-                "exprs" : [ {
-                    "ref" : "`output`",
-                    "expr" : " ( if (greater_than(`w0$o0`, 0)  ) then (`w0$o1` )  else (NULL)  end  ) "
-                },
-                {
-                    "ref" : "cnt",
-                    "expr": "w0$o0"
-                },
-                {
-                    "ref" : "sum",
-                    "expr": "w0$o1"
-                }],
-                "child" : 3,
-                "initialAllocation" : 1000000,
-                "maxAllocation" : 10000000000
-            }, {
-                "pop" : "screen",
-                "@id" : 5,
-                "child" : 4,
-                "initialAllocation" : 1000000,
-                "maxAllocation" : 10000000000
-            } ]
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/twoKeys.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/twoKeys.json b/exec/java-exec/src/test/resources/window/twoKeys.json
deleted file mode 100644
index f3ef4a5..0000000
--- a/exec/java-exec/src/test/resources/window/twoKeys.json
+++ /dev/null
@@ -1,44 +0,0 @@
-{
-    head:{
-        type:"APACHE_DRILL_PHYSICAL",
-        version:"1",
-        generator:{
-            type:"manual"
-        }
-    },
-	graph:[
-        {
-                  @id:1,
-                  pop:"fs-scan",
-                  format: {type: "json"},
-                  storage:{type: "file", connection: "file:///"},
-                  files:["#{DATA_FILE}"]
-         },
-        {
-            @id:2,
-            child: 1,
-            pop:"external-sort",
-            orderings: [
-              {expr: "a"}
-            ]
-        },
-        {
-            @id:3,
-            child: 2,
-            pop:"window",
-            within: [
-              { ref: "a", expr: "a" },
-              { ref: "b", expr: "b" }
-            ],
-            aggregations: [
-              { ref: "cnt", expr:"count(1)" },
-              { ref: "sum", expr:"sum(c)" }
-            ]
-        },
-        {
-            @id: 4,
-            child: 3,
-            pop: "screen"
-        }
-    ]
-}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/3bccec91/exec/java-exec/src/test/resources/window/twoKeysData.json
----------------------------------------------------------------------
diff --git a/exec/java-exec/src/test/resources/window/twoKeysData.json b/exec/java-exec/src/test/resources/window/twoKeysData.json
deleted file mode 100644
index fd09236..0000000
--- a/exec/java-exec/src/test/resources/window/twoKeysData.json
+++ /dev/null
@@ -1,8 +0,0 @@
-{"a": 1, "b": "group1", "c": 5}
-{"a": 1, "b": "group1", "c": 10}
-{"a": 1, "b": "group2", "c": 15}
-{"a": 1, "b": "group2", "c": 20}
-{"a": 2, "b": "group3", "c": 25}
-{"a": 2, "b": "group3", "c": 30}
-{"a": 2, "b": "group4", "c": 35}
-{"a": 2, "b": "group4", "c": 40}
\ No newline at end of file


Mime
View raw message