You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by sm...@apache.org on 2014/09/25 00:40:20 UTC
[4/7] Patch for DRILL-705
http://git-wip-us.apache.org/repos/asf/incubator-drill/blob/8def6e91/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
new file mode 100644
index 0000000..ad86627
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/mediumData.json
@@ -0,0 +1,1000 @@
+{"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/incubator-drill/blob/8def6e91/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
new file mode 100644
index 0000000..d8965fb
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/oneKeyCount.json
@@ -0,0 +1,43 @@
+{
+ 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:"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/incubator-drill/blob/8def6e91/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
new file mode 100644
index 0000000..3c0115e
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/oneKeyCountData.json
@@ -0,0 +1,4 @@
+{"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/incubator-drill/blob/8def6e91/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
new file mode 100644
index 0000000..069bc1f
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/oneKeyCountMultiBatch.json
@@ -0,0 +1,72 @@
+{
+ "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:"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/incubator-drill/blob/8def6e91/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
new file mode 100644
index 0000000..6282ad2
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/twoKeys.json
@@ -0,0 +1,44 @@
+{
+ 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:"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/incubator-drill/blob/8def6e91/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
new file mode 100644
index 0000000..fd09236
--- /dev/null
+++ b/exec/java-exec/src/test/resources/window/twoKeysData.json
@@ -0,0 +1,8 @@
+{"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
http://git-wip-us.apache.org/repos/asf/incubator-drill/blob/8def6e91/exec/jdbc/src/test/java/org/apache/drill/jdbc/test/TestJdbcDistQuery.java
----------------------------------------------------------------------
diff --git a/exec/jdbc/src/test/java/org/apache/drill/jdbc/test/TestJdbcDistQuery.java b/exec/jdbc/src/test/java/org/apache/drill/jdbc/test/TestJdbcDistQuery.java
index 0b5e6fc..b2f86ea 100644
--- a/exec/jdbc/src/test/java/org/apache/drill/jdbc/test/TestJdbcDistQuery.java
+++ b/exec/jdbc/src/test/java/org/apache/drill/jdbc/test/TestJdbcDistQuery.java
@@ -207,7 +207,7 @@ public class TestJdbcDistQuery extends JdbcTest{
System.out.println();
}
- System.out.println(String.format("Query completed in %d millis.", watch.elapsed(TimeUnit.MILLISECONDS)));
+ System.out.println(String.format("Query completed in %d millis.", watch.elapsedMillis()));
}
System.out.println("\n\n\n");
http://git-wip-us.apache.org/repos/asf/incubator-drill/blob/8def6e91/protocol/src/main/java/org/apache/drill/exec/proto/UserBitShared.java
----------------------------------------------------------------------
diff --git a/protocol/src/main/java/org/apache/drill/exec/proto/UserBitShared.java b/protocol/src/main/java/org/apache/drill/exec/proto/UserBitShared.java
index d5b2352..ed4ae95 100644
--- a/protocol/src/main/java/org/apache/drill/exec/proto/UserBitShared.java
+++ b/protocol/src/main/java/org/apache/drill/exec/proto/UserBitShared.java
@@ -462,6 +462,10 @@ public final class UserBitShared {
* <code>PRODUCER_CONSUMER = 32;</code>
*/
PRODUCER_CONSUMER(32, 32),
+ /**
+ * <code>WINDOW = 33;</code>
+ */
+ WINDOW(33, 33),
;
/**
@@ -596,6 +600,10 @@ public final class UserBitShared {
* <code>PRODUCER_CONSUMER = 32;</code>
*/
public static final int PRODUCER_CONSUMER_VALUE = 32;
+ /**
+ * <code>WINDOW = 33;</code>
+ */
+ public static final int WINDOW_VALUE = 33;
public final int getNumber() { return value; }
@@ -635,6 +643,7 @@ public final class UserBitShared {
case 30: return INFO_SCHEMA_SUB_SCAN;
case 31: return COMPLEX_TO_JSON;
case 32: return PRODUCER_CONSUMER;
+ case 33: return WINDOW;
default: return null;
}
}
@@ -16539,7 +16548,7 @@ public final class UserBitShared {
"\020\001\022\013\n\007LOGICAL\020\002\022\014\n\010PHYSICAL\020\003*k\n\rFragmen" +
"tState\022\013\n\007SENDING\020\000\022\027\n\023AWAITING_ALLOCATI",
"ON\020\001\022\013\n\007RUNNING\020\002\022\014\n\010FINISHED\020\003\022\r\n\tCANCE" +
- "LLED\020\004\022\n\n\006FAILED\020\005*\224\005\n\020CoreOperatorType\022" +
+ "LLED\020\004\022\n\n\006FAILED\020\005*\240\005\n\020CoreOperatorType\022" +
"\021\n\rSINGLE_SENDER\020\000\022\024\n\020BROADCAST_SENDER\020\001" +
"\022\n\n\006FILTER\020\002\022\022\n\016HASH_AGGREGATE\020\003\022\r\n\tHASH" +
"_JOIN\020\004\022\016\n\nMERGE_JOIN\020\005\022\031\n\025HASH_PARTITIO" +
@@ -16556,8 +16565,8 @@ public final class UserBitShared {
"TEXT_WRITER\020\033\022\021\n\rTEXT_SUB_SCAN\020\034\022\021\n\rJSON" +
"_SUB_SCAN\020\035\022\030\n\024INFO_SCHEMA_SUB_SCAN\020\036\022\023\n" +
"\017COMPLEX_TO_JSON\020\037\022\025\n\021PRODUCER_CONSUMER\020" +
- " B.\n\033org.apache.drill.exec.protoB\rUserBi" +
- "tSharedH\001"
+ " \022\n\n\006WINDOW\020!B.\n\033org.apache.drill.exec.p" +
+ "rotoB\rUserBitSharedH\001"
};
com.google.protobuf.Descriptors.FileDescriptor.InternalDescriptorAssigner assigner =
new com.google.protobuf.Descriptors.FileDescriptor.InternalDescriptorAssigner() {
http://git-wip-us.apache.org/repos/asf/incubator-drill/blob/8def6e91/protocol/src/main/java/org/apache/drill/exec/proto/beans/CoreOperatorType.java
----------------------------------------------------------------------
diff --git a/protocol/src/main/java/org/apache/drill/exec/proto/beans/CoreOperatorType.java b/protocol/src/main/java/org/apache/drill/exec/proto/beans/CoreOperatorType.java
index 0c83e06..6e547c1 100644
--- a/protocol/src/main/java/org/apache/drill/exec/proto/beans/CoreOperatorType.java
+++ b/protocol/src/main/java/org/apache/drill/exec/proto/beans/CoreOperatorType.java
@@ -54,7 +54,8 @@ public enum CoreOperatorType implements com.dyuproject.protostuff.EnumLite<CoreO
JSON_SUB_SCAN(29),
INFO_SCHEMA_SUB_SCAN(30),
COMPLEX_TO_JSON(31),
- PRODUCER_CONSUMER(32);
+ PRODUCER_CONSUMER(32),
+ WINDOW(33);
public final int number;
@@ -105,6 +106,7 @@ public enum CoreOperatorType implements com.dyuproject.protostuff.EnumLite<CoreO
case 30: return INFO_SCHEMA_SUB_SCAN;
case 31: return COMPLEX_TO_JSON;
case 32: return PRODUCER_CONSUMER;
+ case 33: return WINDOW;
default: return null;
}
}
http://git-wip-us.apache.org/repos/asf/incubator-drill/blob/8def6e91/protocol/src/main/protobuf/UserBitShared.proto
----------------------------------------------------------------------
diff --git a/protocol/src/main/protobuf/UserBitShared.proto b/protocol/src/main/protobuf/UserBitShared.proto
index 10dce1f..fb1cb77 100644
--- a/protocol/src/main/protobuf/UserBitShared.proto
+++ b/protocol/src/main/protobuf/UserBitShared.proto
@@ -32,7 +32,7 @@ message QueryId {
message DrillPBError{
optional string error_id = 1; // for debug tracing purposes
optional DrillbitEndpoint endpoint = 2;
- optional int32 error_type = 3;
+ optional int32 error_type = 3;
optional string message = 4;
repeated ParsingError parsing_error = 5; //optional, used when providing location of error within a piece of text.
}
@@ -120,13 +120,13 @@ message QueryProfile {
message MajorFragmentProfile {
optional int32 major_fragment_id = 1;
repeated MinorFragmentProfile minor_fragment_profile = 2;
-}
+}
message MinorFragmentProfile {
optional FragmentState state = 1;
- optional DrillPBError error = 2;
+ optional DrillPBError error = 2;
optional int32 minor_fragment_id = 3;
- repeated OperatorProfile operator_profile = 4;
+ repeated OperatorProfile operator_profile = 4;
optional int64 start_time = 5;
optional int64 end_time = 6;
optional int64 memory_used = 7;
@@ -140,7 +140,7 @@ message OperatorProfile {
optional int32 operator_type = 4;
optional int64 setup_nanos = 5;
optional int64 process_nanos = 6;
- optional int64 local_memory_allocated = 7;
+ optional int64 local_memory_allocated = 7;
repeated MetricValue metric = 8;
optional int64 wait_nanos = 9;
}
@@ -200,4 +200,5 @@ enum CoreOperatorType {
INFO_SCHEMA_SUB_SCAN = 30;
COMPLEX_TO_JSON = 31;
PRODUCER_CONSUMER = 32;
+ WINDOW = 33;
}