You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by GitBox <gi...@apache.org> on 2020/12/03 14:10:28 UTC
[GitHub] [kylin] hit-lacus edited a comment on pull request #1485: KYLIN-4818 Calculate cuboid rowcount via HLL
hit-lacus edited a comment on pull request #1485:
URL: https://github.com/apache/kylin/pull/1485#issuecomment-737051004
## Perormance result
#### Duartion Summary
Cuboid need to statistics : 2381 .
Sampling cost : 252 s .
Total duration (Build dictionary, build snapshots, build cuboid.) cost : 11mins, 34sec.
### Logs in Driver
```
2020-12-03 21:50:49,554 INFO [pool-1-thread-1] builder.CreateFlatTable : Create flattable need join lookup tables true, need encode cols false
2020-12-03 21:50:49,574 INFO [pool-1-thread-1] builder.CreateFlatTable : Select model column is USERACTIONSTREAM_0_DOT_0_UID AS `22`,USERACTIONSTREAM_0_DOT_0_ACT_TYPE AS `21`,USERACTIONSTREAM_0_DOT_0_PAGE_ID AS `20`,USERACTIONSTREAM_0_DOT_0_AREA_ID AS `19`,USERACTIONSTREAM_0_DOT_0_LAST_PAGE_ID AS `18`,USERACTIONSTREAM_0_DOT_0_DEVICE_BRAND AS `17`,USERACTIONSTREAM_0_DOT_0_NETWORK_TYPE AS `16`,USERACTIONSTREAM_0_DOT_0_DEVICE_TYPE AS `15`,USERACTIONSTREAM_0_DOT_0_OS_VERSION AS `14`,USERACTIONSTREAM_0_DOT_0_APP_VERSION AS `13`,USERACTIONSTREAM_0_DOT_0_ITEM_TYPE_ID AS `12`,USERACTIONSTREAM_0_DOT_0_REGISTER_DATE AS `11`,USERACTIONSTREAM_0_DOT_0_LAST_LOGIN_DATE AS `10`,USERACTIONSTREAM_0_DOT_0_LOG_TIME AS `9`,USERACTIONSTREAM_0_DOT_0_STRATEGY_ID AS `8`,USERACTIONSTREAM_0_DOT_0_ACTIVITY_ID AS `7`,USERACTIONSTREAM_0_DOT_0_ACTIVITY_TYPE AS `6`,USERACTIONSTREAM_0_DOT_0_ADVERTISEMENT_FLAG AS `5`,USERACTIONSTREAM_0_DOT_0_IP_ADDRESS AS `4`,USERACTIONSTREAM_0_DOT_0_COUNTRY AS `3`,USERACTIONSTRE
AM_0_DOT_0_PROVINCE AS `2`,USERACTIONSTREAM_0_DOT_0_CITY AS `1`,USERACTIONSTREAM_0_DOT_0_PART_DT AS `0`,USERACTIONSTREAM_0_DOT_0_PLAY_TIMES AS `26`,USERACTIONSTREAM_0_DOT_0_ITEM_ID AS `23`,USERACTIONSTREAM_0_DOT_0_PLAY_DURATION AS `25`,USERACTIONSTREAM_0_DOT_0_ACTIVE_MINUTES AS `24`
2020-12-03 21:50:49,575 INFO [pool-1-thread-1] builder.CreateFlatTable : Select model encoding column is
2020-12-03 21:50:49,576 INFO [pool-1-thread-1] builder.CreateFlatTable : Select model all column is USERACTIONSTREAM_0_DOT_0_UID AS `22`,USERACTIONSTREAM_0_DOT_0_ACT_TYPE AS `21`,USERACTIONSTREAM_0_DOT_0_PAGE_ID AS `20`,USERACTIONSTREAM_0_DOT_0_AREA_ID AS `19`,USERACTIONSTREAM_0_DOT_0_LAST_PAGE_ID AS `18`,USERACTIONSTREAM_0_DOT_0_DEVICE_BRAND AS `17`,USERACTIONSTREAM_0_DOT_0_NETWORK_TYPE AS `16`,USERACTIONSTREAM_0_DOT_0_DEVICE_TYPE AS `15`,USERACTIONSTREAM_0_DOT_0_OS_VERSION AS `14`,USERACTIONSTREAM_0_DOT_0_APP_VERSION AS `13`,USERACTIONSTREAM_0_DOT_0_ITEM_TYPE_ID AS `12`,USERACTIONSTREAM_0_DOT_0_REGISTER_DATE AS `11`,USERACTIONSTREAM_0_DOT_0_LAST_LOGIN_DATE AS `10`,USERACTIONSTREAM_0_DOT_0_LOG_TIME AS `9`,USERACTIONSTREAM_0_DOT_0_STRATEGY_ID AS `8`,USERACTIONSTREAM_0_DOT_0_ACTIVITY_ID AS `7`,USERACTIONSTREAM_0_DOT_0_ACTIVITY_TYPE AS `6`,USERACTIONSTREAM_0_DOT_0_ADVERTISEMENT_FLAG AS `5`,USERACTIONSTREAM_0_DOT_0_IP_ADDRESS AS `4`,USERACTIONSTREAM_0_DOT_0_COUNTRY AS `3`,USERACTION
STREAM_0_DOT_0_PROVINCE AS `2`,USERACTIONSTREAM_0_DOT_0_CITY AS `1`,USERACTIONSTREAM_0_DOT_0_PART_DT AS `0`,USERACTIONSTREAM_0_DOT_0_PLAY_TIMES AS `26`,USERACTIONSTREAM_0_DOT_0_ITEM_ID AS `23`,USERACTIONSTREAM_0_DOT_0_PLAY_DURATION AS `25`,USERACTIONSTREAM_0_DOT_0_ACTIVE_MINUTES AS `24`
2020-12-03 21:50:49,590 INFO [pool-1-thread-1] job.ParentSourceChooser : No suitable ready layouts could be reused, generate dataset from flat table.
2020-12-03 21:50:49,591 INFO [pool-1-thread-1] job.ParentSourceChooser : Sampling start ...
2020-12-03 21:50:50,972 INFO [pool-1-thread-1] mapred.FileInputFormat : Total input paths to process : 24
2020-12-03 21:55:02,067 INFO [pool-1-thread-1] job.ParentSourceChooser : Sampling finished and cost 252 s .
2020-12-03 21:55:02,139 INFO [pool-1-thread-1] job.ParentSourceChooser : Cuboid Statistics results : 1048591:179167, 1048593:191579, 1048607:261478, 1048609:199287, 1048623:259034, 1048625:268583, 1048641:1289, 1048655:205314, 1048657:223446, 1048673:251794, 1048689:267818, 1048705:201059, 1048719:262403, 1048721:270392, 1048737:199834, 1048753:268422, 1048769:252124, 1048785:267370, 1048801:249070, 1048817:268062, 1048833:159659, 1048847:256472, 1048849:266972, 1048865:206764, 1048881:268347, 1048897:238557, 1048913:269107, 1048929:254360, 1048945:269881, 1048961:205910, 1048977:269526, 1048993:205376, 1049009:271295, 1049025:251267, 1049041:269411, 1049057:253456, 1049087:267774, 1052161:267188, 1052177:268382, 1052193:269406, 1052225:268221, 1052289:266504, 1052417:267763, 1052657:267362, 1052673:1552, 1052687:205844, 1052689:222110, 1052705:253684, 1052721:264716, 1052737:12078, 1052753:253105, 1052769:261022, 1052785:264981, 1052801:250528, 1052817:268263, 1052833:254792, 1
052849:264450, 1052865:263604, 1052881:271357, 1052897:262973, 1052927:268920, 1052929:239770, 1052945:265786, 1052961:252552, 1052977:268372, 1052993:260679, 1053009:271304, 1053025:263655, 1053057:251329, 1053073:266945, 1053089:255021, 1053121:262906, 1056257:272002, 1056497:269090, 1056769:663, 1056783:200649, 1056785:218240, 1056801:205861, 1056817:272189, 1056833:7691, 1056849:247536, 1056865:252942, 1056881:268334, 1056897:203174, 1056913:265957, 1056929:203717, 1056945:264316, 1056961:253660, 1056977:262236, 1056993:253940, 1057023:268158, 1057025:192278, 1057041:264608, 1057057:205553, 1057073:265200, 1057089:251462, 1057105:268726, 1057121:251096, 1057153:205612, 1057169:266210, 1057185:204080, 1057217:253360, 1060353:266435, 1060593:265964, 1060865:9294, 1060881:247094, 1060897:256020, 1060913:268692, 1060929:58878, 1060945:260831, 1060961:264132, 1060993:253329, 1061009:264125, 1061025:254619, 1061057:263951, 1061121:253860, 1061137:269593, 1061153:252380, 1061185:264641
, 1061249:251732, 1064961:663, 1064975:200649, 1064977:218240, 1064993:205861, 1065009:272189, 1065025:7691, 1065041:247536, 1065057:252942, 1065073:268334, 1065089:203174, 1065105:265957, 1065121:203717, 1065137:264316, 1065153:253660, 1065169:262236, 1065185:253940, 1065215:268158, 1065217:192278, 1065233:264608, 1065249:205553, 1065265:265200, 1065281:251462, 1065297:268726, 1065313:251096, 1065345:205612, 1065361:266210, 1065377:204080, 1065409:253360, 1068545:266435, 1068785:265964, 1069057:9294, 1069073:247094, 1069089:256020, 1069105:268692, 1069121:58878, 1069137:260831, 1069153:264132, 1069185:253329, 1069201:264125, 1069217:254619, 1069249:263951, 1069313:253860, 1069329:269593, 1069345:252380, 1069377:264641, 1069441:251732, 1073153:666, 1073169:217458, 1073185:203865, 1073201:267247, 1073217:7761, 1073233:245298, 1073249:248921, 1073281:206407, 1073297:267673, 1073313:205278, 1073345:250897, 1073409:192394, 1073425:266812, 1073441:204772, 1073473:248702, 1073537:206846,
1077249:9393, 1077265:250878, 1077281:248534, 1077313:59202, 1077377:251671, 1077505:247685, 1077745:268983, 1081345:332, 1081359:188902, 1081361:205471, 1081377:205029, 1081393:266322, 1081409:3878, 1081425:243478, 1081441:251251, 1081457:267439, 1081473:203811, 1081489:267154, 1081505:203666, 1081521:271181, 1081537:255735, 1081553:262540, 1081569:255737, 1081599:266270, 1081601:187161, 1081617:266537, 1081633:206058, 1081649:265166, 1081665:244123, 1081681:269450, 1081697:253725, 1081729:205774, 1081745:266749, 1081761:206612, 1081793:252698, 1084929:272413, 1085169:264258, 1085441:4667, 1085457:245073, 1085473:250751, 1085489:272113, 1085505:34798, 1085521:261468, 1085537:266012, 1085569:250004, 1085585:268416, 1085601:251666, 1085633:264600, 1085697:242923, 1085713:274796, 1085729:253835, 1085761:264506, 1085825:250616, 1089537:1216, 1089553:223804, 1089569:202629, 1089585:267903, 1089601:14100, 1089617:252647, 1089633:253539, 1089665:203379, 1089681:268423, 1089697:206910, 108
9729:255999, 1089793:194941, 1089809:268701, 1089825:201251, 1089857:249867, 1089921:204943, 1093633:17005, 1093649:253801, 1093665:253374, 1093697:80167, 1093761:251893, 1093889:250195, 1094129:271178, 1097729:1216, 1097745:223804, 1097761:202629, 1097777:267903, 1097793:14100, 1097809:252647, 1097825:253539, 1097857:203379, 1097873:268423, 1097889:206910, 1097921:255999, 1097985:194941, 1098001:268701, 1098017:201251, 1098049:249867, 1098113:204943, 1101825:17005, 1101841:253801, 1101857:253374, 1101889:80167, 1101953:251893, 1102081:250195, 1102321:271178, 1105921:1233, 1105937:225817, 1105953:200645, 1105985:14509, 1106049:205051, 1106177:194308, 1106417:269850, 1110017:17563, 1110257:269029, 1110527:266738, 1114097:265682, 1114113:326, 1114127:180001, 1114129:197729, 1114145:205409, 1114161:265218, 1114177:3864, 1114193:240381, 1114209:250654, 1114225:267640, 1114241:202410, 1114257:268256, 1114273:201724, 1114289:266216, 1114305:249773, 1114321:267053, 1114337:254773, 1114367:
265262, 1114369:186060, 1114385:267717, 1114401:202733, 1114417:271652, 1114433:244577, 1114449:265698, 1114465:253095, 1114497:204815, 1114513:265412, 1114529:204962, 1114561:251991, 1117697:268453, 1117937:270971, 1118209:4657, 1118225:240384, 1118241:255379, 1118257:266032, 1118273:35612, 1118289:259703, 1118305:265120, 1118337:253551, 1118353:269897, 1118369:253776, 1118401:264834, 1118465:244898, 1118481:269878, 1118497:252122, 1118529:260117, 1118593:253361, 1122305:1175, 1122321:218594, 1122337:202463, 1122353:268833, 1122369:13837, 1122385:251315, 1122401:253491, 1122433:202818, 1122449:268569, 1122465:203219, 1122497:248140, 1122561:192885, 1122577:267859, 1122593:204352, 1122625:245150, 1122689:204754, 1126401:16684, 1126417:250595, 1126433:256058, 1126465:76991, 1126529:251638, 1126657:249803, 1126897:270798, 1130497:1175, 1130513:218594, 1130529:202463, 1130545:268833, 1130561:13837, 1130577:251315, 1130593:253491, 1130625:202818, 1130641:268569, 1130657:203219, 1130689:
248140, 1130753:192885, 1130769:267859, 1130785:204352, 1130817:245150, 1130881:204754, 1134593:16684, 1134609:250595, 1134625:256058, 1134657:76991, 1134721:251638, 1134849:249803, 1135089:270798, 1138689:1182, 1138705:217123, 1138721:202606, 1138753:13945, 1138817:205868, 1138945:194417, 1139185:267754, 1142785:16949, 1143025:269742, 1143295:269218, 1146865:270136, 1146881:538, 1146897:206397, 1146913:201257, 1146929:265439, 1146945:6369, 1146961:244634, 1146977:254655, 1147009:201988, 1147025:266505, 1147041:203627, 1147073:250667, 1147137:189171, 1147153:268426, 1147169:201660, 1147201:245126, 1147265:205231, 1150977:7672, 1150993:241487, 1151009:254838, 1151041:52280, 1151105:250414, 1151233:248740, 1151473:272905, 1155073:2236, 1155089:223149, 1155105:206374, 1155137:25745, 1155201:203573, 1155329:195173, 1155569:266393, 1159169:30484, 1159409:263157, 1163265:2236, 1163281:223149, 1163297:206374, 1163329:25745, 1163393:203573, 1163521:195173, 1163761:266393, 1167361:30484, 116
7601:263157, 1171457:2275, 1171697:269533, 1179649:322, 1179663:177915, 1179665:198543, 1179681:205391, 1179697:268227, 1179713:3785, 1179729:243614, 1179745:247381, 1179761:267391, 1179777:204018, 1179793:267979, 1179809:203500, 1179825:268688, 1179841:253294, 1179857:269690, 1179873:253562, 1179903:268969, 1179905:185532, 1179921:269138, 1179937:205865, 1179953:269280, 1179969:244742, 1179985:264956, 1180001:253328, 1180033:206548, 1180049:266592, 1180065:207444, 1180097:253149, 1183233:268449, 1183473:263596, 1183745:4575, 1183761:242780, 1183777:254502, 1183793:265917, 1183809:34631, 1183825:260953, 1183841:261344, 1183873:252066, 1183889:270708, 1183905:248564, 1183937:262827, 1184001:246818, 1184017:267277, 1184033:253563, 1184065:261021, 1184129:253524, 1187841:1177, 1187857:219950, 1187873:203091, 1187889:268863, 1187905:13982, 1187921:251893, 1187937:254068, 1187969:203046, 1187985:266340, 1188001:203157, 1188033:254082, 1188097:195002, 1188113:268530, 1188129:205540, 11881
61:245609, 1188225:205424, 1191937:17068, 1191953:250933, 1191969:253433, 1192001:78552, 1192065:249595, 1192193:249618, 1192433:267384, 1196033:1177, 1196049:219950, 1196065:203091, 1196081:268863, 1196097:13982, 1196113:251893, 1196129:254068, 1196161:203046, 1196177:266340, 1196193:203157, 1196225:254082, 1196289:195002, 1196305:268530, 1196321:205540, 1196353:245609, 1196417:205424, 1200129:17068, 1200145:250933, 1200161:253433, 1200193:78552, 1200257:249595, 1200385:249618, 1200625:267384, 1204225:1186, 1204241:217919, 1204257:201932, 1204289:13947, 1204353:206232, 1204481:195127, 1204721:267664, 1208321:16901, 1208561:265994, 1208831:270484, 1212401:267031, 1212417:537, 1212433:203943, 1212449:203709, 1212465:268983, 1212481:6373, 1212497:243865, 1212513:251648, 1212545:203305, 1212561:267841, 1212577:203796, 1212609:252064, 1212673:191488, 1212689:270884, 1212705:203168, 1212737:247612, 1212801:202728, 1216513:7729, 1216529:244989, 1216545:254239, 1216577:51810, 1216641:25427
3, 1216769:248557, 1217009:266960, 1220609:2236, 1220625:224818, 1220641:204374, 1220673:25851, 1220737:204136, 1220865:197295, 1221105:268541, 1224705:30698, 1224945:266661, 1228801:2236, 1228817:224818, 1228833:204374, 1228865:25851, 1228929:204136, 1229057:197295, 1229297:268541, 1232897:30698, 1233137:266661, 1236993:2273, 1237233:269015, 1245185:325, 1245201:199117, 1245217:201470, 1245233:266986, 1245249:3831, 1245265:237984, 1245281:254797, 1245313:204072, 1245329:265516, 1245345:203819, 1245377:252841, 1245441:186314, 1245457:267496, 1245473:205600, 1245505:244630, 1245569:204678, 1249281:4644, 1249297:239331, 1249313:252660, 1249345:34983, 1249409:251629, 1249537:249923, 1249777:266578, 1253377:1164, 1253393:219063, 1253409:204605, 1253441:13553, 1253505:204377, 1253633:195042, 1253873:262913, 1257473:16458, 1257713:271333, 1261569:1164, 1261585:219063, 1261601:204605, 1261633:13553, 1261697:204377, 1261825:195042, 1262065:262913, 1265665:16458, 1265905:271333, 1269761:1181
, 1270001:267111, 1277953:537, 1277969:206623, 1277985:203551, 1278017:6312, 1278081:203678, 1278209:188846, 1278449:268702, 1282049:7632, 1282289:271143, 1286145:2213, 1286385:268894, 1294337:2213, 1294577:268894, 1310721:5228, 1310735:206062, 1310737:223718, 1310753:255798, 1310769:268284, 1310785:55831, 1310801:249523, 1310817:263491, 1310833:268428, 1310849:256747, 1310865:272067, 1310881:254359, 1310897:264582, 1310913:264898, 1310929:266012, 1310945:259821, 1310975:265343, 1310977:238836, 1310993:269546, 1311009:251689, 1311025:267811, 1311041:255526, 1311057:266554, 1311073:263287, 1311105:253687, 1311121:264409, 1311137:251064, 1311169:261995, 1314305:266363, 1314545:267917, 1314817:64051, 1314833:251291, 1314849:260196, 1314865:265298, 1314881:145441, 1314897:261285, 1314913:265453, 1314945:264205, 1314961:271878, 1314977:264323, 1315009:267670, 1315073:259576, 1315089:270478, 1315105:265667, 1315137:263177, 1315201:263045, 1318913:30600, 1318929:248864, 1318945:252100, 131
8961:266529, 1318977:131464, 1318993:261978, 1319009:259427, 1319041:252595, 1319057:269559, 1319073:254274, 1319105:264969, 1319169:246781, 1319185:269500, 1319201:256782, 1319233:264176, 1319297:252911, 1323009:137760, 1323025:261018, 1323041:261899, 1323073:174544, 1323137:263834, 1323265:260625, 1323505:268260, 1327105:30600, 1327121:248864, 1327137:252100, 1327153:266529, 1327169:131464, 1327185:261978, 1327201:259427, 1327233:252595, 1327249:269559, 1327265:254274, 1327297:264969, 1327361:246781, 1327377:269500, 1327393:256782, 1327425:264176, 1327489:252911, 1331201:137760, 1331217:261018, 1331233:261899, 1331265:174544, 1331329:263834, 1331457:260625, 1331697:268260, 1335297:31080, 1335313:247633, 1335329:250837, 1335361:131142, 1335425:253493, 1335553:249404, 1335793:264267, 1339393:137745, 1339633:270058, 1339903:264772, 1343473:269029, 1343489:15756, 1343505:248746, 1343521:251671, 1343537:269531, 1343553:107101, 1343569:262075, 1343585:264626, 1343617:254939, 1343633:268
176, 1343649:253981, 1343681:262590, 1343745:248864, 1343761:267677, 1343777:253819, 1343809:264090, 1343873:251289, 1347585:115716, 1347601:260606, 1347617:261666, 1347649:165906, 1347713:268335, 1347841:262449, 1348081:265675, 1351681:49071, 1351697:252363, 1351713:252117, 1351745:142394, 1351809:255900, 1351937:249276, 1352177:269309, 1355777:145929, 1356017:267674, 1359873:49071, 1359889:252363, 1359905:252117, 1359937:142394, 1360001:255900, 1360129:249276, 1360369:269309, 1363969:145929, 1364209:267674, 1368065:49765, 1368305:265385, 1376257:15842, 1376273:237171, 1376289:255711, 1376305:268914, 1376321:107599, 1376337:257473, 1376353:267084, 1376385:251774, 1376401:268856, 1376417:256130, 1376449:262481, 1376513:247362, 1376529:268810, 1376545:252458, 1376577:260442, 1376641:255682, 1380353:115529, 1380369:257916, 1380385:263379, 1380417:166735, 1380481:261448, 1380609:258477, 1380849:269253, 1384449:48575, 1384465:253239, 1384481:254941, 1384513:142000, 1384577:255620, 13847
05:253013, 1384945:267950, 1388545:144769, 1388785:267507, 1392641:48575, 1392657:253239, 1392673:254941, 1392705:142000, 1392769:255620, 1392897:253013, 1393137:267950, 1396737:144769, 1396977:267507, 1400833:48795, 1401073:266985, 1409025:25798, 1409041:242004, 1409057:252712, 1409089:123436, 1409153:253097, 1409281:245289, 1409521:270477, 1413121:132584, 1413361:268961, 1417217:67314, 1417457:270219, 1425409:67314, 1425649:270219, 1441793:15566, 1441809:239335, 1441825:251178, 1441841:264211, 1441857:106224, 1441873:256999, 1441889:264443, 1441921:251058, 1441937:270745, 1441953:251959, 1441985:263201, 1442049:248235, 1442065:269183, 1442081:255637, 1442113:258200, 1442177:255048, 1445889:116123, 1445905:258046, 1445921:263010, 1445953:169601, 1446017:266132, 1446145:261994, 1446385:269567, 1449985:49006, 1450001:251287, 1450017:253121, 1450049:138708, 1450113:255782, 1450241:249695, 1450481:265559, 1454081:146776, 1454321:269921, 1458177:49006, 1458193:251287, 1458209:253121, 14
58241:138708, 1458305:255782, 1458433:249695, 1458673:265559, 1462273:146776, 1462513:269921, 1466369:49241, 1466609:265019, 1474561:25856, 1474577:245774, 1474593:255508, 1474625:125149, 1474689:249254, 1474817:244473, 1475057:268188, 1478657:133799, 1478897:266757, 1482753:67883, 1482993:267969, 1490945:67883, 1491185:267969, 1507329:15868, 1507345:241919, 1507361:254286, 1507393:107829, 1507457:251422, 1507585:246860, 1507825:266470, 1511425:115753, 1511665:265590, 1515521:48462, 1515761:269281, 1523713:48462, 1523953:269281, 1540097:26081, 1540337:264356, 1569265:268643, 1572865:81085, 1572879:202368, 1572881:220904, 1572897:255230, 1572913:267507, 1572929:161804, 1572945:252123, 1572961:264839, 1572977:264875, 1572993:252814, 1573009:270742, 1573025:256635, 1573041:266139, 1573057:265058, 1573073:262324, 1573089:263541, 1573119:264815, 1573121:240787, 1573137:267149, 1573153:252189, 1573169:269318, 1573185:258993, 1573201:266228, 1573217:262354, 1573249:254388, 1573265:267138,
1573281:255256, 1573313:262892, 1576449:266690, 1576689:267229, 1576961:166540, 1576977:248341, 1576993:261996, 1577009:266719, 1577025:178185, 1577041:260115, 1577057:264505, 1577089:264214, 1577105:267968, 1577121:261846, 1577153:264345, 1577217:256044, 1577233:267764, 1577249:262107, 1577281:264255, 1577345:268157, 1581057:146336, 1581073:250081, 1581089:255068, 1581105:266248, 1581121:174692, 1581137:262315, 1581153:263695, 1581185:256862, 1581201:265479, 1581217:257038, 1581249:261585, 1581313:252657, 1581329:271744, 1581345:253984, 1581377:260685, 1581441:251955, 1585153:175582, 1585169:259096, 1585185:265800, 1585217:182006, 1585281:265607, 1585409:262614, 1585649:266993, 1589249:146336, 1589265:250081, 1589281:255068, 1589297:266248, 1589313:174692, 1589329:262315, 1589345:263695, 1589377:256862, 1589393:265479, 1589409:257038, 1589441:261585, 1589505:252657, 1589521:271744, 1589537:253984, 1589569:260685, 1589633:251955, 1593345:175582, 1593361:259096, 1593377:265800, 15934
09:182006, 1593473:265607, 1593601:262614, 1593841:266993, 1597441:146694, 1597457:248577, 1597473:255896, 1597505:176757, 1597569:255636, 1597697:248443, 1597937:270529, 1601537:176477, 1601777:271552, 1602047:265613, 1605617:264234, 1605633:129833, 1605649:247014, 1605665:250963, 1605681:268133, 1605697:175079, 1605713:260763, 1605729:268433, 1605761:249818, 1605777:265541, 1605793:254343, 1605825:263720, 1605889:249332, 1605905:266795, 1605921:253592, 1605953:260990, 1606017:251497, 1609729:173791, 1609745:259107, 1609761:264407, 1609793:178585, 1609857:261771, 1609985:261119, 1610225:267303, 1613825:153152, 1613841:249671, 1613857:254023, 1613889:178656, 1613953:250974, 1614081:253511, 1614321:270044, 1617921:177061, 1618161:266711, 1622017:153152, 1622033:249671, 1622049:254023, 1622081:178656, 1622145:250974, 1622273:253511, 1622513:270044, 1626113:177061, 1626353:266711, 1630209:154168, 1630449:271193, 1638401:129590, 1638417:239488, 1638433:254792, 1638449:271421, 1638465:17
5144, 1638481:259425, 1638497:262439, 1638529:253992, 1638545:264986, 1638561:250814, 1638593:264812, 1638657:248474, 1638673:266896, 1638689:255465, 1638721:263189, 1638785:252140, 1642497:176227, 1642513:254363, 1642529:265726, 1642561:178797, 1642625:264510, 1642753:268379, 1642993:265911, 1646593:152637, 1646609:250557, 1646625:256499, 1646657:176668, 1646721:253191, 1646849:246834, 1647089:264831, 1650689:176455, 1650929:270732, 1654785:152637, 1654801:250557, 1654817:256499, 1654849:176668, 1654913:253191, 1655041:246834, 1655281:264831, 1658881:176455, 1659121:270732, 1662977:151169, 1663217:266889, 1671169:143775, 1671185:247535, 1671201:253789, 1671233:176853, 1671297:253749, 1671425:247568, 1671665:267080, 1675265:175275, 1675505:267160, 1679361:157996, 1679601:268125, 1687553:157996, 1687793:268125, 1703937:129062, 1703953:240646, 1703969:253843, 1703985:265426, 1704001:173284, 1704017:259403, 1704033:264018, 1704065:253468, 1704081:269808, 1704097:250845, 1704129:268745,
1704193:248691, 1704209:267612, 1704225:254655, 1704257:260307, 1704321:254524, 1708033:171838, 1708049:256307, 1708065:265187, 1708097:179711, 1708161:260039, 1708289:263153, 1708529:267735, 1712129:152249, 1712145:250498, 1712161:254271, 1712193:176583, 1712257:253869, 1712385:249047, 1712625:266497, 1716225:176871, 1716465:271084, 1720321:152249, 1720337:250498, 1720353:254271, 1720385:176583, 1720449:253869, 1720577:249047, 1720817:266497, 1724417:176871, 1724657:271084, 1728513:152061, 1728753:272300, 1736705:141572, 1736721:246943, 1736737:252831, 1736769:177124, 1736833:256135, 1736961:248933, 1737201:264311, 1740801:175209, 1741041:263901, 1744897:157048, 1745137:264049, 1753089:157048, 1753329:264049, 1769473:128806, 1769489:239842, 1769505:255810, 1769537:175792, 1769601:255552, 1769729:250121, 1769969:269786, 1773569:174134, 1773809:271620, 1777665:153982, 1777905:265881, 1785857:153982, 1786097:265881, 1802241:141519, 1802481:268937, 1831409:266288, 1835009:177831, 1835
025:252153, 1835041:265389, 1835057:265152, 1835073:178456, 1835089:262115, 1835105:264824, 1835137:259692, 1835153:263901, 1835169:265812, 1835201:268422, 1835265:258210, 1835281:270209, 1835297:265200, 1835329:262798, 1835393:267605, 1839105:179015, 1839121:263237, 1839137:266010, 1839169:178730, 1839233:265156, 1839361:264370, 1839601:270393, 1843201:178774, 1843217:263039, 1843233:263547, 1843265:182533, 1843329:264504, 1843457:262424, 1843697:264430, 1847297:180864, 1847537:269825, 1851393:178774, 1851409:263039, 1851425:263547, 1851457:182533, 1851521:264504, 1851649:262424, 1851889:264430, 1855489:180864, 1855729:269825, 1859585:178901, 1859825:265761, 1867777:179279, 1867793:260619, 1867809:263764, 1867841:181458, 1867905:260560, 1868033:267347, 1868273:269279, 1871873:180233, 1872113:268075, 1875969:181003, 1876209:266152, 1884161:181003, 1884401:266152, 1900545:180377, 1900561:260491, 1900577:260932, 1900609:181951, 1900673:269632, 1900801:262576, 1901041:266322, 1904641:1
79526, 1904881:267538, 1908737:180764, 1908977:269613, 1916929:180764, 1917169:269613, 1933313:179411, 1933553:269299, 1962481:269851, 1966081:177075, 1966097:255731, 1966113:261129, 1966145:181106, 1966209:264790, 1966337:261557, 1966577:266168, 1970177:178784, 1970417:266015, 1974273:180304, 1974513:268131, 1982465:180304, 1982705:268131, 1998849:178055, 1999089:264318, 2028017:268144, 2031617:179127, 2031857:267573, 2060785:266741, 2093567:270730, 2097137:267472, 3145729:552, 3145743:197336, 3145745:216957, 3145761:201764, 3145777:268637, 3145793:6483, 3145809:245851, 3145825:253851, 3145841:272677, 3145857:203330, 3145873:265814, 3145889:204655, 3145905:270405, 3145921:251531, 3145937:267130, 3145953:252290, 3145983:266118, 3145985:187632, 3146001:268978, 3146017:202816, 3146033:266196, 3146049:249074, 3146065:267691, 3146081:251916, 3146113:206964, 3146129:269846, 3146145:204357, 3146177:251793, 3149313:264678, 3149553:270022, 3149825:7810, 3149841:247608, 3149857:250308, 31498
73:264370, 3149889:52761, 3149905:260840, 3149921:264757, 3149953:254841, 3149969:268374, 3149985:254601, 3150017:260806, 3150081:248621, 3150097:269501, 3150113:252085, 3150145:259540, 3150209:251736, 3153921:2306, 3153937:229438, 3153953:206555, 3153969:263812, 3153985:25973, 3154001:254264, 3154017:253711, 3154049:205998, 3154065:268707, 3154081:202909, 3154113:250270, 3154177:197729, 3154193:269110, 3154209:205588, 3154241:247050, 3154305:207865, 3158017:30665, 3158033:248069, 3158049:256133, 3158081:95261, 3158145:251704, 3158273:248674, 3158513:267123, 3162113:2306, 3162129:229438, 3162145:206555, 3162161:263812, 3162177:25973, 3162193:254264, 3162209:253711, 3162241:205998, 3162257:268707, 3162273:202909, 3162305:250270, 3162369:197729, 3162385:269110, 3162401:205588, 3162433:247050, 3162497:207865, 3166209:30665, 3166225:248069, 3166241:256133, 3166273:95261, 3166337:251704, 3166465:248674, 3166705:267123, 3170305:2325, 3170321:228881, 3170337:204203, 3170369:25944, 3170433:
204369, 3170561:195799, 3170801:266142, 3174401:30907, 3174641:265548, 3174911:270092, 3178481:271666, 3178497:552, 3178513:216205, 3178529:204812, 3178545:271076, 3178561:6401, 3178577:249019, 3178593:252474, 3178625:204989, 3178641:267841, 3178657:204377, 3178689:254056, 3178753:190704, 3178769:270194, 3178785:205125, 3178817:249600, 3178881:204942, 3182593:7752, 3182609:248649, 3182625:252345, 3182657:52357, 3182721:254110, 3182849:248633, 3183089:270747, 3186689:2316, 3186705:229564, 3186721:204670, 3186753:26041, 3186817:202726, 3186945:194750, 3187185:266942, 3190785:31167, 3191025:267559, 3194881:2316, 3194897:229564, 3194913:204670, 3194945:26041, 3195009:202726, 3195137:194750, 3195377:266942, 3198977:31167, 3199217:267559, 3203073:2335, 3203313:269130, 3211265:966, 3211281:212345, 3211297:205041, 3211313:269064, 3211329:11517, 3211345:247492, 3211361:256766, 3211393:201113, 3211409:268389, 3211425:204235, 3211457:252484, 3211521:195108, 3211537:266443, 3211553:202402, 3211
585:246323, 3211649:209020, 3215361:13893, 3215377:248786, 3215393:252205, 3215425:71989, 3215489:254626, 3215617:249478, 3215857:269135, 3219457:4386, 3219473:228538, 3219489:204037, 3219521:43463, 3219585:201565, 3219713:195363, 3219953:268801, 3223553:49096, 3223793:268068, 3227649:4386, 3227665:228538, 3227681:204037, 3227713:43463, 3227777:201565, 3227905:195363, 3228145:268801, 3231745:49096, 3231985:268068, 3235841:4458, 3236081:269116, 3244033:962, 3244049:213726, 3244065:205670, 3244097:11399, 3244161:205037, 3244289:194834, 3244529:268600, 3248129:13814, 3248369:264689, 3252225:4243, 3252465:267495, 3260417:4243, 3260657:267495, 3276801:958, 3276817:216692, 3276833:203188, 3276849:271435, 3276865:11291, 3276881:250999, 3276897:252428, 3276929:203888, 3276945:267578, 3276961:204678, 3276993:251082, 3277057:194604, 3277073:266033, 3277089:204186, 3277121:247940, 3277185:206084, 3280897:13671, 3280913:248134, 3280929:250283, 3280961:71302, 3281025:251258, 3281153:248553, 3281
393:268202, 3284993:4370, 3285009:225441, 3285025:203462, 3285057:42516, 3285121:205660, 3285249:195737, 3285489:267551, 3289089:48433, 3289329:267168, 3293185:4370, 3293201:225441, 3293217:203462, 3293249:42516, 3293313:205660, 3293441:195737, 3293681:267551, 3297281:48433, 3297521:267168, 3301377:4395, 3301617:270113, 3309569:952, 3309585:217866, 3309601:203492, 3309633:11361, 3309697:204824, 3309825:194916, 3310065:271218, 3313665:13717, 3313905:268069, 3317761:4361, 3318001:267643, 3325953:4361, 3326193:267643, 3342337:954, 3342353:217138, 3342369:200036, 3342401:11287, 3342465:204197, 3342593:193726, 3342833:268061, 3346433:13657, 3346673:266604, 3350529:4310, 3350769:270848, 3358721:4310, 3358961:270848, 3375105:951, 3375345:266909, 3404273:268499, 3407873:25876, 3407889:248708, 3407905:255864, 3407921:270666, 3407937:125810, 3407953:260657, 3407969:268290, 3408001:256278, 3408017:263505, 3408033:252302, 3408065:264162, 3408129:249890, 3408145:272156, 3408161:254806, 3408193:2
63510, 3408257:255435, 3411969:133560, 3411985:262386, 3412001:263875, 3412033:170953, 3412097:263863, 3412225:263335, 3412465:265592, 3416065:68420, 3416081:249000, 3416097:255382, 3416129:147560, 3416193:251622, 3416321:249336, 3416561:269293, 3420161:153057, 3420401:263947, 3424257:68420, 3424273:249000, 3424289:255382, 3424321:147560, 3424385:251622, 3424513:249336, 3424753:269293, 3428353:153057, 3428593:263947, 3432449:68153, 3432689:272282, 3440641:25697, 3440657:246153, 3440673:252125, 3440705:126127, 3440769:249233, 3440897:249420, 3441137:268666, 3444737:131987, 3444977:270726, 3448833:68266, 3449073:267771, 3457025:68266, 3457265:267771, 3473409:42651, 3473425:250281, 3473441:253031, 3473473:139487, 3473537:251263, 3473665:250283, 3473905:266418, 3477505:143475, 3477745:271073, 3481601:81517, 3481841:272591, 3489793:81517, 3490033:272591, 3506177:41303, 3506417:269139, 3535345:267082, 3538945:42185, 3538961:251742, 3538977:250579, 3539009:138491, 3539073:250261, 3539201:2
51217, 3539441:265807, 3543041:142594, 3543281:268159, 3547137:82918, 3547377:268230, 3555329:82918, 3555569:268230, 3571713:42159, 3571953:270431, 3600881:264774, 3604481:42787, 3604721:268362, 3633649:264845, 3666431:265631, 3670001:269013, 3670017:143235, 3670033:248967, 3670049:254743, 3670065:268512, 3670081:175542, 3670097:263434, 3670113:263876, 3670145:256486, 3670161:267342, 3670177:254473, 3670209:264957, 3670273:249416, 3670289:269521, 3670305:252806, 3670337:264013, 3670401:256991, 3674113:175700, 3674129:264214, 3674145:260377, 3674177:179718, 3674241:265553, 3674369:264501, 3674609:265505, 3678209:160488, 3678225:251631, 3678241:253368, 3678273:181839, 3678337:255528, 3678465:250100, 3678705:271658, 3682305:180953, 3682545:267969, 3686401:160488, 3686417:251631, 3686433:253368, 3686465:181839, 3686529:255528, 3686657:250100, 3686897:271658, 3690497:180953, 3690737:267969, 3694593:157818, 3694833:270629, 3702785:143659, 3702801:251206, 3702817:253026, 3702849:177370, 37
02913:255616, 3703041:249273, 3703281:265138, 3706881:180123, 3707121:268453, 3710977:157441, 3711217:268240, 3719169:157441, 3719409:268240, 3735553:150970, 3735569:251174, 3735585:252849, 3735617:174410, 3735681:252121, 3735809:247816, 3736049:269496, 3739649:177066, 3739889:265210, 3743745:160559, 3743985:265957, 3751937:160559, 3752177:265957, 3768321:150147, 3768561:266356, 3797489:268500, 3801089:150880, 3801105:250080, 3801121:251961, 3801153:174362, 3801217:252038, 3801345:249693, 3801585:268743, 3805185:177109, 3805425:269495, 3809281:159796, 3809521:270483, 3817473:159796, 3817713:270483, 3833857:148759, 3834097:267261, 3863025:265357, 3866625:151187, 3866865:266038, 3895793:266749, 3932161:177869, 3932177:259207, 3932193:260677, 3932225:181909, 3932289:263530, 3932417:261231, 3932657:269756, 3936257:179117, 3936497:270822, 3940353:183091, 3940593:266264, 3948545:183091, 3948785:266264, 3964929:179883, 3965169:271412, 3994097:269700, 3997697:178825, 3997937:267820, 4026865
:270976, 4063233:177478, 4063473:268977, 4092401:272716, 5242881:201265, 5242895:264561, 5242897:268611, 5242913:267072, 5242929:264998, 5242945:252853, 5242961:266361, 5242977:264518, 5242993:268970, 5243009:267071, 5243025:269880, 5243041:267936, 5243057:268287, 5243073:272660, 5243089:269789, 5243105:268604, 5243135:267170, 5243137:265625, 5243153:272097, 5243169:271599, 5243185:266184, 5243201:268815, 5243217:266550, 5243233:268729, 5243265:269349, 5243281:268913, 5243297:269464, 5243329:267998, 5246465:270134, 5246705:264326, 5246977:253845, 5246993:268594, 5247009:269294, 5247025:266552, 5247041:261590, 5247057:271015, 5247073:267612, 5247105:270390, 5247121:267479, 5247137:268752, 5247169:270410, 5247233:267062, 5247249:268046, 5247265:268673, 5247297:268479, 5247361:265595, 5251073:244096, 5251089:264639, 5251105:268532, 5251121:267728, 5251137:263367, 5251153:267584, 5251169:267231, 5251201:269298, 5251217:266707, 5251233:265402, 5251265:264085, 5251329:267764, 5251345:2713
94, 5251361:267506, 5251393:266202, 5251457:268064, 5255169:264327, 5255185:268159, 5255201:270615, 5255233:269153, 5255297:266939, 5255425:264992, 5255665:269461, 5259265:244096, 5259281:264639, 5259297:268532, 5259313:267728, 5259329:263367, 5259345:267584, 5259361:267231, 5259393:269298, 5259409:266707, 5259425:265402, 5259457:264085, 5259521:267764, 5259537:271394, 5259553:267506, 5259585:266202, 5259649:268064, 5263361:264327, 5263377:268159, 5263393:270615, 5263425:269153, 5263489:266939, 5263617:264992, 5263857:269461, 5267457:244043, 5267473:270078, 5267489:267994, 5267521:264812, 5267585:264324, 5267713:268387, 5267953:265433, 5271553:264411, 5271793:267438, 5272063:267033, 5275633:269324, 5275649:224847, 5275665:267512, 5275681:265340, 5275697:265654, 5275713:260934, 5275729:264436, 5275745:266996, 5275777:270191, 5275793:265957, 5275809:262433, 5275841:264151, 5275905:268876, 5275921:267212, 5275937:273122, 5275969:268233, 5276033:264605, 5279745:255101, 5279761:269314, 5
279777:266892, 5279809:267109, 5279873:267316, 5280001:269725, 5280241:265419, 5283841:252061, 5283857:269036, 5283873:268457, 5283905:268076, 5283969:268949, 5284097:270564, 5284337:268128, 5287937:261697, 5288177:264345, 5292033:252061, 5292049:269036, 5292065:268457, 5292097:268076, 5292161:268949, 5292289:270564, 5292529:268128, 5296129:261697, 5296369:264345, 5300225:253376, 5300465:271082, 5308417:215312, 5308433:266548, 5308449:265186, 5308465:267632, 5308481:252056, 5308497:268375, 5308513:268081, 5308545:272851, 5308561:269438, 5308577:269180, 5308609:267351, 5308673:270666, 5308689:265299, 5308705:268235, 5308737:266513, 5308801:268349, 5312513:250587, 5312529:270040, 5312545:266788, 5312577:263028, 5312641:266821, 5312769:270722, 5313009:266323, 5316609:249637, 5316625:273821, 5316641:267703, 5316673:261531, 5316737:268434, 5316865:264233, 5317105:265586, 5320705:267059, 5320945:271176, 5324801:249637, 5324817:273821, 5324833:267703, 5324865:261531, 5324929:268434, 532505
7:264233, 5325297:265586, 5328897:267059, 5329137:271176, 5332993:248494, 5333233:264362, 5341185:230093, 5341201:270801, 5341217:265001, 5341249:260732, 5341313:269492, 5341441:270093, 5341681:266109, 5345281:256837, 5345521:269959, 5349377:258238, 5349617:269306, 5357569:258238, 5357809:269306, 5373953:214530, 5373969:268283, 5373985:268344, 5374001:271249, 5374017:251984, 5374033:269163, 5374049:265879, 5374081:266431, 5374097:271323, 5374113:269259, 5374145:270750, 5374209:267804, 5374225:267829, 5374241:264956, 5374273:267603, 5374337:271201, 5378049:252129, 5378065:268813, 5378081:269503, 5378113:264141, 5378177:271126, 5378305:267384, 5378545:271848, 5382145:249266, 5382161:270893, 5382177:267814, 5382209:265872, 5382273:271402, 5382401:269030, 5382641:268149, 5386241:266950, 5386481:267238, 5390337:249266, 5390353:270893, 5390369:267814, 5390401:265872, 5390465:271402, 5390593:269030, 5390833:268149, 5394433:266950, 5394673:267238, 5398529:246194, 5398769:269370, 5406721:232
218, 5406737:268834, 5406753:265240, 5406785:257863, 5406849:266551, 5406977:269935, 5407217:272866, 5410817:257769, 5411057:269379, 5414913:257091, 5415153:264811, 5423105:257091, 5423345:264811, 5439489:214996, 5439505:265943, 5439521:268846, 5439553:249439, 5439617:270453, 5439745:267133, 5439985:270515, 5443585:251642, 5443825:268714, 5447681:247571, 5447921:266528, 5455873:247571, 5456113:266528, 5472257:230205, 5472497:268693, 5501425:269406, 5505025:254610, 5505041:266390, 5505057:266763, 5505073:271300, 5505089:269240, 5505105:267302, 5505121:268974, 5505153:269867, 5505169:269381, 5505185:271682, 5505217:272069, 5505281:267112, 5505297:265343, 5505313:268801, 5505345:270911, 5505409:265609, 5509121:264067, 5509137:267631, 5509153:267720, 5509185:263667, 5509249:263064, 5509377:267709, 5509617:264238, 5513217:265658, 5513233:268600, 5513249:267696, 5513281:270411, 5513345:268059, 5513473:267173, 5513713:269155, 5517313:265699, 5517553:266593, 5521409:265658, 5521425:268600,
5521441:267696, 5521473:270411, 5521537:268059, 5521665:267173, 5521905:269155, 5525505:265699, 5525745:266593, 5529601:260901, 5529841:270379, 5537793:259349, 5537809:270387, 5537825:270277, 5537857:268863, 5537921:269118, 5538049:270810, 5538289:270020, 5541889:268422, 5542129:268346, 5545985:266792, 5546225:269290, 5554177:266792, 5554417:269290, 5570561:250374, 5570577:270024, 5570593:266955, 5570625:262836, 5570689:270558, 5570817:269924, 5571057:268273, 5574657:262173, 5574897:266492, 5578753:263044, 5578993:266976, 5586945:263044, 5587185:266976, 5603329:257312, 5603569:268319, 5632497:265991, 5636097:254076, 5636113:266099, 5636129:270287, 5636161:263328, 5636225:271052, 5636353:266681, 5636593:270148, 5640193:262268, 5640433:266842, 5644289:265605, 5644529:268878, 5652481:265605, 5652721:268878, 5668865:256323, 5669105:268900, 5698033:267554, 5701633:250672, 5701873:273900, 5730801:264298, 5763583:268300, 5767153:268666, 5767169:255132, 5767185:267226, 5767201:266846, 57672
17:267750, 5767233:263902, 5767249:266894, 5767265:270244, 5767297:266384, 5767313:267862, 5767329:264413, 5767361:264906, 5767425:265903, 5767441:269052, 5767457:270874, 5767489:268793, 5767553:266747, 5771265:266595, 5771281:269231, 5771297:265450, 5771329:260972, 5771393:268228, 5771521:266666, 5771761:270799, 5775361:265760, 5775377:268383, 5775393:267430, 5775425:267929, 5775489:266121, 5775617:270509, 5775857:267493, 5779457:267302, 5779697:267531, 5783553:265760, 5783569:268383, 5783585:267430, 5783617:267929, 5783681:266121, 5783809:270509, 5784049:267493, 5787649:267302, 5787889:267531, 5791745:264281, 5791985:268124, 5799937:257291, 5799953:270837, 5799969:270020, 5800001:266924, 5800065:268597, 5800193:264500, 5800433:263943, 5804033:262851, 5804273:269900, 5808129:265863, 5808369:268003, 5816321:265863, 5816561:268003, 5832705:254830, 5832721:266817, 5832737:268284, 5832769:263543, 5832833:266879, 5832961:265279, 5833201:269115, 5836801:263424, 5837041:269400, 5840897:26
4341, 5841137:268005, 5849089:264341, 5849329:268005, 5865473:263399, 5865713:265518, 5894641:267564, 5898241:253978, 5898257:266694, 5898273:269426, 5898305:260709, 5898369:266547, 5898497:268196, 5898737:267854, 5902337:265621, 5902577:265455, 5906433:266050, 5906673:269602, 5914625:266050, 5914865:269602, 5931009:260874, 5931249:266667, 5960177:265302, 5963777:254186, 5964017:272192, 5992945:266989, 6029313:263227, 6029329:268855, 6029345:267170, 6029377:268387, 6029441:268006, 6029569:267357, 6029809:268840, 6033409:267686, 6033649:265380, 6037505:266634, 6037745:267772, 6045697:266634, 6045937:267772, 6062081:265367, 6062321:267279, 6091249:266338, 6094849:265864, 6095089:269023, 6124017:270478, 6160385:265155, 6160625:266691, 6189553:273277, 7340033:239033, 7340049:268129, 7340065:266366, 7340081:269475, 7340097:264134, 7340113:267278, 7340129:265808, 7340161:268590, 7340177:270462, 7340193:267409, 7340225:267162, 7340289:265813, 7340305:264419, 7340321:269015, 7340353:269256,
7340417:265089, 7344129:259715, 7344145:270337, 7344161:267369, 7344193:270897, 7344257:261649, 7344385:271279, 7344625:270171, 7348225:261680, 7348241:268809, 7348257:264203, 7348289:263672, 7348353:266696, 7348481:268741, 7348721:270609, 7352321:264157, 7352561:265515, 7356417:261680, 7356433:268809, 7356449:264203, 7356481:263672, 7356545:266696, 7356673:268741, 7356913:270609, 7360513:264157, 7360753:265515, 7364609:258498, 7364849:266097, 7372801:238780, 7372817:269399, 7372833:264899, 7372865:259644, 7372929:265557, 7373057:270598, 7373297:268728, 7376897:265282, 7377137:267779, 7380993:258803, 7381233:267691, 7389185:258803, 7389425:267691, 7405569:244715, 7405585:266343, 7405601:271071, 7405633:262157, 7405697:271827, 7405825:265261, 7406065:267176, 7409665:259146, 7409905:267906, 7413761:261805, 7414001:266540, 7421953:261805, 7422193:266540, 7438337:246097, 7438577:266831, 7467505:271587, 7471105:247607, 7471121:267743, 7471137:272660, 7471169:262217, 7471233:268544, 7471
361:264419, 7471601:268670, 7475201:261287, 7475441:269462, 7479297:264921, 7479537:267121, 7487489:264921, 7487729:267121, 7503873:244641, 7504113:270245, 7533041:270993, 7536641:242207, 7536881:270804, 7565809:267682, 7602177:261687, 7602193:264811, 7602209:270241, 7602241:264736, 7602305:271676, 7602433:261729, 7602673:268877, 7606273:268033, 7606513:266770, 7610369:266317, 7610609:266024, 7618561:266317, 7618801:266024, 7634945:264879, 7635185:270377, 7664113:267144, 7667713:263129, 7667953:268718, 7696881:270091, 7733249:257615, 7733489:264818, 7762417:268385, 7864321:262152, 7864337:273085, 7864353:266365, 7864385:270288, 7864449:263537, 7864577:270950, 7864817:267283, 7868417:262328, 7868657:268975, 7872513:266339, 7872753:269477, 7880705:266339, 7880945:269477, 7897089:266249, 7897329:269605, 7926257:270049, 7929857:265836, 7930097:269454, 7959025:267981, 7995393:265134, 7995633:263667, 8024561:267135, 8126465:265236, 8126705:266358, 8155633:267253, 8385023:262700, 8388607:2
70498
2020-12-03 21:55:02,141 INFO [pool-1-thread-1] job.CubeBuildJob : Cuboid statistics return 2381 records and cost 254901 ms.
2020-12-03 21:55:02,243 INFO [pool-1-thread-1] compress.CodecPool : Got brand-new compressor [.deflate]
2020-12-03 21:55:06,452 INFO [pool-1-thread-1] job.CubeBuildJob : UserActionStreamCube_2[20201010000000_20201012000000]'s stats saved to resource key(/cube_statistics/UserActionStreamCube_2/8d33bd34-41ef-c0ce-ff09-812992f50672.seq) with path(hdfs://cdh-master:8020/regression_testing/KYLIN-4818/KYLIN_4818/kylin-9f7149a1-0da8-400f-963f-d30d4f43e2e9/8d33bd34-41ef-c0ce-ff09-812992f50672/statistics/cuboid_statistics.seq)
2020-12-03 21:55:06,452 INFO [pool-1-thread-1] common.StatisticsDecisionUtil : It's able to trigger cuboid planner algorithm.
2020-12-03 21:55:06,516 INFO [pool-1-thread-1] common.CubeStatsReader : Reading statistics from file:/tmp/kylin_stats_tmp2767458573280355230.seq
2020-12-03 21:55:06,539 INFO [pool-1-thread-1] compress.CodecPool : Got brand-new decompressor [.deflate]
2020-12-03 21:55:07,080 INFO [pool-1-thread-1] common.KylinConfig : Creating new manager instance of class org.apache.kylin.cube.cuboid.CuboidManager
2020-12-03 21:55:07,082 INFO [pool-1-thread-1] common.KylinConfig : Creating new manager instance of class org.apache.kylin.dict.DictionaryManager
2020-12-03 21:55:07,083 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.UID, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,083 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.ACT_TYPE, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,083 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.PAGE_ID, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,083 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.AREA_ID, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,083 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.LAST_PAGE_ID, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,083 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.DEVICE_BRAND, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,083 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.NETWORK_TYPE, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,083 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.DEVICE_TYPE, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,083 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.OS_VERSION, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,083 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.APP_VERSION, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,083 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.ITEM_TYPE_ID, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,084 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.STRATEGY_ID, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,084 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.ACTIVITY_ID, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,084 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.ACTIVITY_TYPE, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,084 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.ADVERTISEMENT_FLAG, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,084 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.IP_ADDRESS, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,084 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.COUNTRY, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,084 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.PROVINCE, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,084 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.CITY, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,084 WARN [pool-1-thread-1] kv.CubeDimEncMap : No dictionary found for dict-encoding column LACUS.USERACTIONSTREAM.PART_DT, segment UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:07,292 INFO [pool-1-thread-1] algorithm.CuboidStats : Mandatory cuboids: [8388607]
2020-12-03 21:55:07,417 INFO [pool-1-thread-1] algorithm.CuboidRecommender : Cube Planner Algorithm started at 1607003707417
2020-12-03 21:55:07,418 INFO [pool-1-thread-1] greedy.GreedyAlgorithm : Greedy Algorithm started.
2020-12-03 21:55:08,597 INFO [pool-1-thread-1] greedy.GreedyAlgorithm : Greedy Algorithm finished.
2020-12-03 21:55:08,597 INFO [pool-1-thread-1] algorithm.CuboidRecommender : Cube Planner Algorithm ended at 1180
2020-12-03 21:55:08,597 INFO [pool-1-thread-1] algorithm.CuboidRecommender : Cube Planner Algorithm chooses 96 most effective cuboids to build among of all 2381 cuboids.
2020-12-03 21:55:08,628 INFO [pool-1-thread-1] cube.CubeManager : Updating cube instance 'UserActionStreamCube_2'
2020-12-03 21:55:08,628 WARN [pool-1-thread-1] model.Segments : NEW segment start does not fit/connect with other segments: UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:08,628 WARN [pool-1-thread-1] model.Segments : NEW segment end does not fit/connect with other segments: UserActionStreamCube_2[20201010000000_20201012000000]
2020-12-03 21:55:08,630 DEBUG [pool-1-thread-1] util.CompressionUtils : Original: 1527 bytes. Compressed: 690 byte. Time: 1
2020-12-03 21:55:08,630 DEBUG [pool-1-thread-1] cachesync.CachedCrudAssist : Saving CubeInstance at /cube/UserActionStreamCube_2.json
2020-12-03 21:55:08,665 DEBUG [pool-1-thread-1] cachesync.Broadcaster : Servers in the cluster: [localhost:7303]
2020-12-03 21:55:08,669 INFO [pool-1-thread-1] job.CubeBuildJob : Triggered cube planner phase one .
2020-12-03 21:55:08,673 DEBUG [pool-1-thread-1] util.CompressionUtils : Original: 690 bytes. Decompressed: 1527 bytes. Time: 0
2020-12-03 21:55:08,678 INFO [pool-1-thread-1] common.KylinConfig : Loading kylin-defaults.properties from file:/root/lib/kylin-dist/KYLIN-4818/apache-kylin-4.0.0-SNAPSHOT-bin/lib/kylin-parquet-job-4.0.0-SNAPSHOT.jar!/kylin-defaults.properties
2020-12-03 21:55:08,682 DEBUG [pool-1-thread-1] common.KylinConfig : KYLIN_CONF property was not set, will seek KYLIN_HOME env variable
2020-12-03 21:55:08,682 INFO [pool-1-thread-1] common.KylinConfig : Use KYLIN_HOME=/root/lib/kylin-dist/KYLIN-4818/apache-kylin-4.0.0-SNAPSHOT-bin
2020-12-03 21:55:08,683 INFO [pool-1-thread-1] common.KylinConfigBase : Kylin Config was updated with kylin.metadata.url.identifier : KYLIN_4818
2020-12-03 21:55:08,683 INFO [pool-1-thread-1] common.KylinConfigBase : Kylin Config was updated with kylin.log.spark-executor-properties-file : /root/lib/kylin-dist/KYLIN-4818/apache-kylin-4.0.0-SNAPSHOT-bin/conf/spark-executor-log4j.properties
2020-12-03 21:55:08,683 INFO [pool-1-thread-1] job.CubeBuildJob : There are 96 cuboids to be built in segment 20201010000000_20201012000000.
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org