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
