This is an automated email from the ASF dual-hosted git repository. kxiao pushed a commit to branch branch-2.0 in repository https://gitbox.apache.org/repos/asf/doris.git
commit 6423c05075dc44c880a0471e79f269c46b9ba322 Author: amory <[email protected]> AuthorDate: Mon Sep 18 16:05:30 2023 +0800 [Improve](explode) improve explode func with array nested other type (#24455) improve explode func with array nested other type --- be/src/vec/exprs/table_function/vexplode.cpp | 12 +- .../query_p0/sql_functions/table_function/am.json | 25 +++ .../sql_functions/table_function/explode.out | 189 +++++++++++++++++++++ .../sql_functions/table_function/explode.groovy | 67 ++++++++ 4 files changed, 291 insertions(+), 2 deletions(-) diff --git a/be/src/vec/exprs/table_function/vexplode.cpp b/be/src/vec/exprs/table_function/vexplode.cpp index 6f13a710e27..912b7acb5de 100644 --- a/be/src/vec/exprs/table_function/vexplode.cpp +++ b/be/src/vec/exprs/table_function/vexplode.cpp @@ -79,8 +79,16 @@ void VExplodeTableFunction::get_value(MutableColumnPtr& column) { if (current_empty() || (_detail.nested_nullmap_data && _detail.nested_nullmap_data[pos])) { column->insert_default(); } else { - column->insert_data(const_cast<char*>(_detail.nested_col->get_data_at(pos).data), - _detail.nested_col->get_data_at(pos).size); + if (_is_nullable) { + assert_cast<ColumnNullable*>(column.get()) + ->get_nested_column_ptr() + ->insert_from(*_detail.nested_col, pos); + assert_cast<ColumnUInt8*>( + assert_cast<ColumnNullable*>(column.get())->get_null_map_column_ptr().get()) + ->insert_default(); + } else { + column->insert_from(*_detail.nested_col, pos); + } } } diff --git a/regression-test/data/query_p0/sql_functions/table_function/am.json b/regression-test/data/query_p0/sql_functions/table_function/am.json new file mode 100644 index 00000000000..c97d389b93d --- /dev/null +++ b/regression-test/data/query_p0/sql_functions/table_function/am.json @@ -0,0 +1,25 @@ +{"id":0,"arr_arr":[["feHR6W-ttEtC3v-RvY-RyY3","omWUhV-SlIJJv4-kEW-VDBJ","NZh0JU-TJDXU9B-og5-0J61","V6fdEU-jkJevQT-dWN-sIIY"],null,["SSe3dY-I23acFP-rlr-Xify","XUEhSe-HOgsNt9-RlT-H8JA","zCEmCf-gozXHWE-aI4-y9Dq","qcZATo-a7Czu4Y-KuY-eSX9"],["ADAoxE-ejB7xJn-1zn-Xgpq","DFEZOm-EC6331F-9pF-4ox2","GZ7P0Q-WB5YcBq-af3-HWxg","BPHZHn-faeylOR-PYM-x6gN"]],"arr_map":[{"swpp0q-vgNTgMG-U1h-GrtK":5,"e0bNvm-ZuCo9v7-Gu1-9qsJ":9,"CW2OBW-ET71l4k-wke-B8pK":3,"ydO2p2-64OmnPD-JT1-Xe9q":6,"b9P9Pj-8o3jgFn-E5G-M6Wx" [...] +{"id":1,"arr_arr":[["ZGRUhx-eadzlDE-JFF-BH3P","vrhIVi-tIBN9fc-tBe-4FUC","v006kw-wIB8x6E-WWt-Li23"],["Q3UE7a-yBfPvoZ-q5e-xtc3","b4Is4f-1Q17TLQ-3Nh-E9XK","1bkMir-QC3ddA8-Wy6-dcgr"],null],"arr_map":[{"nKWQnv-HolfdQc-tqs-Trnb":0,"GEAmQi-bMHzvyG-MGd-GBjA":5,"KtMT9e-jKcWd9t-9GG-8mG6":3,"znKFYo-4abMgt6-k4A-L4Ki":4,"IpXgBa-FGiyskO-R5R-T3CY":6},{"nKWQnv-HolfdQc-tqs-Trnb":0,"GEAmQi-bMHzvyG-MGd-GBjA":5,"KtMT9e-jKcWd9t-9GG-8mG6":3,"znKFYo-4abMgt6-k4A-L4Ki":4,"IpXgBa-FGiyskO-R5R-T3CY":6},{"nKWQnv-Hol [...] +{"id":2,"arr_arr":[["lWGk4M-ba0tBFf-JVl-qYen","2O1nVO-8pdtYoX-jaz-9Lyv"],null],"arr_map":[{"N1isOk-HqyCfZ3-Iqu-sHC4":8,"zoEAUW-yYiiBxG-xER-4AVu":0,"y6OK1G-wIHaG2A-oWB-WQel":3,"oWys2y-FLQKf53-5mm-3BWr":9,"Kkjpbh-vOvz3Hu-WdS-UVI6":4},{"N1isOk-HqyCfZ3-Iqu-sHC4":8,"zoEAUW-yYiiBxG-xER-4AVu":0,"y6OK1G-wIHaG2A-oWB-WQel":3,"oWys2y-FLQKf53-5mm-3BWr":9,"Kkjpbh-vOvz3Hu-WdS-UVI6":4}]} +{"id":3,"arr_arr":[],"arr_map":[{"sAAkg4-TsxcHvG-PU5-reih":0,"gLZA8c-BegqvvI-c8X-k2sG":0,"XsjVET-cVWzizh-IQL-oD9Z":3,"mn5po7-sdVBNfT-D1h-J9cr":1,"VhWPpg-MjnLQxg-fQW-HSEW":5},{"sAAkg4-TsxcHvG-PU5-reih":0,"gLZA8c-BegqvvI-c8X-k2sG":0,"XsjVET-cVWzizh-IQL-oD9Z":3,"mn5po7-sdVBNfT-D1h-J9cr":1,"VhWPpg-MjnLQxg-fQW-HSEW":5},{"sAAkg4-TsxcHvG-PU5-reih":0,"gLZA8c-BegqvvI-c8X-k2sG":0,"XsjVET-cVWzizh-IQL-oD9Z":3,"mn5po7-sdVBNfT-D1h-J9cr":1,"VhWPpg-MjnLQxg-fQW-HSEW":5}]} +{"id":4,"arr_arr":[],"arr_map":[{"GW98C8-Xv6AWLP-ivi-FLtW":0,"Q635Ar-OMGGYWX-Dhg-7HgP":8,"TbeKcq-4AUGF5H-DzO-KwWg":6,"fKDLAp-tPmFPle-lF6-FGNZ":1,"W5qTCQ-Lfqxf29-Z3J-9Yrz":9},{"GW98C8-Xv6AWLP-ivi-FLtW":0,"Q635Ar-OMGGYWX-Dhg-7HgP":8,"TbeKcq-4AUGF5H-DzO-KwWg":6,"fKDLAp-tPmFPle-lF6-FGNZ":1,"W5qTCQ-Lfqxf29-Z3J-9Yrz":9}]} +{"id":5,"arr_arr":[null,["YaKNfI-gV6lMRG-dio-Jg9D","TC7wdG-1YvyDHG-HVV-rdRR","8dMmjA-lA9oHx9-dSS-Fl86"],["4Rff3K-TATMSg1-b6R-SmKN","t1j5tX-dTCrxmn-idk-rk24","7LW7Lq-cXYuy90-uyH-M6pK"]],"arr_map":[{"iLOhUA-n05O2OY-LHB-qS3H":8,"ATC5e8-MywwrP3-Vhc-QdxZ":1,"fST2pb-uAaS3Mb-Pl6-9i1J":0,"fppq1A-Q1WOvMj-Eod-xbTz":3,"ebkDD2-T3jSVTg-zZS-Bqnh":4},{"iLOhUA-n05O2OY-LHB-qS3H":8,"ATC5e8-MywwrP3-Vhc-QdxZ":1,"fST2pb-uAaS3Mb-Pl6-9i1J":0,"fppq1A-Q1WOvMj-Eod-xbTz":3,"ebkDD2-T3jSVTg-zZS-Bqnh":4},{"iLOhUA-n05 [...] +{"id":6,"arr_arr":[],"arr_map":[{"eSB1Yl-jDIrIHV-7WE-qyvM":6,"4N8yoM-901A5FI-B9Q-3EpM":9,"pBdMp1-nVbMzpB-WJj-dhDd":4,"3jGdNP-NgyL5fW-9Ty-CLlY":2,"5gaoHt-7MmTVLs-Jm0-KpaG":2},{"eSB1Yl-jDIrIHV-7WE-qyvM":6,"4N8yoM-901A5FI-B9Q-3EpM":9,"pBdMp1-nVbMzpB-WJj-dhDd":4,"3jGdNP-NgyL5fW-9Ty-CLlY":2,"5gaoHt-7MmTVLs-Jm0-KpaG":2},{"eSB1Yl-jDIrIHV-7WE-qyvM":6,"4N8yoM-901A5FI-B9Q-3EpM":9,"pBdMp1-nVbMzpB-WJj-dhDd":4,"3jGdNP-NgyL5fW-9Ty-CLlY":2,"5gaoHt-7MmTVLs-Jm0-KpaG":2}]} +{"id":7,"arr_arr":[["UGG3Iy-bMW7c6T-fz9-WYOG","SWWur3-zdHlN1q-527-UtFT","XrCVm0-bbwQBay-lcn-vNTJ"],null,["1KN2Cf-UE1ruFq-sRm-pW7A","2lwurI-ANjel77-nhS-ahzI","DR5JH4-WM6QRe7-FgQ-qHnV"]],"arr_map":[{"yfDrEq-z2VBXi1-bSe-tgGW":7,"zLkwFE-i6GiJut-yHW-e4wJ":8,"pl1mqW-qSEYcv0-kTT-8Uuz":3,"cEbTSo-CoT1upF-XsY-gafn":8,"Shcq2l-iuYvkyo-ssN-okkW":7},{"yfDrEq-z2VBXi1-bSe-tgGW":7,"zLkwFE-i6GiJut-yHW-e4wJ":8,"pl1mqW-qSEYcv0-kTT-8Uuz":3,"cEbTSo-CoT1upF-XsY-gafn":8,"Shcq2l-iuYvkyo-ssN-okkW":7},{"yfDrEq-z2V [...] +{"id":8,"arr_arr":[["ZfdXEt-opP9k3J-l2M-sIdX","CyLrQr-KniPD7H-VaF-y563","UtVD3f-NsX6D4j-UQt-Pgpg"],["RjHATY-RbQXO8o-9kC-yMN6","QIsZVT-SBeloLd-RgF-zws0","6d2byV-qKIHXRn-mDF-TM1g"],null],"arr_map":[{"lJFCyu-BhT7N4x-luz-9t85":2,"wGuvM7-zJNjFUz-4z3-Y6Gf":7,"F9KCc5-ZzE0IYN-c5t-VqUH":8,"FgXjJi-l10Pijy-jtK-WgMf":4,"uexWAB-xHkHMYL-vUi-4Umt":9},{"lJFCyu-BhT7N4x-luz-9t85":2,"wGuvM7-zJNjFUz-4z3-Y6Gf":7,"F9KCc5-ZzE0IYN-c5t-VqUH":8,"FgXjJi-l10Pijy-jtK-WgMf":4,"uexWAB-xHkHMYL-vUi-4Umt":9},{"lJFCyu-BhT [...] +{"id":9,"arr_arr":[null,["xI0TNh-wAH12NI-6Px-MLib","Jmesk7-hJzDXz6-lFC-Egmp","YFtlSh-8pZVVxG-mNa-RYES","q5sDuB-WfmqXDr-WXJ-UPq6","3Toro7-4wzAPD9-G6e-ajl1","bE4dED-fNBqL16-JXt-0lZY"],["n14avO-lueGLXs-zxM-tOEZ","yj4iMW-h1Z5isV-jM4-0BRC","YXg40k-p00nu3H-DLQ-ASu2","KOg34p-E4TtdAs-xcl-ajzL","d0LfzZ-2huMiVN-4Fc-aOuz","2cJHzT-KjvF9cE-W5u-nOrI"],["CSwQYw-bvMIUzj-bqf-AXpo","tc0Rwz-uQ3Wdbv-z8f-qklW","X6X0G8-JlYcXKh-pay-D21m","n7RWXW-ZFh2HqS-6XE-v9TY","zAXTa3-zz5OkX6-jAM-ZuyD","UXdt9B-Mml6eBa-hN7-v [...] +{"id":10,"arr_arr":[["PWNdZn-256Mzh0-Wxl-i1VN","oyLKti-7HvbWsn-MQ4-EMuK"],null],"arr_map":[{"kpjXle-CayOe2S-2W4-vqvG":4,"VIWvQo-q2swzEQ-loT-PpQA":9,"PnLRPK-AW1LRJj-QDh-WLfE":5,"vGVTU8-SbgpatL-PXh-6DPp":0,"YPH9gI-Uv5Ec0u-QHJ-5QKd":3},{"kpjXle-CayOe2S-2W4-vqvG":4,"VIWvQo-q2swzEQ-loT-PpQA":9,"PnLRPK-AW1LRJj-QDh-WLfE":5,"vGVTU8-SbgpatL-PXh-6DPp":0,"YPH9gI-Uv5Ec0u-QHJ-5QKd":3},{"kpjXle-CayOe2S-2W4-vqvG":4,"VIWvQo-q2swzEQ-loT-PpQA":9,"PnLRPK-AW1LRJj-QDh-WLfE":5,"vGVTU8-SbgpatL-PXh-6DPp":0,"YPH [...] +{"id":11,"arr_arr":[["5fkZOk-BckdrAU-MM3-HwPF","vicmYn-wD21968-mbI-Wv3c"],null],"arr_map":[{"Mqzc3X-DzSmJor-o9C-g73I":4,"Xgdg1m-DZzCOqO-7pA-PKeS":6,"JzTEl1-CwOaAmt-yV3-n2k0":9,"pm0RBB-gdAl37a-8Pq-QLJV":4,"oN1HDX-xCm8dRv-0wk-MJeu":8},{"Mqzc3X-DzSmJor-o9C-g73I":4,"Xgdg1m-DZzCOqO-7pA-PKeS":6,"JzTEl1-CwOaAmt-yV3-n2k0":9,"pm0RBB-gdAl37a-8Pq-QLJV":4,"oN1HDX-xCm8dRv-0wk-MJeu":8},{"Mqzc3X-DzSmJor-o9C-g73I":4,"Xgdg1m-DZzCOqO-7pA-PKeS":6,"JzTEl1-CwOaAmt-yV3-n2k0":9,"pm0RBB-gdAl37a-8Pq-QLJV":4,"oN1 [...] +{"id":12,"arr_arr":[["srDnEJ-ySU31lR-ul1-ROCJ","cMnWa5-bA1OMFg-kiY-AZMI","8iRcRL-3v72cNM-Ojm-MUpV"],["ydwzpg-kqjN5zO-Vb5-wo5P","Rpk4Cc-1MaKNzp-0GF-Hr8K","G64mgw-wLRtwwY-XFn-BlaK"],null],"arr_map":[{"GFBqsx-TvhMATX-6ZB-0Zva":2,"D6QtvK-8eTn7dE-CZn-h18O":2,"tdKmN3-ealR73D-PO4-6nh8":4,"veE9Ee-GBc3xZa-O1T-n8u3":5,"0P9fws-Pb03WDb-lOu-l4Ww":7},{"GFBqsx-TvhMATX-6ZB-0Zva":2,"D6QtvK-8eTn7dE-CZn-h18O":2,"tdKmN3-ealR73D-PO4-6nh8":4,"veE9Ee-GBc3xZa-O1T-n8u3":5,"0P9fws-Pb03WDb-lOu-l4Ww":7},{"GFBqsx-Tv [...] +{"id":13,"arr_arr":[],"arr_map":[{"kIpyuK-FUQet1S-6JW-PJjH":0,"KosGlG-X9weJpR-Olb-qNNY":4,"x8HUd5-IzLbruK-ruY-HPIv":8,"UaBaT4-ZKtEsWB-yJ7-ikwZ":2,"tyiuhU-08ulAju-XWn-fsID":6},{"kIpyuK-FUQet1S-6JW-PJjH":0,"KosGlG-X9weJpR-Olb-qNNY":4,"x8HUd5-IzLbruK-ruY-HPIv":8,"UaBaT4-ZKtEsWB-yJ7-ikwZ":2,"tyiuhU-08ulAju-XWn-fsID":6},{"kIpyuK-FUQet1S-6JW-PJjH":0,"KosGlG-X9weJpR-Olb-qNNY":4,"x8HUd5-IzLbruK-ruY-HPIv":8,"UaBaT4-ZKtEsWB-yJ7-ikwZ":2,"tyiuhU-08ulAju-XWn-fsID":6}]} +{"id":14,"arr_arr":[["hBG9CJ-Pkcv5Xv-y5o-SiDS","VAaAjn-bFJZdHR-NYt-2on0","T3pZPF-LB6LuqK-Zfg-CwRv","2yAunr-D0ywKAw-fA7-19qi","5t1kUf-nkasZdS-9cr-6J2b","7Yk0yJ-PuETSw0-nGi-yIET"],["EUKF7p-G5gNyzr-nTn-AlOt","NHve5R-8hB7e9z-1s4-AmPq","4rGDYS-KTrWNMD-Iur-dn0b","9RZDOx-oShNnLu-rQ1-uCmU","FA2HUr-CoTvZBz-ZlO-cEA3","XeSGqz-Lrl8p39-Hx6-HZQh"],["Zi6B6P-FFGNvXt-IN9-3MQg","QZ4Blu-xat1Zh7-Id2-emNh","zBJ4k4-qB9gGgf-uEF-Cuee","ndFSon-iwKJGIb-gQa-keG0","ZI14D4-NOhnTPA-DtG-xuhP","x0UxHB-lEmujK2-snM-q8ze" [...] +{"id":15,"arr_arr":[["VMXWe8-sJGeEn4-qgR-82VU"]],"arr_map":[{"ZZoIk6-FCvllrX-ynY-WH9b":8,"Lo6mI2-FUuG0Kp-ALg-N9CN":2,"lFhxJ0-iaZhTSc-XKg-Ats9":9,"hiaVfD-qDapBgY-DBu-uCif":1,"i5zkzH-UFvf6zO-ubG-bDEb":9},{"ZZoIk6-FCvllrX-ynY-WH9b":8,"Lo6mI2-FUuG0Kp-ALg-N9CN":2,"lFhxJ0-iaZhTSc-XKg-Ats9":9,"hiaVfD-qDapBgY-DBu-uCif":1,"i5zkzH-UFvf6zO-ubG-bDEb":9},{"ZZoIk6-FCvllrX-ynY-WH9b":8,"Lo6mI2-FUuG0Kp-ALg-N9CN":2,"lFhxJ0-iaZhTSc-XKg-Ats9":9,"hiaVfD-qDapBgY-DBu-uCif":1,"i5zkzH-UFvf6zO-ubG-bDEb":9},{"ZZoI [...] +{"id":16,"arr_arr":[["Q6ZUdh-aHSTJSP-qvd-z7a6","HsdNd0-VKHJL5f-6MU-yGb6","FZObTa-iuP04lW-tZw-D68t","5eaGJJ-uyU5Au4-dBC-5AR1"],["tgS4vz-pU4PS8m-E5R-DSU8","wxkjf8-Wwl6cjm-AC9-KcKi","US36ry-lTrkIhR-MTf-7YyD","xNmbYx-VDzJq4E-5Q2-DCvO"],["OIN1Oe-FI3wcrp-66H-fGKM","ijHMjw-V2O8F9E-OYq-NpkQ","aChpoK-FAtOsCI-kWI-oYnF","iE0YBR-zGoZeFx-nLL-CGMW"],null],"arr_map":[{"6HGUM0-YSULhQm-tNd-WrUB":6,"2iQyQQ-0Q79hSa-xas-mA1b":2,"kHyrvC-FG8yKzY-bJi-FTGR":5,"kCKYlJ-LlfcyEz-Zzc-pcuw":2,"D97U6o-rNR0M8j-7FD-yB2i [...] +{"id":17,"arr_arr":[["6h3u7b-znuJXzP-Y0y-67k5","kOW5Bh-iCk28Kl-qnX-YTEw","52e34r-ja3ecA3-f2X-tW5A","fbEZmh-SditnSh-1Nf-O939","ovmskR-d7Cb5GH-uTh-snqu"],["gaRzuW-8ljPxnB-sG4-EPyR","I1fCfi-dqF5jIV-xcO-qXxs","vteojI-nipd8nC-GbM-BuCz","OJtqcM-M4xJStL-DoO-pAVA","cHaELA-NYH7FiQ-JRw-Pplg"],null,["L1ROPG-CHHugVU-tQw-9PCs","7bZtwn-HrJkMD9-YFg-Fmcf","PVV4fi-5rlini0-2AI-97MK","ouWbwc-B2vQ7tR-DLi-H34g","R1crmv-lhkakVD-Gg4-LBIv"],["FACnXp-lxR724G-u2J-veYj","5iIj0x-NWC3OCy-zlU-8laP","2xSkQW-CxLzsjs-lP [...] +{"id":18,"arr_arr":[["eBNnB0-qIe9HyT-unn-r8Sg"]],"arr_map":[{"RSxqTF-B1xKGK9-9te-Z1xX":0,"BcHNcY-Pwmjwi9-ZcZ-YE0Z":8,"jLDmB5-YGodMV9-bTw-fa2T":9,"u66Ef1-CwR2ipD-PME-fSP8":1,"KDObx4-FHLBa7W-r44-z9tZ":7},{"RSxqTF-B1xKGK9-9te-Z1xX":0,"BcHNcY-Pwmjwi9-ZcZ-YE0Z":8,"jLDmB5-YGodMV9-bTw-fa2T":9,"u66Ef1-CwR2ipD-PME-fSP8":1,"KDObx4-FHLBa7W-r44-z9tZ":7},{"RSxqTF-B1xKGK9-9te-Z1xX":0,"BcHNcY-Pwmjwi9-ZcZ-YE0Z":8,"jLDmB5-YGodMV9-bTw-fa2T":9,"u66Ef1-CwR2ipD-PME-fSP8":1,"KDObx4-FHLBa7W-r44-z9tZ":7}]} +{"id":19,"arr_arr":[["164Ucc-2m33JDj-cRk-xvJr","3PFwGM-MbNcZmG-PsT-yVEO","LoBi6u-BrGnZ72-PC2-Q3Dh","4TJDnj-Fd9d8n6-epp-qcBk"],["7S1jZR-tqeJcs1-IpA-5u7g","Y9Pj9d-i8aWERJ-x04-e82r","6GzJ9a-9vDrDmO-OQ2-Hy6L","CojUHC-RSlsTY2-ldc-M8kY"],null,["z10C0S-v1Ly6UA-5fZ-N2Yz","vUqsQc-OZznYLV-Yfg-xOwn","rtj7wC-1lnLARh-D0t-HIlb","pVxrxW-2gjav4g-Gbq-DYRn"]],"arr_map":[{"hBvx9O-RHmsr9n-bBE-h38U":9,"tV1hKh-q5dhFb1-lfN-Mc3P":0,"39ZYSM-aId3Vm9-Mjw-darG":1,"v0P8jE-aSQ8EqB-Pld-3aSb":7,"Pg5lQ0-cujZNmk-J9F-h9s4 [...] +{"id":20,"arr_arr":[],"arr_map":[{"HJs9wu-EjXKZA0-AGv-Toi8":4,"T7URbX-187t8gX-tYf-ks7L":3,"f4i0Uf-oBOVCl5-1qx-n9Ss":9,"sqsjvC-u9ge35C-KFD-86lp":3,"n19oZV-8Ov2kKD-KWf-zb2s":5},{"HJs9wu-EjXKZA0-AGv-Toi8":4,"T7URbX-187t8gX-tYf-ks7L":3,"f4i0Uf-oBOVCl5-1qx-n9Ss":9,"sqsjvC-u9ge35C-KFD-86lp":3,"n19oZV-8Ov2kKD-KWf-zb2s":5}]} +{"id":21,"arr_arr":[null,["2ru83o-BLrXeLD-FMI-AHCI","AC5OaC-yOGE24o-n89-qUmQ"]],"arr_map":[{"xwlOrk-MpiP6RS-Vm4-XKef":3,"PTSQoh-9NkO5Sr-Bj9-DaSB":3,"hC1kwZ-RkpFtX4-ALg-4nMp":8,"CJwJkc-Q3Gn7BI-M2Z-jM3Q":5,"MAug88-UBrKX5Q-W3w-ztwL":2},{"xwlOrk-MpiP6RS-Vm4-XKef":3,"PTSQoh-9NkO5Sr-Bj9-DaSB":3,"hC1kwZ-RkpFtX4-ALg-4nMp":8,"CJwJkc-Q3Gn7BI-M2Z-jM3Q":5,"MAug88-UBrKX5Q-W3w-ztwL":2}]} +{"id":22,"arr_arr":[["iM77UH-g1Pul89-YnQ-mOju","JJekpT-wJk9ZZy-aou-6HRB","AWo8ix-RbUagjG-UtD-zW75","Kq1sq2-vPn2q8e-xuN-E4cr","TBnH0L-56BECcO-tG9-Jo1F","zf0TLE-QMDr10f-RTw-WhtA"],["V20VMl-FHaVSEY-tRf-EVLY","TC4bsI-2dN4rbV-Bc4-nqLw","zouZEJ-IcTifEo-dHk-RzX9","o9pub3-4Dkuxvr-ATy-gsVM","7MvH7l-L69XzoQ-11N-uePw","ldifMl-rhQBFYS-WUP-x2sV"],["6kV5kA-oLIN98n-R9x-CbOC","FlQiW3-FMAuhIl-KUI-57m8","mLZ5P5-Lk5B1T2-TcS-Sb3b","D7hYvP-GD3AC4F-0NW-qKlY","4ZRaDG-KDaPsCf-vve-j19b","dWKEqu-eqVLEud-Oek-EXgF" [...] +{"id":23,"arr_arr":[["JXHEFv-2kkSptQ-ds9-olbF","0FbJaV-hQsUOY0-cZy-g8yw","DDNYmH-rqqsupW-DSF-ASYa","oo3QSm-nleM2nm-7Mr-NckZ"],null,["yL4Enp-fyRljVc-FrV-jzA7","cAAuwr-Ex4inWX-PGI-O1Pb","P35UXH-Z4XfwS8-8bB-otWi","GCtp6w-WRen8SV-VKh-1Fb0"],["UfsfRH-VVH8UqO-y5A-XYB8","OiuYyd-lkJesJY-QGG-dQOY","TIAbsF-lREUyDE-ZUA-oBBS","LttgCp-vdSwX9h-EsY-Ycpf"]],"arr_map":[{"JGQBg2-5qtPR8C-5Re-twPm":6,"Uj4xhW-KbWI4mC-72t-eepp":3,"27tztk-g7ind7U-jKv-QuhC":3,"iOwSq6-VqdFNrm-2nm-hY1n":0,"bct8XY-dpPRzHE-k2n-kTH2 [...] +{"id":24,"arr_arr":[["wAacAz-fjaxrWS-Qll-q64P","PFuBtw-gUkeoKF-mFD-ziIt","YpcoBs-FYBjK5r-Z2c-r4Wf"],null,["qbjB3i-xWRlUzF-YKl-Gbyt","5OhXnX-6SEsMaG-ctZ-B7tV","ZnGjr9-fxDj0iV-HtM-QwCc"]],"arr_map":[{"Avnja3-OUO7GZp-Bbb-9WJ6":5,"mLpE5W-beMQh4z-Z6P-jPjO":9,"Rd3wR9-CHe1XzT-jcD-UBF3":9,"gTx716-7et3HUP-jfk-oXWX":1,"nEC8vl-y54mkM0-LKD-s18Q":8},{"Avnja3-OUO7GZp-Bbb-9WJ6":5,"mLpE5W-beMQh4z-Z6P-jPjO":9,"Rd3wR9-CHe1XzT-jcD-UBF3":9,"gTx716-7et3HUP-jfk-oXWX":1,"nEC8vl-y54mkM0-LKD-s18Q":8},{"Avnja3-OU [...] diff --git a/regression-test/data/query_p0/sql_functions/table_function/explode.out b/regression-test/data/query_p0/sql_functions/table_function/explode.out index 2c06dc5d81c..415abdf8237 100644 --- a/regression-test/data/query_p0/sql_functions/table_function/explode.out +++ b/regression-test/data/query_p0/sql_functions/table_function/explode.out @@ -275,3 +275,192 @@ 15 8 15 9 +-- !sql -- +0 \N +0 ["ADAoxE-ejB7xJn-1zn-Xgpq", "DFEZOm-EC6331F-9pF-4ox2", "GZ7P0Q-WB5YcBq-af3-HWxg", "BPHZHn-faeylOR-PYM-x6gN"] +0 ["SSe3dY-I23acFP-rlr-Xify", "XUEhSe-HOgsNt9-RlT-H8JA", "zCEmCf-gozXHWE-aI4-y9Dq", "qcZATo-a7Czu4Y-KuY-eSX9"] +0 ["feHR6W-ttEtC3v-RvY-RyY3", "omWUhV-SlIJJv4-kEW-VDBJ", "NZh0JU-TJDXU9B-og5-0J61", "V6fdEU-jkJevQT-dWN-sIIY"] +1 \N +1 ["Q3UE7a-yBfPvoZ-q5e-xtc3", "b4Is4f-1Q17TLQ-3Nh-E9XK", "1bkMir-QC3ddA8-Wy6-dcgr"] +1 ["ZGRUhx-eadzlDE-JFF-BH3P", "vrhIVi-tIBN9fc-tBe-4FUC", "v006kw-wIB8x6E-WWt-Li23"] +10 \N +10 ["PWNdZn-256Mzh0-Wxl-i1VN", "oyLKti-7HvbWsn-MQ4-EMuK"] +11 \N +11 ["5fkZOk-BckdrAU-MM3-HwPF", "vicmYn-wD21968-mbI-Wv3c"] +12 \N +12 ["srDnEJ-ySU31lR-ul1-ROCJ", "cMnWa5-bA1OMFg-kiY-AZMI", "8iRcRL-3v72cNM-Ojm-MUpV"] +12 ["ydwzpg-kqjN5zO-Vb5-wo5P", "Rpk4Cc-1MaKNzp-0GF-Hr8K", "G64mgw-wLRtwwY-XFn-BlaK"] +14 \N +14 ["2ISsbI-Tpnywjw-dKc-awNI", "KNq9c2-Yvp3aEc-geM-MQV0", "oDkQ38-Eu9E6bj-Ei6-rwwq", "678xMV-Tn0fVv6-O67-Jg01", "c5Xufb-QGUezAE-8iM-3VBg", "MhjSVE-UKjyuyZ-h71-q8fS"] +14 ["EUKF7p-G5gNyzr-nTn-AlOt", "NHve5R-8hB7e9z-1s4-AmPq", "4rGDYS-KTrWNMD-Iur-dn0b", "9RZDOx-oShNnLu-rQ1-uCmU", "FA2HUr-CoTvZBz-ZlO-cEA3", "XeSGqz-Lrl8p39-Hx6-HZQh"] +14 ["KdXHnA-bNv8rwO-4Ey-nVz6", "a9J9b4-Yd2j674-3eB-Bqjv", "ciwaAk-ktsHqMi-aug-tSgZ", "U2TSkV-PrbEclO-tIt-ilN7", "EDRbVY-6Y8vZgH-QYY-CPur", "nKUwkr-WXn2hj1-xay-JeZA"] +14 ["Zi6B6P-FFGNvXt-IN9-3MQg", "QZ4Blu-xat1Zh7-Id2-emNh", "zBJ4k4-qB9gGgf-uEF-Cuee", "ndFSon-iwKJGIb-gQa-keG0", "ZI14D4-NOhnTPA-DtG-xuhP", "x0UxHB-lEmujK2-snM-q8ze"] +14 ["hBG9CJ-Pkcv5Xv-y5o-SiDS", "VAaAjn-bFJZdHR-NYt-2on0", "T3pZPF-LB6LuqK-Zfg-CwRv", "2yAunr-D0ywKAw-fA7-19qi", "5t1kUf-nkasZdS-9cr-6J2b", "7Yk0yJ-PuETSw0-nGi-yIET"] +15 ["VMXWe8-sJGeEn4-qgR-82VU"] +16 \N +16 ["OIN1Oe-FI3wcrp-66H-fGKM", "ijHMjw-V2O8F9E-OYq-NpkQ", "aChpoK-FAtOsCI-kWI-oYnF", "iE0YBR-zGoZeFx-nLL-CGMW"] +16 ["Q6ZUdh-aHSTJSP-qvd-z7a6", "HsdNd0-VKHJL5f-6MU-yGb6", "FZObTa-iuP04lW-tZw-D68t", "5eaGJJ-uyU5Au4-dBC-5AR1"] +16 ["tgS4vz-pU4PS8m-E5R-DSU8", "wxkjf8-Wwl6cjm-AC9-KcKi", "US36ry-lTrkIhR-MTf-7YyD", "xNmbYx-VDzJq4E-5Q2-DCvO"] +17 \N +17 ["6h3u7b-znuJXzP-Y0y-67k5", "kOW5Bh-iCk28Kl-qnX-YTEw", "52e34r-ja3ecA3-f2X-tW5A", "fbEZmh-SditnSh-1Nf-O939", "ovmskR-d7Cb5GH-uTh-snqu"] +17 ["FACnXp-lxR724G-u2J-veYj", "5iIj0x-NWC3OCy-zlU-8laP", "2xSkQW-CxLzsjs-lPi-KhFu", "GIIWc9-1gOT3Ql-zK9-aBK5", "FFtM4W-pFhEp8x-D4s-AIX9"] +17 ["L1ROPG-CHHugVU-tQw-9PCs", "7bZtwn-HrJkMD9-YFg-Fmcf", "PVV4fi-5rlini0-2AI-97MK", "ouWbwc-B2vQ7tR-DLi-H34g", "R1crmv-lhkakVD-Gg4-LBIv"] +17 ["gaRzuW-8ljPxnB-sG4-EPyR", "I1fCfi-dqF5jIV-xcO-qXxs", "vteojI-nipd8nC-GbM-BuCz", "OJtqcM-M4xJStL-DoO-pAVA", "cHaELA-NYH7FiQ-JRw-Pplg"] +18 ["eBNnB0-qIe9HyT-unn-r8Sg"] +19 \N +19 ["164Ucc-2m33JDj-cRk-xvJr", "3PFwGM-MbNcZmG-PsT-yVEO", "LoBi6u-BrGnZ72-PC2-Q3Dh", "4TJDnj-Fd9d8n6-epp-qcBk"] +19 ["7S1jZR-tqeJcs1-IpA-5u7g", "Y9Pj9d-i8aWERJ-x04-e82r", "6GzJ9a-9vDrDmO-OQ2-Hy6L", "CojUHC-RSlsTY2-ldc-M8kY"] +19 ["z10C0S-v1Ly6UA-5fZ-N2Yz", "vUqsQc-OZznYLV-Yfg-xOwn", "rtj7wC-1lnLARh-D0t-HIlb", "pVxrxW-2gjav4g-Gbq-DYRn"] +2 \N +2 ["lWGk4M-ba0tBFf-JVl-qYen", "2O1nVO-8pdtYoX-jaz-9Lyv"] +21 \N +21 ["2ru83o-BLrXeLD-FMI-AHCI", "AC5OaC-yOGE24o-n89-qUmQ"] +22 \N +22 ["0gexiD-Rm0IsA2-y58-HicR", "UJuCFr-5djHZIq-kDb-K99q", "wlwWKt-SfWP3Zt-0cn-TWsU", "RuzR9n-ebOPXLv-W34-cP0s", "W9ymXF-BGJIKS0-OyN-HXxv", "LvasIG-yAdylNu-YqF-vBLJ"] +22 ["5n8x3t-LCKiMt5-NFA-KPcT", "Vem133-dr9w7ZR-55U-609k", "ruAbsU-gKlQUeb-buH-0TDB", "j0f0ze-cVWoRTm-Rta-XvdD", "m075Dt-qWdRe3H-jes-VfHK", "ePYs8Y-YSwUPE4-QQ5-zNQG"] +22 ["6kV5kA-oLIN98n-R9x-CbOC", "FlQiW3-FMAuhIl-KUI-57m8", "mLZ5P5-Lk5B1T2-TcS-Sb3b", "D7hYvP-GD3AC4F-0NW-qKlY", "4ZRaDG-KDaPsCf-vve-j19b", "dWKEqu-eqVLEud-Oek-EXgF"] +22 ["V20VMl-FHaVSEY-tRf-EVLY", "TC4bsI-2dN4rbV-Bc4-nqLw", "zouZEJ-IcTifEo-dHk-RzX9", "o9pub3-4Dkuxvr-ATy-gsVM", "7MvH7l-L69XzoQ-11N-uePw", "ldifMl-rhQBFYS-WUP-x2sV"] +22 ["iM77UH-g1Pul89-YnQ-mOju", "JJekpT-wJk9ZZy-aou-6HRB", "AWo8ix-RbUagjG-UtD-zW75", "Kq1sq2-vPn2q8e-xuN-E4cr", "TBnH0L-56BECcO-tG9-Jo1F", "zf0TLE-QMDr10f-RTw-WhtA"] +23 \N +23 ["JXHEFv-2kkSptQ-ds9-olbF", "0FbJaV-hQsUOY0-cZy-g8yw", "DDNYmH-rqqsupW-DSF-ASYa", "oo3QSm-nleM2nm-7Mr-NckZ"] +23 ["UfsfRH-VVH8UqO-y5A-XYB8", "OiuYyd-lkJesJY-QGG-dQOY", "TIAbsF-lREUyDE-ZUA-oBBS", "LttgCp-vdSwX9h-EsY-Ycpf"] +23 ["yL4Enp-fyRljVc-FrV-jzA7", "cAAuwr-Ex4inWX-PGI-O1Pb", "P35UXH-Z4XfwS8-8bB-otWi", "GCtp6w-WRen8SV-VKh-1Fb0"] +24 \N +24 ["qbjB3i-xWRlUzF-YKl-Gbyt", "5OhXnX-6SEsMaG-ctZ-B7tV", "ZnGjr9-fxDj0iV-HtM-QwCc"] +24 ["wAacAz-fjaxrWS-Qll-q64P", "PFuBtw-gUkeoKF-mFD-ziIt", "YpcoBs-FYBjK5r-Z2c-r4Wf"] +5 \N +5 ["4Rff3K-TATMSg1-b6R-SmKN", "t1j5tX-dTCrxmn-idk-rk24", "7LW7Lq-cXYuy90-uyH-M6pK"] +5 ["YaKNfI-gV6lMRG-dio-Jg9D", "TC7wdG-1YvyDHG-HVV-rdRR", "8dMmjA-lA9oHx9-dSS-Fl86"] +7 \N +7 ["1KN2Cf-UE1ruFq-sRm-pW7A", "2lwurI-ANjel77-nhS-ahzI", "DR5JH4-WM6QRe7-FgQ-qHnV"] +7 ["UGG3Iy-bMW7c6T-fz9-WYOG", "SWWur3-zdHlN1q-527-UtFT", "XrCVm0-bbwQBay-lcn-vNTJ"] +8 \N +8 ["RjHATY-RbQXO8o-9kC-yMN6", "QIsZVT-SBeloLd-RgF-zws0", "6d2byV-qKIHXRn-mDF-TM1g"] +8 ["ZfdXEt-opP9k3J-l2M-sIdX", "CyLrQr-KniPD7H-VaF-y563", "UtVD3f-NsX6D4j-UQt-Pgpg"] +9 \N +9 ["CSwQYw-bvMIUzj-bqf-AXpo", "tc0Rwz-uQ3Wdbv-z8f-qklW", "X6X0G8-JlYcXKh-pay-D21m", "n7RWXW-ZFh2HqS-6XE-v9TY", "zAXTa3-zz5OkX6-jAM-ZuyD", "UXdt9B-Mml6eBa-hN7-vQOp"] +9 ["FxiSSg-4B2Ep4r-AoC-nwwf", "QIafe6-b9ETKKv-WTq-wXnZ", "vP0uXm-5lRFe5D-R6o-58Jt", "UnzUJl-DXv294E-ozf-KgZF", "0ikQZL-ORqwsFr-fGs-flzQ", "Ltap6E-siSL3Hm-h0i-sKp2"] +9 ["Hi9Osx-9BogT7m-XBD-rtEV", "xoF9Rq-MshvMLG-jEJ-8965", "k5LrCO-6jQD17H-6jT-zYVY", "UYAu4H-KgjxcmP-XyO-ZFQJ", "eQVglX-V5YAuIJ-xC7-RYgL", "QydLV7-7XqcCuO-rlG-w7ba"] +9 ["n14avO-lueGLXs-zxM-tOEZ", "yj4iMW-h1Z5isV-jM4-0BRC", "YXg40k-p00nu3H-DLQ-ASu2", "KOg34p-E4TtdAs-xcl-ajzL", "d0LfzZ-2huMiVN-4Fc-aOuz", "2cJHzT-KjvF9cE-W5u-nOrI"] +9 ["xI0TNh-wAH12NI-6Px-MLib", "Jmesk7-hJzDXz6-lFC-Egmp", "YFtlSh-8pZVVxG-mNa-RYES", "q5sDuB-WfmqXDr-WXJ-UPq6", "3Toro7-4wzAPD9-G6e-ajl1", "bE4dED-fNBqL16-JXt-0lZY"] + +-- !sql -- +0 {"swpp0q-vgNTgMG-U1h-GrtK":"5", "e0bNvm-ZuCo9v7-Gu1-9qsJ":"9", "CW2OBW-ET71l4k-wke-B8pK":"3", "ydO2p2-64OmnPD-JT1-Xe9q":"6", "b9P9Pj-8o3jgFn-E5G-M6Wx":"3"} +0 {"swpp0q-vgNTgMG-U1h-GrtK":"5", "e0bNvm-ZuCo9v7-Gu1-9qsJ":"9", "CW2OBW-ET71l4k-wke-B8pK":"3", "ydO2p2-64OmnPD-JT1-Xe9q":"6", "b9P9Pj-8o3jgFn-E5G-M6Wx":"3"} +0 {"swpp0q-vgNTgMG-U1h-GrtK":"5", "e0bNvm-ZuCo9v7-Gu1-9qsJ":"9", "CW2OBW-ET71l4k-wke-B8pK":"3", "ydO2p2-64OmnPD-JT1-Xe9q":"6", "b9P9Pj-8o3jgFn-E5G-M6Wx":"3"} +0 {"swpp0q-vgNTgMG-U1h-GrtK":"5", "e0bNvm-ZuCo9v7-Gu1-9qsJ":"9", "CW2OBW-ET71l4k-wke-B8pK":"3", "ydO2p2-64OmnPD-JT1-Xe9q":"6", "b9P9Pj-8o3jgFn-E5G-M6Wx":"3"} +0 {"swpp0q-vgNTgMG-U1h-GrtK":"5", "e0bNvm-ZuCo9v7-Gu1-9qsJ":"9", "CW2OBW-ET71l4k-wke-B8pK":"3", "ydO2p2-64OmnPD-JT1-Xe9q":"6", "b9P9Pj-8o3jgFn-E5G-M6Wx":"3"} +0 {"swpp0q-vgNTgMG-U1h-GrtK":"5", "e0bNvm-ZuCo9v7-Gu1-9qsJ":"9", "CW2OBW-ET71l4k-wke-B8pK":"3", "ydO2p2-64OmnPD-JT1-Xe9q":"6", "b9P9Pj-8o3jgFn-E5G-M6Wx":"3"} +0 {"swpp0q-vgNTgMG-U1h-GrtK":"5", "e0bNvm-ZuCo9v7-Gu1-9qsJ":"9", "CW2OBW-ET71l4k-wke-B8pK":"3", "ydO2p2-64OmnPD-JT1-Xe9q":"6", "b9P9Pj-8o3jgFn-E5G-M6Wx":"3"} +1 {"nKWQnv-HolfdQc-tqs-Trnb":"0", "GEAmQi-bMHzvyG-MGd-GBjA":"5", "KtMT9e-jKcWd9t-9GG-8mG6":"3", "znKFYo-4abMgt6-k4A-L4Ki":"4", "IpXgBa-FGiyskO-R5R-T3CY":"6"} +1 {"nKWQnv-HolfdQc-tqs-Trnb":"0", "GEAmQi-bMHzvyG-MGd-GBjA":"5", "KtMT9e-jKcWd9t-9GG-8mG6":"3", "znKFYo-4abMgt6-k4A-L4Ki":"4", "IpXgBa-FGiyskO-R5R-T3CY":"6"} +1 {"nKWQnv-HolfdQc-tqs-Trnb":"0", "GEAmQi-bMHzvyG-MGd-GBjA":"5", "KtMT9e-jKcWd9t-9GG-8mG6":"3", "znKFYo-4abMgt6-k4A-L4Ki":"4", "IpXgBa-FGiyskO-R5R-T3CY":"6"} +1 {"nKWQnv-HolfdQc-tqs-Trnb":"0", "GEAmQi-bMHzvyG-MGd-GBjA":"5", "KtMT9e-jKcWd9t-9GG-8mG6":"3", "znKFYo-4abMgt6-k4A-L4Ki":"4", "IpXgBa-FGiyskO-R5R-T3CY":"6"} +1 {"nKWQnv-HolfdQc-tqs-Trnb":"0", "GEAmQi-bMHzvyG-MGd-GBjA":"5", "KtMT9e-jKcWd9t-9GG-8mG6":"3", "znKFYo-4abMgt6-k4A-L4Ki":"4", "IpXgBa-FGiyskO-R5R-T3CY":"6"} +1 {"nKWQnv-HolfdQc-tqs-Trnb":"0", "GEAmQi-bMHzvyG-MGd-GBjA":"5", "KtMT9e-jKcWd9t-9GG-8mG6":"3", "znKFYo-4abMgt6-k4A-L4Ki":"4", "IpXgBa-FGiyskO-R5R-T3CY":"6"} +10 {"kpjXle-CayOe2S-2W4-vqvG":"4", "VIWvQo-q2swzEQ-loT-PpQA":"9", "PnLRPK-AW1LRJj-QDh-WLfE":"5", "vGVTU8-SbgpatL-PXh-6DPp":"0", "YPH9gI-Uv5Ec0u-QHJ-5QKd":"3"} +10 {"kpjXle-CayOe2S-2W4-vqvG":"4", "VIWvQo-q2swzEQ-loT-PpQA":"9", "PnLRPK-AW1LRJj-QDh-WLfE":"5", "vGVTU8-SbgpatL-PXh-6DPp":"0", "YPH9gI-Uv5Ec0u-QHJ-5QKd":"3"} +10 {"kpjXle-CayOe2S-2W4-vqvG":"4", "VIWvQo-q2swzEQ-loT-PpQA":"9", "PnLRPK-AW1LRJj-QDh-WLfE":"5", "vGVTU8-SbgpatL-PXh-6DPp":"0", "YPH9gI-Uv5Ec0u-QHJ-5QKd":"3"} +10 {"kpjXle-CayOe2S-2W4-vqvG":"4", "VIWvQo-q2swzEQ-loT-PpQA":"9", "PnLRPK-AW1LRJj-QDh-WLfE":"5", "vGVTU8-SbgpatL-PXh-6DPp":"0", "YPH9gI-Uv5Ec0u-QHJ-5QKd":"3"} +10 {"kpjXle-CayOe2S-2W4-vqvG":"4", "VIWvQo-q2swzEQ-loT-PpQA":"9", "PnLRPK-AW1LRJj-QDh-WLfE":"5", "vGVTU8-SbgpatL-PXh-6DPp":"0", "YPH9gI-Uv5Ec0u-QHJ-5QKd":"3"} +11 {"Mqzc3X-DzSmJor-o9C-g73I":"4", "Xgdg1m-DZzCOqO-7pA-PKeS":"6", "JzTEl1-CwOaAmt-yV3-n2k0":"9", "pm0RBB-gdAl37a-8Pq-QLJV":"4", "oN1HDX-xCm8dRv-0wk-MJeu":"8"} +11 {"Mqzc3X-DzSmJor-o9C-g73I":"4", "Xgdg1m-DZzCOqO-7pA-PKeS":"6", "JzTEl1-CwOaAmt-yV3-n2k0":"9", "pm0RBB-gdAl37a-8Pq-QLJV":"4", "oN1HDX-xCm8dRv-0wk-MJeu":"8"} +11 {"Mqzc3X-DzSmJor-o9C-g73I":"4", "Xgdg1m-DZzCOqO-7pA-PKeS":"6", "JzTEl1-CwOaAmt-yV3-n2k0":"9", "pm0RBB-gdAl37a-8Pq-QLJV":"4", "oN1HDX-xCm8dRv-0wk-MJeu":"8"} +12 {"GFBqsx-TvhMATX-6ZB-0Zva":"2", "D6QtvK-8eTn7dE-CZn-h18O":"2", "tdKmN3-ealR73D-PO4-6nh8":"4", "veE9Ee-GBc3xZa-O1T-n8u3":"5", "0P9fws-Pb03WDb-lOu-l4Ww":"7"} +12 {"GFBqsx-TvhMATX-6ZB-0Zva":"2", "D6QtvK-8eTn7dE-CZn-h18O":"2", "tdKmN3-ealR73D-PO4-6nh8":"4", "veE9Ee-GBc3xZa-O1T-n8u3":"5", "0P9fws-Pb03WDb-lOu-l4Ww":"7"} +12 {"GFBqsx-TvhMATX-6ZB-0Zva":"2", "D6QtvK-8eTn7dE-CZn-h18O":"2", "tdKmN3-ealR73D-PO4-6nh8":"4", "veE9Ee-GBc3xZa-O1T-n8u3":"5", "0P9fws-Pb03WDb-lOu-l4Ww":"7"} +13 {"kIpyuK-FUQet1S-6JW-PJjH":"0", "KosGlG-X9weJpR-Olb-qNNY":"4", "x8HUd5-IzLbruK-ruY-HPIv":"8", "UaBaT4-ZKtEsWB-yJ7-ikwZ":"2", "tyiuhU-08ulAju-XWn-fsID":"6"} +13 {"kIpyuK-FUQet1S-6JW-PJjH":"0", "KosGlG-X9weJpR-Olb-qNNY":"4", "x8HUd5-IzLbruK-ruY-HPIv":"8", "UaBaT4-ZKtEsWB-yJ7-ikwZ":"2", "tyiuhU-08ulAju-XWn-fsID":"6"} +13 {"kIpyuK-FUQet1S-6JW-PJjH":"0", "KosGlG-X9weJpR-Olb-qNNY":"4", "x8HUd5-IzLbruK-ruY-HPIv":"8", "UaBaT4-ZKtEsWB-yJ7-ikwZ":"2", "tyiuhU-08ulAju-XWn-fsID":"6"} +14 {"Jfv2A1-Nh98daR-5eV-63xx":"9", "iqv9Dc-AovBuni-nRH-XnEZ":"1", "OQkgBo-duRmhW2-pTI-dSTS":"0", "pfWZRg-8lXC9OV-NPT-nHjl":"4", "Wso7dF-rmVTlDS-s9Q-MGtf":"0"} +14 {"Jfv2A1-Nh98daR-5eV-63xx":"9", "iqv9Dc-AovBuni-nRH-XnEZ":"1", "OQkgBo-duRmhW2-pTI-dSTS":"0", "pfWZRg-8lXC9OV-NPT-nHjl":"4", "Wso7dF-rmVTlDS-s9Q-MGtf":"0"} +14 {"Jfv2A1-Nh98daR-5eV-63xx":"9", "iqv9Dc-AovBuni-nRH-XnEZ":"1", "OQkgBo-duRmhW2-pTI-dSTS":"0", "pfWZRg-8lXC9OV-NPT-nHjl":"4", "Wso7dF-rmVTlDS-s9Q-MGtf":"0"} +14 {"Jfv2A1-Nh98daR-5eV-63xx":"9", "iqv9Dc-AovBuni-nRH-XnEZ":"1", "OQkgBo-duRmhW2-pTI-dSTS":"0", "pfWZRg-8lXC9OV-NPT-nHjl":"4", "Wso7dF-rmVTlDS-s9Q-MGtf":"0"} +14 {"Jfv2A1-Nh98daR-5eV-63xx":"9", "iqv9Dc-AovBuni-nRH-XnEZ":"1", "OQkgBo-duRmhW2-pTI-dSTS":"0", "pfWZRg-8lXC9OV-NPT-nHjl":"4", "Wso7dF-rmVTlDS-s9Q-MGtf":"0"} +14 {"Jfv2A1-Nh98daR-5eV-63xx":"9", "iqv9Dc-AovBuni-nRH-XnEZ":"1", "OQkgBo-duRmhW2-pTI-dSTS":"0", "pfWZRg-8lXC9OV-NPT-nHjl":"4", "Wso7dF-rmVTlDS-s9Q-MGtf":"0"} +14 {"Jfv2A1-Nh98daR-5eV-63xx":"9", "iqv9Dc-AovBuni-nRH-XnEZ":"1", "OQkgBo-duRmhW2-pTI-dSTS":"0", "pfWZRg-8lXC9OV-NPT-nHjl":"4", "Wso7dF-rmVTlDS-s9Q-MGtf":"0"} +14 {"Jfv2A1-Nh98daR-5eV-63xx":"9", "iqv9Dc-AovBuni-nRH-XnEZ":"1", "OQkgBo-duRmhW2-pTI-dSTS":"0", "pfWZRg-8lXC9OV-NPT-nHjl":"4", "Wso7dF-rmVTlDS-s9Q-MGtf":"0"} +14 {"Jfv2A1-Nh98daR-5eV-63xx":"9", "iqv9Dc-AovBuni-nRH-XnEZ":"1", "OQkgBo-duRmhW2-pTI-dSTS":"0", "pfWZRg-8lXC9OV-NPT-nHjl":"4", "Wso7dF-rmVTlDS-s9Q-MGtf":"0"} +15 {"ZZoIk6-FCvllrX-ynY-WH9b":"8", "Lo6mI2-FUuG0Kp-ALg-N9CN":"2", "lFhxJ0-iaZhTSc-XKg-Ats9":"9", "hiaVfD-qDapBgY-DBu-uCif":"1", "i5zkzH-UFvf6zO-ubG-bDEb":"9"} +15 {"ZZoIk6-FCvllrX-ynY-WH9b":"8", "Lo6mI2-FUuG0Kp-ALg-N9CN":"2", "lFhxJ0-iaZhTSc-XKg-Ats9":"9", "hiaVfD-qDapBgY-DBu-uCif":"1", "i5zkzH-UFvf6zO-ubG-bDEb":"9"} +15 {"ZZoIk6-FCvllrX-ynY-WH9b":"8", "Lo6mI2-FUuG0Kp-ALg-N9CN":"2", "lFhxJ0-iaZhTSc-XKg-Ats9":"9", "hiaVfD-qDapBgY-DBu-uCif":"1", "i5zkzH-UFvf6zO-ubG-bDEb":"9"} +15 {"ZZoIk6-FCvllrX-ynY-WH9b":"8", "Lo6mI2-FUuG0Kp-ALg-N9CN":"2", "lFhxJ0-iaZhTSc-XKg-Ats9":"9", "hiaVfD-qDapBgY-DBu-uCif":"1", "i5zkzH-UFvf6zO-ubG-bDEb":"9"} +16 {"6HGUM0-YSULhQm-tNd-WrUB":"6", "2iQyQQ-0Q79hSa-xas-mA1b":"2", "kHyrvC-FG8yKzY-bJi-FTGR":"5", "kCKYlJ-LlfcyEz-Zzc-pcuw":"2", "D97U6o-rNR0M8j-7FD-yB2i":"2"} +16 {"6HGUM0-YSULhQm-tNd-WrUB":"6", "2iQyQQ-0Q79hSa-xas-mA1b":"2", "kHyrvC-FG8yKzY-bJi-FTGR":"5", "kCKYlJ-LlfcyEz-Zzc-pcuw":"2", "D97U6o-rNR0M8j-7FD-yB2i":"2"} +16 {"6HGUM0-YSULhQm-tNd-WrUB":"6", "2iQyQQ-0Q79hSa-xas-mA1b":"2", "kHyrvC-FG8yKzY-bJi-FTGR":"5", "kCKYlJ-LlfcyEz-Zzc-pcuw":"2", "D97U6o-rNR0M8j-7FD-yB2i":"2"} +16 {"6HGUM0-YSULhQm-tNd-WrUB":"6", "2iQyQQ-0Q79hSa-xas-mA1b":"2", "kHyrvC-FG8yKzY-bJi-FTGR":"5", "kCKYlJ-LlfcyEz-Zzc-pcuw":"2", "D97U6o-rNR0M8j-7FD-yB2i":"2"} +16 {"6HGUM0-YSULhQm-tNd-WrUB":"6", "2iQyQQ-0Q79hSa-xas-mA1b":"2", "kHyrvC-FG8yKzY-bJi-FTGR":"5", "kCKYlJ-LlfcyEz-Zzc-pcuw":"2", "D97U6o-rNR0M8j-7FD-yB2i":"2"} +16 {"6HGUM0-YSULhQm-tNd-WrUB":"6", "2iQyQQ-0Q79hSa-xas-mA1b":"2", "kHyrvC-FG8yKzY-bJi-FTGR":"5", "kCKYlJ-LlfcyEz-Zzc-pcuw":"2", "D97U6o-rNR0M8j-7FD-yB2i":"2"} +16 {"6HGUM0-YSULhQm-tNd-WrUB":"6", "2iQyQQ-0Q79hSa-xas-mA1b":"2", "kHyrvC-FG8yKzY-bJi-FTGR":"5", "kCKYlJ-LlfcyEz-Zzc-pcuw":"2", "D97U6o-rNR0M8j-7FD-yB2i":"2"} +17 {"pvJ17T-e8sUqJE-UAM-3HJC":"1", "UqYyHo-6j72MWA-06u-ITXN":"0", "ALehFX-Jdmwn4V-i9x-VnTD":"6", "WRr0E1-5qGq3uV-MGG-8ugQ":"1", "JKKvYY-N1BCDLk-JBF-K7FN":"2"} +17 {"pvJ17T-e8sUqJE-UAM-3HJC":"1", "UqYyHo-6j72MWA-06u-ITXN":"0", "ALehFX-Jdmwn4V-i9x-VnTD":"6", "WRr0E1-5qGq3uV-MGG-8ugQ":"1", "JKKvYY-N1BCDLk-JBF-K7FN":"2"} +17 {"pvJ17T-e8sUqJE-UAM-3HJC":"1", "UqYyHo-6j72MWA-06u-ITXN":"0", "ALehFX-Jdmwn4V-i9x-VnTD":"6", "WRr0E1-5qGq3uV-MGG-8ugQ":"1", "JKKvYY-N1BCDLk-JBF-K7FN":"2"} +17 {"pvJ17T-e8sUqJE-UAM-3HJC":"1", "UqYyHo-6j72MWA-06u-ITXN":"0", "ALehFX-Jdmwn4V-i9x-VnTD":"6", "WRr0E1-5qGq3uV-MGG-8ugQ":"1", "JKKvYY-N1BCDLk-JBF-K7FN":"2"} +17 {"pvJ17T-e8sUqJE-UAM-3HJC":"1", "UqYyHo-6j72MWA-06u-ITXN":"0", "ALehFX-Jdmwn4V-i9x-VnTD":"6", "WRr0E1-5qGq3uV-MGG-8ugQ":"1", "JKKvYY-N1BCDLk-JBF-K7FN":"2"} +17 {"pvJ17T-e8sUqJE-UAM-3HJC":"1", "UqYyHo-6j72MWA-06u-ITXN":"0", "ALehFX-Jdmwn4V-i9x-VnTD":"6", "WRr0E1-5qGq3uV-MGG-8ugQ":"1", "JKKvYY-N1BCDLk-JBF-K7FN":"2"} +18 {"RSxqTF-B1xKGK9-9te-Z1xX":"0", "BcHNcY-Pwmjwi9-ZcZ-YE0Z":"8", "jLDmB5-YGodMV9-bTw-fa2T":"9", "u66Ef1-CwR2ipD-PME-fSP8":"1", "KDObx4-FHLBa7W-r44-z9tZ":"7"} +18 {"RSxqTF-B1xKGK9-9te-Z1xX":"0", "BcHNcY-Pwmjwi9-ZcZ-YE0Z":"8", "jLDmB5-YGodMV9-bTw-fa2T":"9", "u66Ef1-CwR2ipD-PME-fSP8":"1", "KDObx4-FHLBa7W-r44-z9tZ":"7"} +18 {"RSxqTF-B1xKGK9-9te-Z1xX":"0", "BcHNcY-Pwmjwi9-ZcZ-YE0Z":"8", "jLDmB5-YGodMV9-bTw-fa2T":"9", "u66Ef1-CwR2ipD-PME-fSP8":"1", "KDObx4-FHLBa7W-r44-z9tZ":"7"} +19 {"hBvx9O-RHmsr9n-bBE-h38U":"9", "tV1hKh-q5dhFb1-lfN-Mc3P":"0", "39ZYSM-aId3Vm9-Mjw-darG":"1", "v0P8jE-aSQ8EqB-Pld-3aSb":"7", "Pg5lQ0-cujZNmk-J9F-h9s4":"3"} +19 {"hBvx9O-RHmsr9n-bBE-h38U":"9", "tV1hKh-q5dhFb1-lfN-Mc3P":"0", "39ZYSM-aId3Vm9-Mjw-darG":"1", "v0P8jE-aSQ8EqB-Pld-3aSb":"7", "Pg5lQ0-cujZNmk-J9F-h9s4":"3"} +19 {"hBvx9O-RHmsr9n-bBE-h38U":"9", "tV1hKh-q5dhFb1-lfN-Mc3P":"0", "39ZYSM-aId3Vm9-Mjw-darG":"1", "v0P8jE-aSQ8EqB-Pld-3aSb":"7", "Pg5lQ0-cujZNmk-J9F-h9s4":"3"} +19 {"hBvx9O-RHmsr9n-bBE-h38U":"9", "tV1hKh-q5dhFb1-lfN-Mc3P":"0", "39ZYSM-aId3Vm9-Mjw-darG":"1", "v0P8jE-aSQ8EqB-Pld-3aSb":"7", "Pg5lQ0-cujZNmk-J9F-h9s4":"3"} +19 {"hBvx9O-RHmsr9n-bBE-h38U":"9", "tV1hKh-q5dhFb1-lfN-Mc3P":"0", "39ZYSM-aId3Vm9-Mjw-darG":"1", "v0P8jE-aSQ8EqB-Pld-3aSb":"7", "Pg5lQ0-cujZNmk-J9F-h9s4":"3"} +19 {"hBvx9O-RHmsr9n-bBE-h38U":"9", "tV1hKh-q5dhFb1-lfN-Mc3P":"0", "39ZYSM-aId3Vm9-Mjw-darG":"1", "v0P8jE-aSQ8EqB-Pld-3aSb":"7", "Pg5lQ0-cujZNmk-J9F-h9s4":"3"} +19 {"hBvx9O-RHmsr9n-bBE-h38U":"9", "tV1hKh-q5dhFb1-lfN-Mc3P":"0", "39ZYSM-aId3Vm9-Mjw-darG":"1", "v0P8jE-aSQ8EqB-Pld-3aSb":"7", "Pg5lQ0-cujZNmk-J9F-h9s4":"3"} +2 {"N1isOk-HqyCfZ3-Iqu-sHC4":"8", "zoEAUW-yYiiBxG-xER-4AVu":"0", "y6OK1G-wIHaG2A-oWB-WQel":"3", "oWys2y-FLQKf53-5mm-3BWr":"9", "Kkjpbh-vOvz3Hu-WdS-UVI6":"4"} +2 {"N1isOk-HqyCfZ3-Iqu-sHC4":"8", "zoEAUW-yYiiBxG-xER-4AVu":"0", "y6OK1G-wIHaG2A-oWB-WQel":"3", "oWys2y-FLQKf53-5mm-3BWr":"9", "Kkjpbh-vOvz3Hu-WdS-UVI6":"4"} +20 {"HJs9wu-EjXKZA0-AGv-Toi8":"4", "T7URbX-187t8gX-tYf-ks7L":"3", "f4i0Uf-oBOVCl5-1qx-n9Ss":"9", "sqsjvC-u9ge35C-KFD-86lp":"3", "n19oZV-8Ov2kKD-KWf-zb2s":"5"} +20 {"HJs9wu-EjXKZA0-AGv-Toi8":"4", "T7URbX-187t8gX-tYf-ks7L":"3", "f4i0Uf-oBOVCl5-1qx-n9Ss":"9", "sqsjvC-u9ge35C-KFD-86lp":"3", "n19oZV-8Ov2kKD-KWf-zb2s":"5"} +21 {"xwlOrk-MpiP6RS-Vm4-XKef":"3", "PTSQoh-9NkO5Sr-Bj9-DaSB":"3", "hC1kwZ-RkpFtX4-ALg-4nMp":"8", "CJwJkc-Q3Gn7BI-M2Z-jM3Q":"5", "MAug88-UBrKX5Q-W3w-ztwL":"2"} +21 {"xwlOrk-MpiP6RS-Vm4-XKef":"3", "PTSQoh-9NkO5Sr-Bj9-DaSB":"3", "hC1kwZ-RkpFtX4-ALg-4nMp":"8", "CJwJkc-Q3Gn7BI-M2Z-jM3Q":"5", "MAug88-UBrKX5Q-W3w-ztwL":"2"} +22 {"rY0E6a-ZcJhbVo-uWR-GmOY":"8", "Am9um1-LmHKPQy-pfo-wJcc":"4", "YMpSaO-IPhoMxN-p83-kc9V":"2", "rmWbeI-DqKZ4jH-NyE-7dW1":"2", "iiPxMz-2yRjDuq-dkc-Axcq":"5"} +22 {"rY0E6a-ZcJhbVo-uWR-GmOY":"8", "Am9um1-LmHKPQy-pfo-wJcc":"4", "YMpSaO-IPhoMxN-p83-kc9V":"2", "rmWbeI-DqKZ4jH-NyE-7dW1":"2", "iiPxMz-2yRjDuq-dkc-Axcq":"5"} +22 {"rY0E6a-ZcJhbVo-uWR-GmOY":"8", "Am9um1-LmHKPQy-pfo-wJcc":"4", "YMpSaO-IPhoMxN-p83-kc9V":"2", "rmWbeI-DqKZ4jH-NyE-7dW1":"2", "iiPxMz-2yRjDuq-dkc-Axcq":"5"} +22 {"rY0E6a-ZcJhbVo-uWR-GmOY":"8", "Am9um1-LmHKPQy-pfo-wJcc":"4", "YMpSaO-IPhoMxN-p83-kc9V":"2", "rmWbeI-DqKZ4jH-NyE-7dW1":"2", "iiPxMz-2yRjDuq-dkc-Axcq":"5"} +22 {"rY0E6a-ZcJhbVo-uWR-GmOY":"8", "Am9um1-LmHKPQy-pfo-wJcc":"4", "YMpSaO-IPhoMxN-p83-kc9V":"2", "rmWbeI-DqKZ4jH-NyE-7dW1":"2", "iiPxMz-2yRjDuq-dkc-Axcq":"5"} +22 {"rY0E6a-ZcJhbVo-uWR-GmOY":"8", "Am9um1-LmHKPQy-pfo-wJcc":"4", "YMpSaO-IPhoMxN-p83-kc9V":"2", "rmWbeI-DqKZ4jH-NyE-7dW1":"2", "iiPxMz-2yRjDuq-dkc-Axcq":"5"} +22 {"rY0E6a-ZcJhbVo-uWR-GmOY":"8", "Am9um1-LmHKPQy-pfo-wJcc":"4", "YMpSaO-IPhoMxN-p83-kc9V":"2", "rmWbeI-DqKZ4jH-NyE-7dW1":"2", "iiPxMz-2yRjDuq-dkc-Axcq":"5"} +22 {"rY0E6a-ZcJhbVo-uWR-GmOY":"8", "Am9um1-LmHKPQy-pfo-wJcc":"4", "YMpSaO-IPhoMxN-p83-kc9V":"2", "rmWbeI-DqKZ4jH-NyE-7dW1":"2", "iiPxMz-2yRjDuq-dkc-Axcq":"5"} +23 {"JGQBg2-5qtPR8C-5Re-twPm":"6", "Uj4xhW-KbWI4mC-72t-eepp":"3", "27tztk-g7ind7U-jKv-QuhC":"3", "iOwSq6-VqdFNrm-2nm-hY1n":"0", "bct8XY-dpPRzHE-k2n-kTH2":"0"} +23 {"JGQBg2-5qtPR8C-5Re-twPm":"6", "Uj4xhW-KbWI4mC-72t-eepp":"3", "27tztk-g7ind7U-jKv-QuhC":"3", "iOwSq6-VqdFNrm-2nm-hY1n":"0", "bct8XY-dpPRzHE-k2n-kTH2":"0"} +23 {"JGQBg2-5qtPR8C-5Re-twPm":"6", "Uj4xhW-KbWI4mC-72t-eepp":"3", "27tztk-g7ind7U-jKv-QuhC":"3", "iOwSq6-VqdFNrm-2nm-hY1n":"0", "bct8XY-dpPRzHE-k2n-kTH2":"0"} +23 {"JGQBg2-5qtPR8C-5Re-twPm":"6", "Uj4xhW-KbWI4mC-72t-eepp":"3", "27tztk-g7ind7U-jKv-QuhC":"3", "iOwSq6-VqdFNrm-2nm-hY1n":"0", "bct8XY-dpPRzHE-k2n-kTH2":"0"} +23 {"JGQBg2-5qtPR8C-5Re-twPm":"6", "Uj4xhW-KbWI4mC-72t-eepp":"3", "27tztk-g7ind7U-jKv-QuhC":"3", "iOwSq6-VqdFNrm-2nm-hY1n":"0", "bct8XY-dpPRzHE-k2n-kTH2":"0"} +23 {"JGQBg2-5qtPR8C-5Re-twPm":"6", "Uj4xhW-KbWI4mC-72t-eepp":"3", "27tztk-g7ind7U-jKv-QuhC":"3", "iOwSq6-VqdFNrm-2nm-hY1n":"0", "bct8XY-dpPRzHE-k2n-kTH2":"0"} +23 {"JGQBg2-5qtPR8C-5Re-twPm":"6", "Uj4xhW-KbWI4mC-72t-eepp":"3", "27tztk-g7ind7U-jKv-QuhC":"3", "iOwSq6-VqdFNrm-2nm-hY1n":"0", "bct8XY-dpPRzHE-k2n-kTH2":"0"} +24 {"Avnja3-OUO7GZp-Bbb-9WJ6":"5", "mLpE5W-beMQh4z-Z6P-jPjO":"9", "Rd3wR9-CHe1XzT-jcD-UBF3":"9", "gTx716-7et3HUP-jfk-oXWX":"1", "nEC8vl-y54mkM0-LKD-s18Q":"8"} +24 {"Avnja3-OUO7GZp-Bbb-9WJ6":"5", "mLpE5W-beMQh4z-Z6P-jPjO":"9", "Rd3wR9-CHe1XzT-jcD-UBF3":"9", "gTx716-7et3HUP-jfk-oXWX":"1", "nEC8vl-y54mkM0-LKD-s18Q":"8"} +24 {"Avnja3-OUO7GZp-Bbb-9WJ6":"5", "mLpE5W-beMQh4z-Z6P-jPjO":"9", "Rd3wR9-CHe1XzT-jcD-UBF3":"9", "gTx716-7et3HUP-jfk-oXWX":"1", "nEC8vl-y54mkM0-LKD-s18Q":"8"} +24 {"Avnja3-OUO7GZp-Bbb-9WJ6":"5", "mLpE5W-beMQh4z-Z6P-jPjO":"9", "Rd3wR9-CHe1XzT-jcD-UBF3":"9", "gTx716-7et3HUP-jfk-oXWX":"1", "nEC8vl-y54mkM0-LKD-s18Q":"8"} +24 {"Avnja3-OUO7GZp-Bbb-9WJ6":"5", "mLpE5W-beMQh4z-Z6P-jPjO":"9", "Rd3wR9-CHe1XzT-jcD-UBF3":"9", "gTx716-7et3HUP-jfk-oXWX":"1", "nEC8vl-y54mkM0-LKD-s18Q":"8"} +24 {"Avnja3-OUO7GZp-Bbb-9WJ6":"5", "mLpE5W-beMQh4z-Z6P-jPjO":"9", "Rd3wR9-CHe1XzT-jcD-UBF3":"9", "gTx716-7et3HUP-jfk-oXWX":"1", "nEC8vl-y54mkM0-LKD-s18Q":"8"} +3 {"sAAkg4-TsxcHvG-PU5-reih":"0", "gLZA8c-BegqvvI-c8X-k2sG":"0", "XsjVET-cVWzizh-IQL-oD9Z":"3", "mn5po7-sdVBNfT-D1h-J9cr":"1", "VhWPpg-MjnLQxg-fQW-HSEW":"5"} +3 {"sAAkg4-TsxcHvG-PU5-reih":"0", "gLZA8c-BegqvvI-c8X-k2sG":"0", "XsjVET-cVWzizh-IQL-oD9Z":"3", "mn5po7-sdVBNfT-D1h-J9cr":"1", "VhWPpg-MjnLQxg-fQW-HSEW":"5"} +3 {"sAAkg4-TsxcHvG-PU5-reih":"0", "gLZA8c-BegqvvI-c8X-k2sG":"0", "XsjVET-cVWzizh-IQL-oD9Z":"3", "mn5po7-sdVBNfT-D1h-J9cr":"1", "VhWPpg-MjnLQxg-fQW-HSEW":"5"} +4 {"GW98C8-Xv6AWLP-ivi-FLtW":"0", "Q635Ar-OMGGYWX-Dhg-7HgP":"8", "TbeKcq-4AUGF5H-DzO-KwWg":"6", "fKDLAp-tPmFPle-lF6-FGNZ":"1", "W5qTCQ-Lfqxf29-Z3J-9Yrz":"9"} +4 {"GW98C8-Xv6AWLP-ivi-FLtW":"0", "Q635Ar-OMGGYWX-Dhg-7HgP":"8", "TbeKcq-4AUGF5H-DzO-KwWg":"6", "fKDLAp-tPmFPle-lF6-FGNZ":"1", "W5qTCQ-Lfqxf29-Z3J-9Yrz":"9"} +5 {"iLOhUA-n05O2OY-LHB-qS3H":"8", "ATC5e8-MywwrP3-Vhc-QdxZ":"1", "fST2pb-uAaS3Mb-Pl6-9i1J":"0", "fppq1A-Q1WOvMj-Eod-xbTz":"3", "ebkDD2-T3jSVTg-zZS-Bqnh":"4"} +5 {"iLOhUA-n05O2OY-LHB-qS3H":"8", "ATC5e8-MywwrP3-Vhc-QdxZ":"1", "fST2pb-uAaS3Mb-Pl6-9i1J":"0", "fppq1A-Q1WOvMj-Eod-xbTz":"3", "ebkDD2-T3jSVTg-zZS-Bqnh":"4"} +5 {"iLOhUA-n05O2OY-LHB-qS3H":"8", "ATC5e8-MywwrP3-Vhc-QdxZ":"1", "fST2pb-uAaS3Mb-Pl6-9i1J":"0", "fppq1A-Q1WOvMj-Eod-xbTz":"3", "ebkDD2-T3jSVTg-zZS-Bqnh":"4"} +6 {"eSB1Yl-jDIrIHV-7WE-qyvM":"6", "4N8yoM-901A5FI-B9Q-3EpM":"9", "pBdMp1-nVbMzpB-WJj-dhDd":"4", "3jGdNP-NgyL5fW-9Ty-CLlY":"2", "5gaoHt-7MmTVLs-Jm0-KpaG":"2"} +6 {"eSB1Yl-jDIrIHV-7WE-qyvM":"6", "4N8yoM-901A5FI-B9Q-3EpM":"9", "pBdMp1-nVbMzpB-WJj-dhDd":"4", "3jGdNP-NgyL5fW-9Ty-CLlY":"2", "5gaoHt-7MmTVLs-Jm0-KpaG":"2"} +6 {"eSB1Yl-jDIrIHV-7WE-qyvM":"6", "4N8yoM-901A5FI-B9Q-3EpM":"9", "pBdMp1-nVbMzpB-WJj-dhDd":"4", "3jGdNP-NgyL5fW-9Ty-CLlY":"2", "5gaoHt-7MmTVLs-Jm0-KpaG":"2"} +7 {"yfDrEq-z2VBXi1-bSe-tgGW":"7", "zLkwFE-i6GiJut-yHW-e4wJ":"8", "pl1mqW-qSEYcv0-kTT-8Uuz":"3", "cEbTSo-CoT1upF-XsY-gafn":"8", "Shcq2l-iuYvkyo-ssN-okkW":"7"} +7 {"yfDrEq-z2VBXi1-bSe-tgGW":"7", "zLkwFE-i6GiJut-yHW-e4wJ":"8", "pl1mqW-qSEYcv0-kTT-8Uuz":"3", "cEbTSo-CoT1upF-XsY-gafn":"8", "Shcq2l-iuYvkyo-ssN-okkW":"7"} +7 {"yfDrEq-z2VBXi1-bSe-tgGW":"7", "zLkwFE-i6GiJut-yHW-e4wJ":"8", "pl1mqW-qSEYcv0-kTT-8Uuz":"3", "cEbTSo-CoT1upF-XsY-gafn":"8", "Shcq2l-iuYvkyo-ssN-okkW":"7"} +7 {"yfDrEq-z2VBXi1-bSe-tgGW":"7", "zLkwFE-i6GiJut-yHW-e4wJ":"8", "pl1mqW-qSEYcv0-kTT-8Uuz":"3", "cEbTSo-CoT1upF-XsY-gafn":"8", "Shcq2l-iuYvkyo-ssN-okkW":"7"} +8 {"lJFCyu-BhT7N4x-luz-9t85":"2", "wGuvM7-zJNjFUz-4z3-Y6Gf":"7", "F9KCc5-ZzE0IYN-c5t-VqUH":"8", "FgXjJi-l10Pijy-jtK-WgMf":"4", "uexWAB-xHkHMYL-vUi-4Umt":"9"} +8 {"lJFCyu-BhT7N4x-luz-9t85":"2", "wGuvM7-zJNjFUz-4z3-Y6Gf":"7", "F9KCc5-ZzE0IYN-c5t-VqUH":"8", "FgXjJi-l10Pijy-jtK-WgMf":"4", "uexWAB-xHkHMYL-vUi-4Umt":"9"} +8 {"lJFCyu-BhT7N4x-luz-9t85":"2", "wGuvM7-zJNjFUz-4z3-Y6Gf":"7", "F9KCc5-ZzE0IYN-c5t-VqUH":"8", "FgXjJi-l10Pijy-jtK-WgMf":"4", "uexWAB-xHkHMYL-vUi-4Umt":"9"} +8 {"lJFCyu-BhT7N4x-luz-9t85":"2", "wGuvM7-zJNjFUz-4z3-Y6Gf":"7", "F9KCc5-ZzE0IYN-c5t-VqUH":"8", "FgXjJi-l10Pijy-jtK-WgMf":"4", "uexWAB-xHkHMYL-vUi-4Umt":"9"} +8 {"lJFCyu-BhT7N4x-luz-9t85":"2", "wGuvM7-zJNjFUz-4z3-Y6Gf":"7", "F9KCc5-ZzE0IYN-c5t-VqUH":"8", "FgXjJi-l10Pijy-jtK-WgMf":"4", "uexWAB-xHkHMYL-vUi-4Umt":"9"} +8 {"lJFCyu-BhT7N4x-luz-9t85":"2", "wGuvM7-zJNjFUz-4z3-Y6Gf":"7", "F9KCc5-ZzE0IYN-c5t-VqUH":"8", "FgXjJi-l10Pijy-jtK-WgMf":"4", "uexWAB-xHkHMYL-vUi-4Umt":"9"} +9 {"s4d0hU-uWynWWe-eIf-ym5C":"9", "ANvepQ-oO7fMUr-qdl-XbUo":"4", "G16nau-7qY3fb1-UYL-oiNd":"5", "bVd4er-efUCDow-nzo-87fg":"2", "7I6zLI-hQTTlLe-sBr-oCTh":"7"} +9 {"s4d0hU-uWynWWe-eIf-ym5C":"9", "ANvepQ-oO7fMUr-qdl-XbUo":"4", "G16nau-7qY3fb1-UYL-oiNd":"5", "bVd4er-efUCDow-nzo-87fg":"2", "7I6zLI-hQTTlLe-sBr-oCTh":"7"} +9 {"s4d0hU-uWynWWe-eIf-ym5C":"9", "ANvepQ-oO7fMUr-qdl-XbUo":"4", "G16nau-7qY3fb1-UYL-oiNd":"5", "bVd4er-efUCDow-nzo-87fg":"2", "7I6zLI-hQTTlLe-sBr-oCTh":"7"} +9 {"s4d0hU-uWynWWe-eIf-ym5C":"9", "ANvepQ-oO7fMUr-qdl-XbUo":"4", "G16nau-7qY3fb1-UYL-oiNd":"5", "bVd4er-efUCDow-nzo-87fg":"2", "7I6zLI-hQTTlLe-sBr-oCTh":"7"} +9 {"s4d0hU-uWynWWe-eIf-ym5C":"9", "ANvepQ-oO7fMUr-qdl-XbUo":"4", "G16nau-7qY3fb1-UYL-oiNd":"5", "bVd4er-efUCDow-nzo-87fg":"2", "7I6zLI-hQTTlLe-sBr-oCTh":"7"} +9 {"s4d0hU-uWynWWe-eIf-ym5C":"9", "ANvepQ-oO7fMUr-qdl-XbUo":"4", "G16nau-7qY3fb1-UYL-oiNd":"5", "bVd4er-efUCDow-nzo-87fg":"2", "7I6zLI-hQTTlLe-sBr-oCTh":"7"} +9 {"s4d0hU-uWynWWe-eIf-ym5C":"9", "ANvepQ-oO7fMUr-qdl-XbUo":"4", "G16nau-7qY3fb1-UYL-oiNd":"5", "bVd4er-efUCDow-nzo-87fg":"2", "7I6zLI-hQTTlLe-sBr-oCTh":"7"} + diff --git a/regression-test/suites/query_p0/sql_functions/table_function/explode.groovy b/regression-test/suites/query_p0/sql_functions/table_function/explode.groovy index fabb847189a..982e27a9667 100644 --- a/regression-test/suites/query_p0/sql_functions/table_function/explode.groovy +++ b/regression-test/suites/query_p0/sql_functions/table_function/explode.groovy @@ -70,4 +70,71 @@ suite("explode") { sql "insert into baseall_explode_numbers values(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15);" qt_test4 """select k3,e from baseall_explode_numbers as U lateral view explode_numbers(5) tmp1 as e order by k3,e;""" qt_test5 """select k3,e from baseall_explode_numbers as U lateral view explode_numbers(10) tmp1 as e order by k3,e;""" + + // test array nested array | map for explode + def testTable = "tam" + def dataFile = "am.json" + sql """ DROP TABLE IF EXISTS $testTable; """ + sql """ + CREATE TABLE `$testTable` ( + `id` bigint(20) NULL, + `arr_arr` array<array<text>> NULL DEFAULT "[]", + `arr_map` array<MAP<text,text>> NULL DEFAULT "[]" + ) ENGINE=OLAP + DUPLICATE KEY(`id`) + COMMENT 'OLAP' + DISTRIBUTED BY HASH(`id`) BUCKETS 10 + PROPERTIES ( + "replication_allocation" = "tag.location.default: 1", + "is_being_synced" = "false", + "storage_format" = "V2", + "light_schema_change" = "true", + "disable_auto_compaction" = "false", + "enable_single_replica_compaction" = "false" + ); + """ + + streamLoad { + table testTable + + // set http request header params + file dataFile // import json file + set 'format', 'json' // import format + set 'read_json_by_line', 'true' // read json by line + set 'strict_mode', 'true' + time 10000 // limit inflight 10s + + // if declared a check callback, the default check condition will ignore. + // So you must check all condition + check { result, exception, startTime, endTime -> + if (exception != null) { + throw exception + } + log.info("Stream load result: ${result}".toString()) + def json = parseJson(result) + assertEquals("success", json.Status.toLowerCase()) + assertEquals(25, json.NumberTotalRows) + assertEquals(25, json.NumberLoadedRows) + assertEquals(0, json.NumberFilteredRows) + assertTrue(json.LoadBytes > 0) + } + } + + sql "sync" + + // check result + order_qt_sql """ select id, eaa from $testTable lateral view explode(arr_arr) aa as eaa order by id; """ + order_qt_sql """ select id, eam from $testTable lateral view explode(arr_map) aa as eam order by id; """ + + def res_origin_am = sql "select array_size(arr_map) from $testTable where array_size(arr_map) > 0 order by id;" + def res_explode_am = sql "select count() from (select id, eam from $testTable lateral view explode(arr_map) aa as eam order by id) as t1 group by id order by id;" + for (int r = 0; r < res_origin_am.size(); ++ r) { + assertEquals(res_origin_am[r][0], res_explode_am[r][0]) + } + + def res_origin_size_aa = sql "select array_size(arr_arr) from $testTable where array_size(arr_arr) > 0 order by id;" + def res_explode_aa = sql "select count() from (select id, eaa from $testTable lateral view explode(arr_arr) aa as eaa order by id) as t1 group by id order by id;" + for (int r = 0; r < res_origin_size_aa.size(); ++ r) { + assertEquals(res_origin_size_aa[r][0], res_explode_aa[r][0]) + } } --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
