This is an automated email from the ASF dual-hosted git repository.
kxiao pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 390c52f73a [Improve](complex-type) update for array/map element_at
with nested complex type with local tvf (#22927)
390c52f73a is described below
commit 390c52f73a2dc957fe4f44892aa9eec0fbcc5685
Author: amory <wangqian...@selectdb.com>
AuthorDate: Wed Aug 16 20:47:36 2023 +0800
[Improve](complex-type) update for array/map element_at with nested complex
type with local tvf (#22927)
---
be/src/vec/columns/column_array.cpp | 1 +
be/src/vec/columns/column_map.cpp | 1 +
.../vec/functions/array/function_array_element.h | 42 +++
gensrc/script/doris_builtins_functions.py | 19 +-
regression-test/data/external_table_p0/tvf/t.orc | Bin 0 -> 34739 bytes
.../data/external_table_p0/tvf/t.parquet | Bin 0 -> 37374 bytes
...test_local_tvf_with_complex_type_element_at.out | 385 +++++++++++++++++++++
...t_local_tvf_with_complex_type_element_at.groovy | 120 +++++++
8 files changed, 550 insertions(+), 18 deletions(-)
diff --git a/be/src/vec/columns/column_array.cpp
b/be/src/vec/columns/column_array.cpp
index 94ec98c104..7922b692b9 100644
--- a/be/src/vec/columns/column_array.cpp
+++ b/be/src/vec/columns/column_array.cpp
@@ -381,6 +381,7 @@ void ColumnArray::insert(const Field& x) {
}
void ColumnArray::insert_from(const IColumn& src_, size_t n) {
+ DCHECK(n < src_.size());
const ColumnArray& src = assert_cast<const ColumnArray&>(src_);
size_t size = src.size_at(n);
size_t offset = src.offset_at(n);
diff --git a/be/src/vec/columns/column_map.cpp
b/be/src/vec/columns/column_map.cpp
index 8126b3e4e6..1b460e1235 100644
--- a/be/src/vec/columns/column_map.cpp
+++ b/be/src/vec/columns/column_map.cpp
@@ -165,6 +165,7 @@ void ColumnMap::pop_back(size_t n) {
}
void ColumnMap::insert_from(const IColumn& src_, size_t n) {
+ DCHECK(n < src_.size());
const ColumnMap& src = assert_cast<const ColumnMap&>(src_);
size_t size = src.size_at(n);
size_t offset = src.offset_at(n);
diff --git a/be/src/vec/functions/array/function_array_element.h
b/be/src/vec/functions/array/function_array_element.h
index 6b4b26fdbb..c6cc27fbaf 100644
--- a/be/src/vec/functions/array/function_array_element.h
+++ b/be/src/vec/functions/array/function_array_element.h
@@ -35,6 +35,7 @@
#include "vec/columns/column_map.h"
#include "vec/columns/column_nullable.h"
#include "vec/columns/column_string.h"
+#include "vec/columns/column_struct.h"
#include "vec/columns/column_vector.h"
#include "vec/columns/columns_number.h"
#include "vec/core/block.h"
@@ -283,6 +284,44 @@ private:
return _execute_nullable(args, input_rows_count, src_null_map,
dst_null_map);
}
+ ColumnPtr _execute_common(const ColumnArray::Offsets64& offsets, const
IColumn& nested_column,
+ const UInt8* arr_null_map, const IColumn&
indices,
+ const UInt8* nested_null_map, UInt8*
dst_null_map) {
+ // prepare return data
+ auto dst_column = nested_column.clone_empty();
+ dst_column->reserve(offsets.size());
+
+ // process
+ for (size_t row = 0; row < offsets.size(); ++row) {
+ size_t off = offsets[row - 1];
+ size_t len = offsets[row] - off;
+ auto index = indices.get_int(row);
+ // array is nullable
+ bool null_flag = bool(arr_null_map && arr_null_map[row]);
+ // calc index in nested column
+ if (!null_flag && index > 0 && index <= len) {
+ index += off - 1;
+ } else if (!null_flag && index < 0 && -index <= len) {
+ index += off + len;
+ } else {
+ null_flag = true;
+ }
+ // nested column nullable check
+ if (!null_flag && nested_null_map && nested_null_map[index]) {
+ null_flag = true;
+ }
+ // actual data copy
+ if (!null_flag) {
+ dst_null_map[row] = false;
+ dst_column->insert_from(nested_column, index);
+ } else {
+ dst_null_map[row] = true;
+ dst_column->insert_default();
+ }
+ }
+ return dst_column;
+ }
+
ColumnPtr _execute_nullable(const ColumnsWithTypeAndName& arguments,
size_t input_rows_count,
const UInt8* src_null_map, UInt8*
dst_null_map) {
// check array nested column type and get data
@@ -356,6 +395,9 @@ private:
} else if (check_column<ColumnString>(*nested_column)) {
res = _execute_string(offsets, *nested_column, src_null_map,
*idx_col, nested_null_map,
dst_null_map);
+ } else {
+ res = _execute_common(offsets, *nested_column, src_null_map,
*idx_col, nested_null_map,
+ dst_null_map);
}
return res;
diff --git a/gensrc/script/doris_builtins_functions.py
b/gensrc/script/doris_builtins_functions.py
index a0141972a9..309e5f4c77 100644
--- a/gensrc/script/doris_builtins_functions.py
+++ b/gensrc/script/doris_builtins_functions.py
@@ -112,24 +112,7 @@ visible_functions = {
[['array'], 'ARRAY', ['VARCHAR', '...'], 'ALWAYS_NOT_NULLABLE'],
[['array'], 'ARRAY', ['STRING', '...'], 'ALWAYS_NOT_NULLABLE'],
- [['element_at', '%element_extract%'], 'BOOLEAN', ['ARRAY_BOOLEAN',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'TINYINT', ['ARRAY_TINYINT',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'SMALLINT', ['ARRAY_SMALLINT',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'INT', ['ARRAY_INT', 'BIGINT'],
'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'BIGINT', ['ARRAY_BIGINT',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'LARGEINT', ['ARRAY_LARGEINT',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'DATETIME', ['ARRAY_DATETIME',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'DATE', ['ARRAY_DATE',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'DATETIMEV2',
['ARRAY_DATETIMEV2', 'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'DATEV2', ['ARRAY_DATEV2',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'FLOAT', ['ARRAY_FLOAT',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'DOUBLE', ['ARRAY_DOUBLE',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'DECIMALV2', ['ARRAY_DECIMALV2',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'DECIMAL32', ['ARRAY_DECIMAL32',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'DECIMAL64', ['ARRAY_DECIMAL64',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'DECIMAL128',
['ARRAY_DECIMAL128', 'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'VARCHAR', ['ARRAY_VARCHAR',
'BIGINT'], 'ALWAYS_NULLABLE'],
- [['element_at', '%element_extract%'], 'STRING', ['ARRAY_STRING',
'BIGINT'], 'ALWAYS_NULLABLE'],
+ [['element_at', '%element_extract%'], 'T', ['ARRAY<T>', 'BIGINT'],
'ALWAYS_NULLABLE', ['T']],
[['arrays_overlap'], 'BOOLEAN', ['ARRAY_BOOLEAN', 'ARRAY_BOOLEAN'],
'ALWAYS_NULLABLE'],
[['arrays_overlap'], 'BOOLEAN', ['ARRAY_TINYINT', 'ARRAY_TINYINT'],
'ALWAYS_NULLABLE'],
diff --git a/regression-test/data/external_table_p0/tvf/t.orc
b/regression-test/data/external_table_p0/tvf/t.orc
new file mode 100644
index 0000000000..d75b0cd1c6
Binary files /dev/null and b/regression-test/data/external_table_p0/tvf/t.orc
differ
diff --git a/regression-test/data/external_table_p0/tvf/t.parquet
b/regression-test/data/external_table_p0/tvf/t.parquet
new file mode 100644
index 0000000000..d5d19a1358
Binary files /dev/null and
b/regression-test/data/external_table_p0/tvf/t.parquet differ
diff --git
a/regression-test/data/external_table_p0/tvf/test_local_tvf_with_complex_type_element_at.out
b/regression-test/data/external_table_p0/tvf/test_local_tvf_with_complex_type_element_at.out
new file mode 100644
index 0000000000..6eb690fc3f
--- /dev/null
+++
b/regression-test/data/external_table_p0/tvf/test_local_tvf_with_complex_type_element_at.out
@@ -0,0 +1,385 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !sql --
+0 [["iTUE6T-zQx5sOO-vv4-deqF", "vLe3JA-eZnkkQk-zfe-ut0y",
"NWIaCN-XdzsTNP-KLJ-Hqrp", "rWDGLP-5FaTZry-jC0-Xlsn",
"ASkTwf-OvAz4jg-ZEA-jXoc", NULL], ["DKSP4x-4AaZafD-4Kp-Hsbc",
"OZbq8t-ABXdDLc-Ft0-iqjO", "0m6zeE-WzGt5m3-6l6-bSXX",
"1mwW6v-H4nhrYs-N5V-vVbu", "SZmDUu-depKjuZ-6rH-ZLiI", NULL],
["LtoAxz-xlHmP3r-Mji-i4Uy", NULL, "HwSIfz-JT9pGO3-CUH-DBYu",
"virK5t-tD3RwKd-6A8-8vP5", "5rc7H3-6gTah4E-gFh-dPfQ",
"9KHsGS-Kwi9A2P-b9o-DKdB"], [NULL, "cfvv9x-rCh6iA1-GUw-GH5o",
"UfI9Jg-5lkmZiO-DYt-yaGP", [...]
+1 [["Nw7rQR-eYvzaRg-6fu-S5RP", NULL, "39gSxi-ukgVbpE-0xG-q2rg",
"CWeQmC-LgR0XYI-IOb-83jj", "P3X2uC-gQf9MvR-han-6Do7"],
["OXfQxL-qgn74yi-kpZ-Nu5e", "nzqSI3-L0LnOSD-zol-SnP2",
"TXxg4z-DewiNX7-BAU-iP5e", "hCoViF-gzSysZs-HXh-wiX6", NULL],
["qLUvvy-UPET2Zh-ep3-4Lmk", "JRKNGp-eIWt86e-akN-YdfU",
"03VORI-WOgdg0Z-Okp-HVco", "xh6cJG-0IUU3Ez-eso-1am5", NULL], NULL,
["qLcHeO-ZEGIX8f-I3W-tmwX", "otT5qh-TJmd70N-4bs-Mkln", NULL,
"Fz5Xzr-5fDkXzH-tCH-aI63", "fx2U06-kvIWO71-sq5-Wuuz"]] [{"cAT0Uq-NXQScTi-m
[...]
+2 [NULL, ["aQXL87-AlEp3js-eAN-BWxl", NULL, "arbrWQ-fymHFVI-4tC-wLla",
"H7oBcR-z1jDceN-GdX-EBkN", "nJeKwR-JcPZ7GO-pUf-J6wR"], [NULL,
"DPgjUq-glb7s6R-1Bh-1f30", "bcT2SQ-TrC711z-RPY-Snhb",
"wEV8R3-3Ewrk6B-RVM-bMKC", "pmegbp-3hQw9ce-Oyf-ueOr"], [NULL,
"XF8NMG-ahoJ2T4-8Rs-7LXP", "ePAQFX-GCLoBKg-3s4-zC6K",
"y7v7NU-XIDSIZ3-o8j-UlGv", "50X2xQ-jWPxmnZ-BTs-k6ne"],
["DqadIj-pwgpx6b-oal-CfSG", "cUxnyD-psT7ZF6-3Bc-mhTD",
"ZbcANj-kO5QwUr-kmk-q4hF", NULL, "vakvXr-zguDikm-sLl-JJKi"]]
[{"T6F6xF-Aid2GKl-r [...]
+3 [NULL, ["bIfoWj-3Ar5Wjp-xz1-48in", "XvFosh-uQXjgoV-6yy-3ECf", NULL,
"H8GxZl-bMua0XK-cS5-rhLF"], [NULL, "CZpnZ6-Z52h2J7-CM7-0CUn",
"c0SpPe-Bjk6Cxc-HZ1-DrSt", "RAmWqZ-8MLTws9-P4d-XGOV"],
["J3DcDx-SUKQtJ6-RY6-FTb2", "dphOjb-FS1jCCB-mBA-b6Xk", NULL,
"ifDTzP-ajNwh3E-3X0-0QhU"]] [{"CSwT2Z-1p7aWGt-6Gy-WGWF":2023-08-13},
{"E6lcKj-A9umF01-hcw-eK0N":2023-08-13}, {"i2eCtO-Uli0kep-XZm-CvBD":2023-08-13},
{"r87wiq-BYb6O66-R24-wpMz":2023-08-13}, {"LpWvsU-n2gnBdX-ehD-Ohph":2023-08-13},
{"48mHw6-5e0m00 [...]
+4 [["NEGRXI-W9aDpI8-6ee-STJd", "MqSRGf-aWe8r8m-4UO-Osxx", NULL,
"lkkJ7s-jY1TX5A-7j5-Obdp"], NULL, ["etwas8-ytAs1Mq-smJ-f8m7",
"3mNYnL-DzJptSg-ceb-RwDD", "3uMFOZ-3NuYplq-dNB-qvt2", NULL], [NULL,
"AyWI9X-Sg0GZZX-Smn-yuKC", "eJ9tGf-VSDIkC7-dmP-kanu",
"QAu862-9qypoqN-5i5-NgJC"]] [{"x2U6MV-DjXoCmi-wcE-Arlb":2023-08-13},
{"0sdEsc-NZdBJuo-btH-dyzf":2023-08-13}, {"3bRJte-CFfMlP4-S2K-Uv3W":2023-08-13},
{"zCkN8b-aQpfuzv-jRj-Yg1T":2023-08-13}, {"zb2gdH-MVuoN4l-IGJ-2Cvy":2023-08-13},
{"hLWbs5-qvEWes [...]
+5 [[NULL, "uMtr0D-TeQEbP2-eOW-HN2M", "HV3Cog-h3zrwXh-Fuo-sX3i"], NULL,
["bujTnU-xIXeFY6-hHC-JmK8", "bMfQBV-IA0EhFY-F41-8fX8", NULL]]
[{"lVFZ64-2jfVMcu-gFB-G7yZ":2023-08-13},
{"Uip0k6-FQjnJjF-UqJ-Hsfc":2023-08-13}, {"D5DNZC-VtCSH2D-PJQ-jB6h":2023-08-13}]
[{"H7mtvs-L811hm1-SmL-POuo", 8}, {"NEFi27-2q7FOPN-P05-EuBr", 1},
{"EX8Hbm-j6PAOjg-S7t-PcLt", 3}, {"ucO4im-NTCFuI8-wq8-s76k", 4}]
{"lnvzdc-3kPNu4W-DUR-geLG":{"3bXC4Z-I44gsvk-TDV-0N9e":0.31958650598621297,
"Y03ope-Ilv8Xwj-yqB-c3kQ":0.735165 [...]
+6 [[NULL, "CLTOPS-jAVlRsT-KJi-MGpp", "aaI5CG-zKIqnpY-6LJ-8ha3",
"j5l04l-Cxt3swb-I69-HnMO", "t2Dg8q-L36RcCP-shs-n4G6",
"oWEsH4-iv98d7e-1b6-4GTt"], ["iHQtkw-T6R0PKO-eaK-KFtW", NULL,
"nJlccN-Cd1dq6p-rN2-7lrE", "hnWlWH-UHisN0A-JJP-csGu",
"5oAXT4-kKLmhm2-0on-ZvbM", "nZg2rJ-pFZQo0P-E5J-i9Ht"],
["vWtw3f-MdspfHs-Oaa-myix", "eYpJsD-qM5RcM0-sxQ-pQyQ", NULL,
"7aJhdF-wlqtD1F-Qbr-jvd0", "rHcnOm-lABeDvP-9Qt-Kw6m",
"DUjya1-y1EYN5S-PCr-9JbC"], ["oGaCpo-pEHb1qO-bh5-TqON",
"SKW1Mb-2tsaz6J-LAD-asxW", "SwIE [...]
+7 [[NULL, "6H2A7R-vdhxAPF-r3p-xuDz", "CeWjUL-bUYs3WM-8lg-1rHO",
"ZGzZVU-BUsYN7e-RCi-MawO"], NULL, ["UEVpis-P6FrdQ7-abI-EgY1",
"1P138x-Xv8a67y-avY-fZaq", "yJ04Oa-GRm639U-5Mg-saZp", NULL],
["FNhNBR-S3O7tAm-iFn-To42", NULL, "BH0oa4-qtjCLWd-fQe-EfDU",
"UdNiXa-XwnLST6-fgX-Mckz"]] [{"DFV7Xe-86SpB1K-Eff-gJJB":2023-08-13},
{"B4beXL-E187dfy-tCy-5IDy":2023-08-13}, {"7fM5de-G1AReN1-1rg-ojI8":2023-08-13},
{"J4BDGb-jOEpGW6-JS2-oc6D":2023-08-13}, {"w7TgPK-hf1yGDR-m3N-pQd4":2023-08-13},
{"6SZFiV-ECD8KM [...]
+8 [["8F1mdA-4oEXMRR-uXq-k5jp", NULL, "bNAAug-tmsLiih-KZL-JNZa",
"gusebk-CI9TkE7-pDP-IECY", "z2x1Yj-5idVtCz-9mU-p13B",
"I70cXq-0ecvO5X-leY-xh2S"], ["bN7zms-9UTzjb7-61K-xs4T",
"dt2BPR-rSAixMl-r1b-S5vZ", "N2tbAq-Iw64eJ1-Ep3-IMtT", NULL,
"P8QKww-SLmziX3-X7y-bOH0", "hHhGhO-Nl8TGLm-aQw-X8D5"], NULL,
["obaQgh-WgSFNI5-v4B-4eQY", NULL, "vAoknq-i8SZXLv-TJR-LGQc",
"YPLbVa-jyhXu2S-uPg-EDeg", "jJ1OZ1-bQ6kFT7-K75-gUjM",
"Zf7QP6-7GBYujN-6d9-Gx3Y"], ["UOWo0J-5KGhqSe-EA9-afXu", NULL,
"K0ZxC4-DEf7wPW-Epf- [...]
+9 [["qEYMav-K95o2O9-1Nj-Naij", "8HpG6x-KuUHelm-bKx-P84X", NULL,
"IePMOH-QVvdbtL-O1s-0PvP"], ["VfDmoV-0VTNCj9-C8Z-rLhu",
"watxeX-hrRfMAV-rjI-HRfC", NULL, "6u50fy-2vP7Kyf-SUN-F6D6"],
["fpdsEW-osKaLPm-Pre-6Fbw", "tHKU5z-dWBcLnx-1gS-5mbK", NULL,
"30NhQP-N3g0A8h-Tyb-Zhk5"], NULL]
[{"9i1OMa-RhxZkSH-Xk6-skIk":2023-08-13},
{"NgBr81-pF0tyuu-yLO-cL5c":2023-08-13}, {"bEOz2u-V7JkT2b-8v5-WKP9":2023-08-13},
{"Ys89W8-ZbrMNE8-VgI-tVRW":2023-08-13}] [{"MqipF2-9vvP33Q-RZS-vzdV", 7},
{"gGK8A1-VIlU6Qj-79b-R [...]
+10 [[NULL]] [{"RZKarR-Jrygc5V-jOS-zkWF":2023-08-13},
{"4SyGnQ-LTZZY5T-yTA-ur8p":2023-08-13}, {"ondCJ6-sgnzqmX-ox6-iJg9":2023-08-13}]
[{"3KBQOF-MIgyf8c-P3c-gFR6", 3}, {"T5PaAa-4sbRnJh-b81-aSNR", 7}]
{"g8cCWf-1XIxit9-5Cb-JuH1":{"1Pu4Fx-VEb0zAI-xpP-O3uv":0.88914363635595173,
"i7DEoo-j0aMN4X-hvF-MU3j":0.45195555861373282,
"sedr8H-zXM6gYO-0kO-PCor":0.41975127321720229,
"yzkXFe-iIPrCgH-KEZ-Rkij":0.43343557494418172}}
{2:[0.042404316855651158], 4:NULL} {2023-08-13
16:17:31.358000:{"bWonH6-3P5tl [...]
+11 [NULL, ["uuI05R-cfqJY48-sB2-03Ew", NULL]]
[{"k0HIPT-v5goxfZ-V9Q-M7cO":2023-08-13},
{"7OSD0b-lU8OZe7-K5F-txz0":2023-08-13}, {"hyYVlb-5HVeuxM-XbH-E30j":2023-08-13}]
[{"Wb7Rmx-VJ4wKs0-WXF-4Zt4", 7}, {"wmUsuD-1eJcgvY-6C1-yOfX", 7},
{"d7u4Wf-tik0KWs-FtT-brVq", 1}]
{"dSAat8-foDgpls-c35-vnfe":{"4Ldsdw-xkDAnq2-AdD-nCc3":0.60028563706074634,
"mRA5Ss-aywlbxr-qM4-crV6":0.9334612147969783,
"p30bqc-PVi3gdX-MPh-mmo5":0.055529348149875091,
"vs5ugc-vjOpnjW-xac-99VB":0.98601978663645773}} {0:[0.876573 [...]
+12 [NULL, ["4flDh5-SSJFmK4-SX6-zMzP", "cH2wix-aSYYDsu-HtT-rQzv", NULL,
"6LFAhp-NSO9OzI-ZWc-LsQB"], ["ibrU4X-yJ11qaw-0Uy-sdC7",
"nSOPFd-k3EbzlS-Vbp-3Pz8", NULL, "t8avo1-8ZIYIY5-Dpk-3oik"], [NULL,
"GjMCia-EcrkG0h-LfC-eEYc", "yC2F1b-jbQkZjA-PuY-sgWU",
"qGkSn3-1v8QToR-Pqa-Hatz"]] [{"uYE2qU-rJ8yZiI-tEg-Kz6s":2023-08-13},
{"gDScjf-TWDEhU1-GF3-1ur7":2023-08-13}, {"RZlw2y-uYwdula-cbV-ixKB":2023-08-13},
{"8eFnkd-vSPNT8C-6lg-ykLO":2023-08-13}, {"JIBJ5p-BDHxJIR-xKS-HSQV":2023-08-13},
{"NqJL04-vBM9j [...]
+13 [NULL, ["swlvzy-ozjM5XI-2V6-4c9p", "QGAz1D-gk045CB-hWp-xGto", NULL,
"TS2vir-XcD9Sac-E3h-EuGA"], ["lvrdno-aEUrtxT-IcX-B3vf",
"Ob5LaW-YOT0YVK-rvk-s6ly", NULL, "LiDjz0-by5pGOw-MYc-rw0n"], [NULL,
"kgIiHQ-0BHdKGc-E4K-TSdS", "5XMjgO-FRsTaUW-qh5-J2Gj",
"wBXzZr-Ymr5eKm-g19-ypYO"]] [{"zpuPvU-ipwKAae-sVh-XRof":2023-08-13},
{"zMwe7z-ccyYB8j-OCR-ec30":2023-08-13}, {"tYlTVu-iggHNQL-7z9-dhlQ":2023-08-13},
{"rYxQNn-3yP2f6W-etY-9uH8":2023-08-13}, {"R6KRvS-fZVWnej-s2Q-f0qM":2023-08-13}]
[{"E3UWIn-PIjw [...]
+14 [] [{"lZVNV4-95Luq8a-qA1-O86r":2023-08-13},
{"Wouurr-zSNa3U9-RHD-XogL":2023-08-13}, {"vn60Ov-ohoFKNH-guV-Ecvs":2023-08-13}]
[{"uPxb0l-Owm5TJ1-ia1-aQ7p", 3}, {"YHfGdA-a5py92c-Ugf-6RsI", 0},
{"P7DS3x-SrOnG8b-YoF-pZ44", 1}]
{"7BDfOx-NccOEoQ-17F-wPac":{"mi63tw-35jCAIb-Qzt-WQCU":0.11873404461982784,
"zGp7dk-Rs9L9RR-FQc-T9LL":0.81218608006354731}} {9:[0.93654707549364447,
0.12024442466427343]} {2023-08-13 16:29:47.200000:{"XDr7gs-aMNmNLo-gsG-8xvT",
7802, 0.014060946244331074}} {[], {2023-08 [...]
+15 [["xN8jAq-w6LgTKo-bTs-DWWl", "O31V4O-Xv1dl01-zsP-J1Vf",
"TEBE3L-OuFJuix-FjY-gmNe", NULL, "4bHMBb-FK3hhEo-DUX-eqkK",
"va8C6e-URPHyML-h78-jufK"], ["4o5NHa-VuFdIr6-e5R-ck5F",
"peU8Hp-VbVxeim-bLv-MGvL", "8EIstw-212vQMt-56L-aNVl", NULL,
"yQd93m-FBHYAWm-F70-cgmN", "9gAxXb-hBNaWD8-GlO-MoXv"],
["rqsg4C-sMbvpRm-zkm-nGDb", NULL, "NIH9fz-PFSS5UI-Hfe-5flH",
"aJ4Cna-teHaRF7-tYY-qAe9", "0o7JqM-a56eWul-gj2-4RYc",
"uKlz6X-3ALspVk-snY-mFxe"], [NULL, "v5uiAU-WbRajLn-5sd-0nL7",
"uWAU82-hIobPIm-YZl-yUV3" [...]
+16 [] [{"UfRg3Z-6wEmPrG-G1v-M0zv":2023-08-13}]
[{"6IItG2-Arp8N7d-6DB-05ut", 8}, {"pPgS7l-g7R3oFQ-S9e-Qq8D", 6},
{"FbXwhP-nkc9dss-5kh-7fhS", 9}]
{"bIOSiw-u0k078Z-Jw9-9VUM":{"wPgzgW-12Zme2T-hcM-EJ3X":0.60815657695145131}}
{3:[0.31873248844978941]} {2023-08-13
16:19:34.329000:{"iqy1Np-LUsVuaT-xms-0nru", 6205, 0.52327429499177269}}
{[], {2023-08-13:"ZEWY9o-emLH5pH-7hT-Q0bX"}}
+17 [NULL, ["BXaR12-HnKwsZt-6VM-W89W", "TyO7PB-MUdf5VU-2tR-NhLk",
"32XFo0-KTCOXiQ-J9M-XD3x", NULL, "RGyzDg-aur9ehn-Iqx-66lN",
"fmB8XV-lvEgPV7-pec-yGee"], ["rfhN4Q-lME4ytE-KHc-ma9t",
"vYKmbo-ZG45p8W-3ky-ZTrJ", "iynyrQ-1rPd4d7-84K-3BeX",
"RzAbsC-vSD7h5u-fXX-KYaX", NULL, "CHaz9p-OjrH5Yq-0ID-4H2o"],
["f2Qgfd-pNdDuqb-gjG-JssE", "NwY0fD-jTOKlDB-OjH-NBD9",
"8MhKO2-HsFaSMg-yNt-9iyV", "2tYaWt-L3pEE6f-A8T-ZXtM",
"v9hDYr-MDYcjpf-GRz-veuP", NULL], [NULL, "UsEgqH-Z1ea3Hu-P4f-y1RE",
"G9aQrV-jWj9r4T-IZ0 [...]
+18 [NULL, ["Sehzag-lGvxBee-qrl-yRdd", NULL, "A4E18q-KY56ghJ-BMB-ey8B"],
["Gij2r5-d7V7LOB-siM-suge", NULL, "FMsacl-v0iIKjF-972-T5DE"]]
[{"T9Dqk8-opJ1k8t-DS3-bGet":2023-08-13},
{"brIHS5-D4r9yfG-1u6-73I1":2023-08-13}, {"Ip9djK-vFG0Dmb-Otf-RuFy":2023-08-13},
{"cyWJJo-cbTtWE6-P4y-a5Qo":2023-08-13}, {"gZCX0D-mRBhnIs-WvY-dRl3":2023-08-13},
{"YCMYdw-lkhhvkD-Tqg-nxZm":2023-08-13}] [{"27EUUB-8RpmLHA-HFp-XryK", 4},
{"IHax8i-ir7oT2m-aFb-QJYp", 4}, {"yQpfMY-qfyVYKy-Cmn-8Qql", 8},
{"BSM76h-exvfH0p-y5j [...]
+19 [[NULL]] [{"r2D3pJ-kGSBGDh-JEb-kEaN":2023-08-13},
{"o0W4mG-IUENXfo-cng-zx5R":2023-08-13}, {"neS9nO-ubRfF13-Ud6-UXlg":2023-08-13},
{"tH4Fif-kCeD9N7-ZM2-fU41":2023-08-13}] [{"OmpPSc-WZdWNaY-snc-KoUI", 2},
{"xpZuk5-1e9HHrm-whO-IkU5", 4}, {"fn1pWd-lA8vumo-IXy-DRDB", 9}]
{"kk4UFJ-xGLIUZs-IvT-S36e":{"bWyLHU-t21wTij-qY1-DQsf":0.16273750949585131,
"kF3lCz-vGt8v52-ev2-XhlI":0.56082781132837778,
"lonyuW-Y2kRE2Y-Dw6-CORk":0.98839112673464358}} {4:[0.522285930847717],
8:NULL} {2023-08-13 16:15:22 [...]
+20 [["UvIKhe-W6D62Ls-o8z-G0oK", "DHSOd0-DLmzuCl-jWu-kI3q",
"5oOGRV-bsupC4o-ONr-5tc2", "icFjmp-3lh0pvq-D6n-DT8K", NULL,
"xk0JmL-hpD1lCg-oMv-Zraq"], ["8OjGAC-FLNG0RM-7YI-AYdG", NULL,
"9MQPID-rtLOPQ8-aIt-TPiV", "UcYFQI-kLK2tqp-p7S-Iw8x",
"4klvdJ-bNYMqG3-GbB-UhYN", "39AMAt-C7wdUze-FTs-xGFs"],
["TIchlK-2wwRneB-dJ6-mwjH", NULL, "OVxklY-D8RGpi3-lEe-BFIj",
"acto5I-m9N3i2W-Fen-mCBD", "e1h0Vd-4jBnq8s-6i3-JZok",
"x0bu2m-EZuZaEW-FIj-eTU1"], NULL, ["hXlc5L-NTUwcoH-1eq-ZyRi",
"bz7oWT-E0gSP5Q-9qO-sskg" [...]
+21 [[NULL, "hzozmR-GpYWyOk-XOa-LA49", "olnLRv-Q1UwX97-GDo-LU1q",
"vOJk5B-DU0FhP6-6HV-obdU", "4wO5PC-iandBQR-Go3-mx6H"],
["OlLhgf-sFu6rZD-kHb-L7TR", "DZKGW6-0VSeByP-QEe-LUX4",
"DOy0qu-RHqtUvj-lpu-SoUP", "w65tGU-jQOoGcE-3ly-Z3WR", NULL], [NULL,
"ZW7uq7-t9ASeYT-7i1-49nE", "1zcggg-eX234bd-9p2-RNWJ",
"Mw0wCQ-7vhxLCh-uIZ-Re3X", "sZnQ6J-eydM1TZ-NCB-HXal"], NULL,
["ZvezGh-fMatkHS-EGU-KnE5", "qk5F3y-sgf5c08-2b2-KhZv", NULL,
"z9N0GA-eRuDL72-snc-hxyo", "4WoRL2-0yLhBBi-MOl-FQbl"]] [{"Gz1GR0-8ljDLSt- [...]
+22 [["Mb2J7R-GEW4RUL-FdK-mJRM", "Yltvmy-TZwyxXo-Qj2-2Xrq",
"PXjZYf-tZUJDQJ-GX5-n9A0", NULL], NULL, ["ibiU34-oNa4azn-G5p-TMGl", NULL,
"BPbCNh-pIcEQaK-cIv-Rpok", "KnXUrO-stCEP8l-nic-LpqR"],
["sFDmd8-oLfXsoi-TME-jtWp", "4rmo1G-XhuXqBQ-4jf-g1VM", NULL,
"3sSgVD-ljYChIB-pQH-VK9t"]] [{"WdTnFb-LHW8Nel-laB-HCQA":2023-08-13},
{"Ub3q49-FKfvjtB-zFM-scAm":2023-08-13}, {"mg90SP-od65gYE-obT-ncWk":2023-08-13},
{"qQfEtF-V3RVL0e-3Jy-Ufra":2023-08-13}, {"4hhxAk-7J29tT9-9DD-Ed8U":2023-08-13},
{"7fERt6-yEKoc [...]
+23 [[NULL, "wUqlDw-JokF7Xn-UDR-S0ox", "ThYhJJ-9lQpSJF-pA1-813x",
"VrA0b4-1hwausX-Apy-wFjs", "9vYiDU-fkFeEV0-VtX-AfXe"], NULL,
["lVh42E-88hIYmz-1uC-sVJq", "EGBCXV-xZRgpub-vvF-21OW",
"WPu3oz-xHlkn7r-dNY-7CuS", "MGt1cg-RcoLLo3-RrA-XmGA", NULL],
["0kfBgi-GkAU6vB-vtm-Ew4Q", NULL, "D8nB8u-KgkYs0o-omE-yxFh",
"tYDEYg-1XZMTI3-GrG-t6zI", "eIGJUY-yfmHCi7-vl4-JwbC"], [NULL,
"abf1UT-Qkyhuze-eVF-uUa1", "nN54xV-vY6cVIx-WRP-m6ix",
"3pKE6I-oVECvC5-5Oi-moG8", "EB1qwA-MoyV6fc-FR1-Nogw"]] [{"j0g8k1-OOIDlBI- [...]
+24 [["EbRLih-lYitO5x-vHy-ZC9u", "Ne6uYh-bpYDVMz-eaK-110L",
"y739bR-fGQUyuK-z4H-8Rme", NULL, "sUx0c2-lNC36AA-VBG-ohMY",
"S9xzQo-mJGeIfl-km0-Zh7N"], [NULL, "G2RXMj-nyH3foO-A5e-ycNA",
"QSueHg-TT7meFT-3jJ-ZCVM", "OVe0zy-YOZle5N-jG2-8ivn",
"LEezxE-rA5zP5a-RvU-QoRr", "6VApKG-foljily-wlZ-Z02M"], NULL,
["Ny4JuQ-QUs3zh2-wqN-KMqg", "BMWM9H-vkclSd2-z7T-E9Ph", NULL,
"VrOtER-b0akeg2-CyT-dRh7", "toZ9zQ-ASGXGyv-CQz-eYGM",
"KhGJbD-tvqTI5z-6hP-dsTB"], ["dclkfG-nF6vKyA-W4F-HNLN",
"udqS36-Ex3H2f3-0MD-nQ5f" [...]
+
+-- !sql --
+25
+
+-- !sql --
+iTUE6T-zQx5sOO-vv4-deqF
+Nw7rQR-eYvzaRg-6fu-S5RP
+\N
+\N
+NEGRXI-W9aDpI8-6ee-STJd
+\N
+\N
+\N
+8F1mdA-4oEXMRR-uXq-k5jp
+qEYMav-K95o2O9-1Nj-Naij
+\N
+\N
+\N
+\N
+\N
+xN8jAq-w6LgTKo-bTs-DWWl
+\N
+\N
+\N
+\N
+UvIKhe-W6D62Ls-o8z-G0oK
+\N
+Mb2J7R-GEW4RUL-FdK-mJRM
+\N
+EbRLih-lYitO5x-vHy-ZC9u
+
+-- !sql --
+{"JeAEJt-tpdCeIv-92O-eHlY":2023-08-13}
+{"cAT0Uq-NXQScTi-mhX-3FGr":2023-08-13}
+{"T6F6xF-Aid2GKl-rfw-1eHL":2023-08-13}
+{"CSwT2Z-1p7aWGt-6Gy-WGWF":2023-08-13}
+{"x2U6MV-DjXoCmi-wcE-Arlb":2023-08-13}
+{"lVFZ64-2jfVMcu-gFB-G7yZ":2023-08-13}
+{"ApHf1f-XgBWBTb-pUd-xjMR":2023-08-13}
+{"DFV7Xe-86SpB1K-Eff-gJJB":2023-08-13}
+{"hHLhXb-UkrZWqt-FhF-gmwh":2023-08-13}
+{"9i1OMa-RhxZkSH-Xk6-skIk":2023-08-13}
+{"RZKarR-Jrygc5V-jOS-zkWF":2023-08-13}
+{"k0HIPT-v5goxfZ-V9Q-M7cO":2023-08-13}
+{"uYE2qU-rJ8yZiI-tEg-Kz6s":2023-08-13}
+{"zpuPvU-ipwKAae-sVh-XRof":2023-08-13}
+{"lZVNV4-95Luq8a-qA1-O86r":2023-08-13}
+{"IS6cpa-rTRHUfq-o1x-wNFh":2023-08-13}
+{"UfRg3Z-6wEmPrG-G1v-M0zv":2023-08-13}
+{"XiInUA-zqpaAlM-Oow-EfEL":2023-08-13}
+{"T9Dqk8-opJ1k8t-DS3-bGet":2023-08-13}
+{"r2D3pJ-kGSBGDh-JEb-kEaN":2023-08-13}
+{"xGty48-oinhhAx-HY8-X82Q":2023-08-13}
+{"Gz1GR0-8ljDLSt-fgC-z49F":2023-08-13}
+{"WdTnFb-LHW8Nel-laB-HCQA":2023-08-13}
+{"j0g8k1-OOIDlBI-jxT-3wwJ":2023-08-13}
+{"3CVpkM-Cdlj84d-Rng-vZ0H":2023-08-13}
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+2023-08-13
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+0.7899344633186454
+
+-- !sql --
+[0.068916022761158491, 0.72871503635601487, 0.6397519508055749,
0.30173099563271544, 0.68766341771042583, 0.94746012071481922,
0.45806445423242625, 0.20099634378875642]
+\N
+[0.53455457379217286, 0.96053015629873906, 0.74300071896879594,
0.443987797733012, 0.46533546276445303, 0.41757749352807016]
+[0.59741789602486839, 0.87801489582742454, 0.10208759605414353,
0.35345981053464293, 0.76265087732929171]
+[0.96978059755624269, 0.83756958233590562, 0.57631894948614348,
0.099591153245699116]
+[0.83400609534663062, 0.26563993972335442, 0.27353503323531658]
+\N
+[0.774201063401427, 0.74680457032106551, 0.099206807636055161,
0.12579899662408955, 0.90818360275340826]
+[0.67020846700065984, 0.282946445673966, 0.99195672008359193,
0.47122300824702, 0.11484279669400166, 0.43931372459689089,
0.45602474755599243, 0.52386803975996932]
+\N
+\N
+\N
+[0.683754267380438, 0.17795901031526673, 0.86101902699178612,
0.1886712577315216]
+\N
+\N
+[0.21923407569636466, 0.62500558908290471, 0.55899793946647836,
0.69930248822342533, 0.69666451645169469, 0.34385209904548386]
+\N
+[0.586214382159739, 0.45238620062629453, 0.75633493572259258,
0.25205211275233985, 0.13131914593533822, 0.84260721385116455]
+\N
+\N
+\N
+[0.11047124118841245, 0.67836526164507482, 0.2334139055342378,
0.67125230471787956, 0.41850415349990888, 0.093706079540461173]
+\N
+[0.6566051188780927, 0.32181001964893852, 0.38911269154007211,
0.18445097967540613, 0.74794741714492452, 0.095631978468886825,
0.36179056198322512]
+\N
+
+-- !sql --
+0.45806445423242625
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+0.4560247475559924
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+0.3617905619832251
+\N
+
+-- !sql --
+25 [["pVzcKC-4YFR2VM-hAF-4wbj", NULL, "puPe8Y-CvN1o8z-YDW-956F",
"NpRzsr-8KGoqbr-RnS-gmVb", "7J1bbm-vPRco5H-HyR-jLff"],
["F1C8O5-JBIfHix-br3-L3a4", NULL, "eb6vio-XsxJ5Sk-bFE-PbYB",
"ElNPdg-za24mCK-LeD-cN7E", "oJLv7H-elMwuV7-TZT-XWEe"],
["Ft5ADO-0LrvGT7-vXJ-bb7b", "DEMymk-WDCqA2c-aGK-hC1m",
"jxVnmH-k0M7iQl-tzz-M1e4", "0PRgjU-MY7jnay-qWv-rkyg", NULL], NULL,
["jXsrIF-1FnfVfP-wV6-u2kr", "Omp5zc-O5RLdRO-5Ql-UG6u",
"NBb9Cn-x2RW6KT-CHD-p3wA", NULL, "tsYVut-EigOUzE-Lle-Hs14"]]
[{"5TmJmI-3HVmy0t- [...]
+26 [["1cLgOq-jhNeMEG-Dtw-4AwL", "jhZcsW-CGyj1kt-sQ7-0aJX", NULL,
"VdQfoU-hrZt0zV-sO1-tsWp", "wn3kwP-lB1AxGC-epk-VD8u"],
["3xsktg-6bFiUt4-Q7u-Bi9v", NULL, "ucSLCY-DJ0zx8j-9yj-2lEA",
"8ltbUA-bOjtDdV-Ojs-smeQ", "unUDj7-FBicSrt-QwN-95uj"], [NULL,
"sfGvVX-smGcvy2-h8W-BYsm", "c6HKrq-XH4VGV6-64O-vyKV",
"i5a7tM-CFYAieL-WJ8-ZPvH", "7i2MN1-rvPWCl7-s2Y-xfY7"], NULL,
["9o5TWr-Eh4n0uh-gNz-eAmq", "qC7TXd-IwtcLU8-hke-NE37", NULL,
"cResuY-IsHEewt-YJq-2Xu5", "zWZBBW-PXIPZnq-S5Y-OhDC"]] [{"xWMxf4-uFVGZNe- [...]
+27 [NULL, [NULL, "nspd8V-YHBG4C6-Tvf-gX5i"]]
[{"0N4Qgs-iPTaGkG-N4d-vXRb":2023-08-13},
{"R2XNFG-TjXu1Bi-fUL-RREK":2023-08-13}, {"lsBVJL-XNm8KEw-c5e-B3iY":2023-08-13}]
[{"OCL5yv-CbFRH8z-UBm-Onqa", 6}, {"yNOKGc-ogGNyrp-rEM-TbWL", 7},
{"V6LRT5-24MfA4k-8BD-O9gL", 7}, {"249uKy-454ywiX-rhs-xHKf", 6}]
{"fVXa0E-xsoMkYX-XVM-pwu2":{"s5WU6X-qzlKKdR-t8a-6fIG":0.50037443272575788,
"VGJxRD-s6C6zPQ-1AX-kyIa":0.522556668127189,
"rJfJVV-GtaFDOX-Amz-SG0g":0.091006862295584745, "HBej8X-rMrs72l-jz1-lP0k":0.0
[...]
+28 [[NULL, "MBuONO-DddJpWd-YYg-MSAG", "loWxFz-BPZeiDk-xN0-SVZW",
"HwiB4h-EDkkufQ-Zg5-9WpH"], NULL, [NULL, "Mfs6G6-e4Kh5u5-rUC-F1uW",
"1F2nID-KF9Lshh-Zav-ptfh", "mBDoQl-U8oYBUE-zu0-Bi58"],
["En2b2G-QTh1FPR-F2J-h7uw", NULL, "VicBSI-eTAFJcg-Fo2-VYaJ",
"6ejh2T-VZkvqPv-7gz-hnrd"]] [{"9odUAi-6Yl0gDO-9au-9TTI":2023-08-13},
{"Raj6No-gizgyb2-4qO-5UHu":2023-08-13}, {"HQDXNK-uqxiy4r-ksG-6ktV":2023-08-13},
{"suGkbd-dAFaNhh-wId-w6K6":2023-08-13}, {"i6y7h1-GVZnnd8-8eh-LyvR":2023-08-13},
{"XiZxt7-NYBhX [...]
+29 [NULL, ["VXefdi-tyIlR8m-gCC-AjnK", "KoBsFd-VQFrvFF-s2O-uFze",
"R5HVUm-CeXPCkn-Ydv-X0O5", NULL], ["yczNuG-kFoLCzw-wVK-m0EL",
"ezESaZ-dYgklBS-irV-4dID", NULL, "2mxKdq-bmO6fIw-bb7-H0yE"],
["1thl5g-XaBs3HE-bHS-etgP", "M60GP9-7SqC0Kz-kBo-cXu8",
"cUkthX-Ap78LOk-8HW-vayb", NULL]]
[{"3Gp7Yq-JCwRlJ8-O2C-6fjg":2023-08-13},
{"7OSwlc-jsn2rty-VYy-F54v":2023-08-13}, {"zZTFUa-cDGEEAm-QsO-C9q5":2023-08-13},
{"FvtwJc-eyNEZ1d-dx0-nCGb":2023-08-13}, {"dhBtg6-5wnSN1w-VlW-A6xy":2023-08-13}]
[{"fFxQos-hyLC [...]
+30 [["DLwzZm-gnCo8o3-pWp-5GIu", "Phagik-6Ns5YUc-q7t-JJRf",
"89PSpv-T96ZR11-KkS-bi2u", "TsJ1tS-RoR6Ha0-0yo-COyr", NULL],
["BtELv1-FAJC3cM-lAO-xzFF", "Rq2YzY-f2RI924-fI1-tKjr",
"Zhkuyu-3ppFLv4-qZ0-ftCH", NULL, "0yf8lS-MWIpBjA-mVm-OTXR"],
["PAbA8p-ygabPZ6-zv0-XbXa", "PsTnTE-JakUfJF-9gt-zGG9",
"5Tx6bc-ZntvYXp-w0V-bzaz", NULL, "JZoZ4q-9a1RKo7-8MW-bjKX"], NULL,
["roqBXP-0Cop9U0-S4T-9NCz", "VnRnDi-3yB4YpD-ZyO-Rcmv",
"Ue4v3i-g6xJfLo-k49-zcg6", "mQrVTO-ptLLBIT-CKo-YrTb", NULL]]
[{"O6jI0T-vYIfPmb- [...]
+31 [NULL, ["hxE9tP-ES0ywas-9ve-qyDT", NULL, "GHZxzf-e6mqxJ2-BV2-0rdf",
"4XDBD4-hkvkBdZ-0Kg-sZpW", "d8Giqq-XEZgQxA-u2F-Zkwb"],
["8lUWqZ-i1SctAd-bZy-sAuw", "cETLpP-8GA5jmM-GEL-CWZI", NULL,
"QjKEUM-VN7ULGe-LmF-ZCe1", "gGtRa4-eWdxr5C-Y4V-E8Nz"],
["Yg8ky6-8ds0ob0-m75-AqcM", "XXaG3x-HTcSCaT-Nl2-FT2z",
"PUgDQx-tHwlMpI-60c-Nsk6", "2oWo0G-j94Wbdb-rtm-0zKD", NULL],
["5hLeYN-Dk3SrI6-tsM-npdb", NULL, "AXqiTT-8jTmWDW-HFN-zNG9",
"szQhr9-9qRIj7N-xen-midZ", "nKGe2u-nyuSf4D-Qlx-yU4L"]] [{"W3obeg-hTdQjq7- [...]
+32 [["PvEAGq-5J3ydw2-SCg-6Sm5", "bi7WP1-rj3rsXL-0CR-g7jK",
"bRG52A-t7PBOaQ-L2Q-KecR", "UgbKVA-roWdAzr-wHq-uRg4", NULL], NULL,
["v6eqEI-XTWA5Xj-aP4-EUAw", "GvgD7n-iegZ942-6d2-tPWV", NULL,
"NmMoiy-kdyanyV-wb9-6EZ2", "qqUWob-5BJnc4p-zKl-PmVw"],
["XIyb7J-PeYlc9D-eWN-7GLi", NULL, "x5OCi3-IGBxmlM-dCg-n59q",
"5HVLto-4vnWy0L-jFN-g2LF", "HJXFed-KSQM50g-alH-cCd9"],
["91Ozzg-qMRSn4U-g84-OQE5", "qWRp5Q-gSSpT2J-hgd-fmy9",
"GnXfEv-cVXlH4H-vvo-INHz", "OebFDG-UNRLMKM-gSl-czBx", NULL]]
[{"3joUkd-Zy6qqZX- [...]
+33 [["Alu6Ut-pym9uxc-f9V-VZtc", "dxfkfq-wSWY1mf-MCy-C6RL",
"jvIHsc-56opIJg-DVE-3j4e", NULL, "1HIy6L-HDosxgv-beC-TczB",
"aQ1Vl7-QlLYZUN-MpB-b8XI"], NULL, ["vOiBV4-c9k237Z-MM3-6Sgp",
"JW1UYX-TSFOjWq-Tu4-LSJz", "P5fgzE-nmTunS2-yr3-kEqK",
"eH5hjn-QWWrDXc-1vp-PmzW", "m20eP6-eZmU2Cj-qkH-Anc2", NULL],
["Gd5uCH-doe3Mf9-Af5-KS6J", "FylE74-etOFPlN-kFw-jjuq", NULL,
"ZUc1uK-k2KJtYK-y1p-ARSo", "nzBq5J-56Xov73-6xO-VI8Q",
"xoSzVC-dlhJgZh-XpI-iABo"], ["5PmSbt-SYpRG3P-Rkm-BZK7",
"CcuuXB-CoIOZdt-xGZ-zlAy" [...]
+34 [["jUSz7U-Cer18Xx-yVx-T8ff", "m2co1R-yrE6xgn-Unr-stw1", NULL], NULL,
["OuQ3zk-V64e9tJ-uBm-PvWT", "nEqM5q-xKo1pcE-S6M-lbAk", NULL]]
[{"l5rFuO-4Qn7arh-0Mu-45p5":2023-08-13},
{"ALYX0U-y6GeYN2-31y-FqWv":2023-08-13}, {"vi9Mo6-Nf8VTVB-1Tv-MvTG":2023-08-13},
{"DkcoGP-OXrLStI-sXX-KQ8l":2023-08-13}] [{"H3NJs9-XFM27Mq-E60-gErD", 3},
{"1rHzwj-nWluuUa-D5c-SY6Q", 4}, {"0AUoC3-OxtVnr6-2mX-LkEB", 0},
{"QTGWJr-iXuPdTY-lkI-6ju5", 4}]
{"4LJRQ9-lA28EPw-wON-daVn":{"HYuZ54-pokP91u-v2l-n7s0":0.677408444921 [...]
+35 [[NULL, "mUvKfq-1DMnaoA-7DB-xRst", "Q9KRl8-kVnoUYI-Hn8-pWyo",
"LfEHZJ-KoxsRX8-B5L-ZjoS"], ["8H1LVC-24pPaBb-I74-c2fu", NULL,
"EnIQGw-XQIxNdT-WCh-HhRc", "ExOoXA-PEAUqaD-spu-uhlp"],
["YWY0Lj-eU34i8U-6au-AKbj", NULL, "wTHbZK-5kXx9hJ-Lkl-8gAf",
"fMLarV-rXJ7M9Z-dkg-c2bu"], NULL]
[{"lxHrif-zmzeqbj-698-qreC":2023-08-13},
{"xUeIPW-uDY81Uf-02K-HRAZ":2023-08-13}, {"irFJdN-KKwXTmg-1W4-Unke":2023-08-13},
{"OKfkR9-yFqcyMF-KU2-26pL":2023-08-13}] [{"uGDy3p-DlFiTqQ-T4v-DJgz", 0},
{"xZf5EV-aPYud0T-jYG- [...]
+36 [[NULL, "807ojY-WIbPSHl-B9d-X2nC", "2M92if-F5bCc8o-012-Hi8y",
"Nmorjm-BbOWsNN-For-XhMN", "sjkcPx-QOH81Yq-DaW-xTf0"],
["LHpc9x-iCPbgLI-aYD-K89p", NULL, "DEcEsC-TB5qT9o-EXK-n8wc",
"yAxu72-Nioh4Zr-Hku-nGqI", "2DCqkd-aFZVGV9-4cG-snfu"], NULL, [NULL,
"VrzPMe-lXo1TJc-l3v-vQ7Q", "IvUI9X-2ecrhdv-4SN-OtLJ",
"9zvkCX-IRwTGE0-sCi-6N2N", "HYYaZs-fBZFGD8-Vrw-I732"],
["BiIIFT-VKE95Ct-Rna-8Pr7", NULL, "KgGpom-WETUUdQ-zIa-y5wl",
"lXeOl5-MKAjLQI-8iX-b2yL", "m1ZbRT-h9VmuB8-uWG-d43D"]] [{"s8IfbL-RrFEa0z- [...]
+37 [[NULL]] [{"sxEsGm-n9fQYfH-82B-Ixs7":2023-08-13}]
[{"HyiYzX-1ENY9H8-Vcu-gdTV", 1}, {"q66Dg0-3Oxa2PV-DNS-1DKn", 3},
{"CBmQxm-Qw1V1QY-Mni-i7H7", 2}]
{"jdHFEJ-2M4s3rd-j0f-tQQ5":{"Gmiooz-yAvy8TJ-F69-v8A7":0.96676213882824535,
"d7M865-RnWee6T-RQ0-RRMX":0.37115571732982178}} {8:NULL,
1:[0.53531740037073]} {2023-08-13 16:18:11.052000:{"oU04SD-wdohIK6-6Aa-c6jJ",
8220, 0.44916084723892447}, 2023-08-13
16:14:16.131000:{"CtKnLV-Hu8Sj0c-GlT-aQdJ", 5156, 0.75985604688465691}}
{["0wCmfs-ezTikLc-key [...]
+38 [] [{"h8JDjY-A9XYK6Z-o3P-JZBL":2023-08-13}]
[{"HRUSpg-r2QMfiF-uTv-AO2z", 6}, {"8zlUSV-HhuOCNI-mfL-7bdH", 3}]
{"YnSTIz-6cSvM1G-vdp-sCDk":{"tFPyYu-cS5DkCD-IuJ-5yZO":0.095242340921092183}}
{2:[]} {2023-08-13 16:24:46.348000:{"7P6sKe-xqgcDKg-ZM9-fOvv", 8174,
0.75823339087299124}} {[NULL], {2023-08-13:"p7BSIY-SYc8Liw-Z80-g2Wm"}}
+39 [[NULL]] [{"iuzkoT-RZl18yU-FNr-o5s6":2023-08-13}]
[{"V5q1Iw-UcyREAv-lcQ-K13w", 8}]
{"xwIxbr-R2ptQcB-u8z-hJo3":{"UA5JjZ-uLRy9nh-Xgt-Pbo8":0.17922777272859647,
"vzawJn-ilNePsx-YQ1-ii9s":0.0099197694768856648,
"MlLqcF-5TTEHBW-S1Z-ekYI":0.5549061965766855,
"8VEhhh-B8uXtXt-Gd6-qxYZ":0.65973144903294012}} {2:NULL,
4:[0.005854506785542779]} {2023-08-13
16:21:36.123000:{"R4fuiY-nCKavCN-grg-NL9N", 8262, 0.8041431292677762},
2023-08-13 16:15:18.498000:{"FeKSJx-iB9GSUD-ZFF-Kl1S", 3822, 0.1731798 [...]
+40 [[NULL, "J99StA-aQRsIVs-DR1-jBVf", "kVi09X-gUQ6T9O-3Xv-rkNr",
"hjjIIh-lGzeliS-fsI-ZaYB", "IyG704-Ppwe4GH-0FE-BVa7"], NULL,
["n8Y5Yf-2m434Kw-Ghj-jvsC", "U01QUe-pGFKaSf-HcA-qrHc", NULL,
"tOJI9I-0nAXjzI-Af1-QfwK", "0fLNjF-wgN28gP-DxN-UGR2"],
["vXIXlN-lzpxTdz-X8P-jWgh", "CrUCUo-DCByubg-TSw-IQLh",
"BfGrCn-dcvRW6M-EhR-lleT", "IfsSNB-fWEBAM2-JRB-Of3Y", NULL],
["ybzdXv-qMz3Fnq-8zH-aIR7", NULL, "7RD5R2-lJ5jOvq-A1z-u0l0",
"yEKiJF-5SO8Qyd-e19-qIoX", "LLPNvE-IXlpr3a-Txj-RZ84"]] [{"D7X1eS-pL7qEsB- [...]
+41 [NULL, ["znO5gM-yeqO8AD-JWx-3llt", NULL]]
[{"blcQc8-aQIClVr-b4x-EQcn":2023-08-13},
{"DY23W4-KVlfWr6-rSJ-Vr2P":2023-08-13}] [{"QdwpAg-r9mD9eo-F2a-uDoi", 8},
{"0saEj5-dimS33l-0Ea-XJbY", 5}, {"BEBZB4-hXkcr2z-gCD-I33C", 3},
{"kn54DI-H7lX8Oc-tGa-dqGX", 1}, {"uJFTt6-rRRkNlx-6KD-qAif", 1}]
{"dGzpIn-UECb0cn-9rE-iIpG":{"cCHlxp-GPD5cZ4-ekm-kGCV":0.67979056420654116,
"ZgssYa-tzwUumw-z5i-zUBK":0.37156169197022548,
"zB7b4v-HPtOd2h-ENK-F7Di":0.79540638723775714}} {5:[0.82714761960669858,
0.97734544 [...]
+42 [["RMzNBR-izMbJ0q-9wd-CcHu", "d3jRLd-WO9TQj0-BRM-cg5k", NULL,
"7UMb9J-uptQiEg-nhM-NjPr", "sqbBCe-9Yql5dY-yKe-J4Cq",
"ri3MZC-ROMe0Fj-Lcb-f9Ll"], ["d1yb1u-9uU1FV0-gaY-MPwF", NULL,
"vYP4rT-mnLioHG-Pdl-Am9M", "ixO8bl-dvr0Etl-LyM-vbvZ",
"OL7reY-eRfK7ZH-cwK-FcvH", "I7socA-y6LZRjC-OGO-wP5l"], NULL, [NULL,
"5CkaMC-Pw3C5HH-kbO-bNFG", "PmIXOB-5LqGBY6-yar-Xt5l",
"H0yqBJ-4HVnhhD-Njn-5ioa", "TEvLni-n33xibK-Gjx-FZcv",
"l9D3Je-hi975cN-0Ab-QHar"], ["Er04lt-bgIXKUX-djF-zhR8",
"dvYKgD-1rAyJWc-uHv-FbaP" [...]
+43 [NULL, ["wNRrM0-1IwKCCL-c8F-TDlU", NULL, "0rxOjR-MW6h8pZ-9SU-eDQh"],
["87CD4p-1fIY8W6-AmV-Zd6r", NULL, "hAdiDl-6bKduQM-Iy6-uj0N"]]
[{"xx9QTZ-lK6RmIb-IkY-4Sfq":2023-08-13},
{"3T0NFg-veEyZy9-vrH-i0YN":2023-08-13}, {"sbmK86-TPvuxe8-CUH-Ao1F":2023-08-13}]
[{"UCbeTu-FJdfBO6-PBW-lohM", 4}, {"3O0Foh-hQ241ks-kOO-bLbJ", 1},
{"tQku62-ytu8dUd-BAD-c1Pz", 6}]
{"5QKyw2-QyTEZ0O-dau-DZn8":{"iPEaRL-z3EqfOc-boR-HxR4":0.38195110567183632,
"KIm4nI-2sYvqaj-2gq-XBjq":0.28468153301968169, "8gyv0x-CSoM3u5-Kb [...]
+44 [["Po7jBW-kY4LRfh-BS0-qsDU", "ff9nKL-On1najN-vyp-seMs", NULL,
"jTHnU1-xAbvAuj-1US-kESW"], NULL, [NULL, "GI0ZXC-EgGqoOT-WrR-LZ4k",
"to1HMQ-PlzOVc4-WLC-DxaW", "Mn3Yhe-pUG6ZnD-cMy-rFwn"],
["3is6vv-KgWCr2z-DtG-yapL", NULL, "VtII8P-ryMDdo0-yng-b56z",
"4Lntvi-xDllf10-Hz1-UlFv"]] [{"RzeVKp-eWQ1w1E-jTT-Ea1Q":2023-08-13},
{"A1xCtp-WsDbBpN-eza-IcXl":2023-08-13}, {"zzH5d3-q2XGfXz-uy3-lhS9":2023-08-13},
{"Rc6rTw-5UnGYFA-e1Q-szlP":2023-08-13}, {"puJ42v-eQMxoki-oef-z9gk":2023-08-13},
{"fupADj-mI5kh [...]
+45 [NULL, [NULL, "sMuKpP-wASnozJ-GX5-X52J"]]
[{"o0W5JB-IWILGMN-GIl-AYpp":2023-08-13},
{"Pgm01u-W0vkFoC-9j4-VI9p":2023-08-13}, {"D1ETYa-m18anGx-GWA-i275":2023-08-13},
{"DGaz1c-LbygXSp-69a-gVj8":2023-08-13}, {"Y6sYwC-KN513gO-jVH-3djo":2023-08-13}]
[{"X3NAy2-4geSAH0-vJX-yDWE", 1}, {"v2wuQM-Y99vJ58-ild-eJcg", 8},
{"txq2Zw-Vb2lmBB-zqw-eldN", 5}, {"YaOzXb-hXDrtkI-l98-lp3Y", 4},
{"3Dvnsu-x2sCpeW-Ktw-AMEG", 3}]
{"bYlNCe-U9kN46g-HTs-SCOn":{"rUadL7-LioeffT-z20-kPD2":0.44070564554702951,
"rRCcqU-cm [...]
+46 [["yO3fh0-ov9gLG9-zui-IxFk", "UZkveM-LtyKBqk-rOn-0nI7",
"4UAhJX-KkgxTjZ-w4j-9e4x", NULL], ["rkHxYq-bVuauhx-lCT-K6ov", NULL,
"pNiAo2-TkFq1Su-jzh-zD8U", "28Jugd-u4NcngX-qWy-4kCa"],
["UNENps-N0CRf2y-ixM-1N4j", "6DGfxa-mZDaCLq-Dtq-XaWY", NULL,
"MlhWgz-i4gcypb-mYE-5R5j"], NULL]
[{"RzWJik-wyJMSGB-6Df-OdNr":2023-08-13},
{"BM2uYN-mBEZAlk-FDb-awp1":2023-08-13}, {"OrsBQI-Myzbgtf-K8M-yvq9":2023-08-13},
{"P3h2JE-9x5GkWP-IU8-nRRL":2023-08-13}, {"hl9t3S-JMudllx-dMb-2kqe":2023-08-13}]
[{"3W1poU-SnBv [...]
+47 [["T7E3En-IWUPKqi-bFT-chUT", "0HE8jS-sto3iWq-CJl-eGHF", NULL,
"tQDwdq-ohqIXPy-Vv3-wj0C", "NEI624-aTXtvTe-pkC-C5iA"],
["uFQr2A-YzweBJz-cVB-tvOU", NULL, "dXrRPD-hEl7upY-x7Y-tkzs",
"YUQzXC-RsWhg6w-6MY-bwQu", "Byirc7-iwwrXtN-Sj6-Zucw"], NULL, [NULL,
"3H8F1L-SkkjvFy-3yC-GoML", "LY797s-588ftrt-3vU-bOTt",
"ru14Gs-EsF37ig-UeY-kmnH", "gY8D70-5EsZUw7-vJi-RFQC"],
["LJfFlQ-u6yfPmO-x49-ja8G", "ZNEAc0-5nAHNCC-0CS-FnH9", NULL,
"fOVtKf-b62nxXu-IFU-GFXZ", "k1Ud8r-x9aZyVC-GXz-VleD"]] [{"ozNpcA-4Q5O1WJ- [...]
+48 [[NULL, "mJm0XB-fOIm12e-2qj-Ro6Y", "IwVqlt-DPrcnga-xrS-dSnk"], [NULL,
"F4y2bc-ZnohtK6-Wgf-KE15", "WbPAKU-VxKsZqE-fgy-mzhx"], NULL]
[{"igqo1Y-fvgg3vJ-5Yp-MegR":2023-08-13},
{"r5oNNa-Su9KBgK-88Y-9NC8":2023-08-13}, {"3VmOFH-NnN1HBO-318-YNEW":2023-08-13},
{"bd2ALF-K1X62Lg-F5v-0rL4":2023-08-13}, {"hoRc7y-dxPjL9t-LHt-DElH":2023-08-13}]
[{"ELr268-FBBmCeg-uYg-n35X", 5}, {"iwgwi5-rhCk9UO-0EA-giR6", 1},
{"FaAbG1-swdPRZu-l54-FoNg", 2}, {"kQaD5O-iUW6LEq-mPc-SWDG", 6},
{"jlbC8j-0qQqwWV-IP2-wSZ0", [...]
+49 [["GFxQDj-0srwp6A-nB0-G1XJ", "pIgoBH-tBNoPWS-Wm1-dzsw", NULL,
"mmrqN0-LIfujNM-EfW-7BT7"], ["zpfLSo-8PTLkRC-uOQ-HrKl",
"JT9Hyo-zhTdnGK-qgg-QY63", "6qRvLV-O90wFyd-T36-Rfgp", NULL], NULL,
["ZblkYx-p2ZMgUp-Wcc-f2hN", "lAUBEu-LCVQeQd-Iho-O39f",
"SYwxRO-NI5r70E-YGA-L2tC", NULL]]
[{"56ohVZ-pbDbVh2-1s7-f8S6":2023-08-13},
{"UfCZBo-yeLSgLw-G5M-NsPn":2023-08-13}, {"OIHhHL-HuNpqeq-PPa-u7U8":2023-08-13},
{"amGHoq-pycaYAL-90h-zy2D":2023-08-13}, {"zOfUhk-QRiV3N5-SnQ-UDR0":2023-08-13},
{"pADoLv-jVvOt [...]
+
+-- !sql --
+25
+
+-- !sql --
+pVzcKC-4YFR2VM-hAF-4wbj
+1cLgOq-jhNeMEG-Dtw-4AwL
+\N
+\N
+\N
+DLwzZm-gnCo8o3-pWp-5GIu
+\N
+PvEAGq-5J3ydw2-SCg-6Sm5
+Alu6Ut-pym9uxc-f9V-VZtc
+jUSz7U-Cer18Xx-yVx-T8ff
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+RMzNBR-izMbJ0q-9wd-CcHu
+\N
+Po7jBW-kY4LRfh-BS0-qsDU
+\N
+yO3fh0-ov9gLG9-zui-IxFk
+T7E3En-IWUPKqi-bFT-chUT
+\N
+GFxQDj-0srwp6A-nB0-G1XJ
+
+-- !sql --
+{"5TmJmI-3HVmy0t-AZJ-49FX":2023-08-13}
+{"xWMxf4-uFVGZNe-YA7-eAau":2023-08-13}
+{"0N4Qgs-iPTaGkG-N4d-vXRb":2023-08-13}
+{"9odUAi-6Yl0gDO-9au-9TTI":2023-08-13}
+{"3Gp7Yq-JCwRlJ8-O2C-6fjg":2023-08-13}
+{"O6jI0T-vYIfPmb-rej-lw2p":2023-08-13}
+{"W3obeg-hTdQjq7-Oto-wQem":2023-08-13}
+{"3joUkd-Zy6qqZX-HIC-LBCI":2023-08-13}
+{"5tn1K4-fMUCzvZ-JMT-I0fB":2023-08-13}
+{"l5rFuO-4Qn7arh-0Mu-45p5":2023-08-13}
+{"lxHrif-zmzeqbj-698-qreC":2023-08-13}
+{"s8IfbL-RrFEa0z-nfD-B6yM":2023-08-13}
+{"sxEsGm-n9fQYfH-82B-Ixs7":2023-08-13}
+{"h8JDjY-A9XYK6Z-o3P-JZBL":2023-08-13}
+{"iuzkoT-RZl18yU-FNr-o5s6":2023-08-13}
+{"D7X1eS-pL7qEsB-h3M-0xTq":2023-08-13}
+{"blcQc8-aQIClVr-b4x-EQcn":2023-08-13}
+{"aEABQN-2EAPemK-cxS-gbf3":2023-08-13}
+{"xx9QTZ-lK6RmIb-IkY-4Sfq":2023-08-13}
+{"RzeVKp-eWQ1w1E-jTT-Ea1Q":2023-08-13}
+{"o0W5JB-IWILGMN-GIl-AYpp":2023-08-13}
+{"RzWJik-wyJMSGB-6Df-OdNr":2023-08-13}
+{"ozNpcA-4Q5O1WJ-ISq-ixuE":2023-08-13}
+{"igqo1Y-fvgg3vJ-5Yp-MegR":2023-08-13}
+{"56ohVZ-pbDbVh2-1s7-f8S6":2023-08-13}
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+[0.73463419556974352, 0.16409992065751688, 0.099825077866343759,
0.78964816467582755, 0.79951866650555192, 0.59372704254910391]
+[0.5991114598280094, 0.06286424716603789, 0.49027402949218057,
0.022433628335357114]
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+[0.53531740037073]
+\N
+\N
+\N
+\N
+[0.39019574518075095, 0.15402279962516086, 0.27211035128383,
0.23725335059420649, 0.46572583857819161, 0.2159668436981298,
0.92978689132125614, 0.19791326657837849]
+[0.75045053839230924, 0.68405708856986258, 0.64613850811244844]
+[0.20821963620964712, 0.39736734574085042, 0.3810349018240714,
0.91403939754883368, 0.92903746006736454]
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+0.9297868913212561
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
diff --git
a/regression-test/suites/external_table_p0/tvf/test_local_tvf_with_complex_type_element_at.groovy
b/regression-test/suites/external_table_p0/tvf/test_local_tvf_with_complex_type_element_at.groovy
new file mode 100644
index 0000000000..b27c6bfa53
--- /dev/null
+++
b/regression-test/suites/external_table_p0/tvf/test_local_tvf_with_complex_type_element_at.groovy
@@ -0,0 +1,120 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+// This suit test the `backends` tvf
+suite("test_local_tvf_with_complex_type_element_at", "p0") {
+ List<List<Object>> table = sql """ select * from backends(); """
+ assertTrue(table.size() > 0)
+ def be_id = table[0][0]
+ def dataFilePath = context.config.dataPath + "/external_table_p0/tvf/"
+
+ /**
+ * here is file schema
+ * var schema = StructType(
+ StructField("id", IntegerType, true) ::
+ StructField("arr_arr", ArrayType(ArrayType(StringType),
true), true)::
+ StructField("arr_map", ArrayType(MapType(StringType,
DateType)), true) ::
+ StructField("arr_struct",
ArrayType(StructType(StructField("vin", StringType,
true)::StructField("charge_id", IntegerType, true)::Nil))) ::
+ StructField("map_map", MapType(StringType,
MapType(StringType, DoubleType)), true)::
+ StructField("map_arr", MapType(IntegerType,
ArrayType(DoubleType)), true)::
+ StructField("map_struct", MapType(TimestampType,
StructType(StructField("vin", StringType, true)::StructField("charge_id",
IntegerType, true)::StructField("start_time", DoubleType, true)::Nil), true))::
+ StructField("struct_arr_map",
StructType(StructField("aa", ArrayType(StringType), true)::StructField("mm",
MapType(DateType, StringType), true)::Nil))::
+ Nil
+ )
+ */
+
+ qt_sql """
+ select * from local(
+ "file_path" = "${dataFilePath}/t.orc",
+ "backend_id" = "${be_id}",
+ "format" = "orc");"""
+
+ qt_sql """
+ select count(*) from local(
+ "file_path" = "${dataFilePath}/t.orc",
+ "backend_id" = "${be_id}",
+ "format" = "orc");"""
+
+ qt_sql """ select arr_arr[1][1] from local (
+ "file_path" = "${dataFilePath}/t.orc",
+ "backend_id" = "${be_id}",
+ "format" = "orc");"""
+
+ qt_sql """ select arr_map[1] from local (
+ "file_path" = "${dataFilePath}/t.orc",
+ "backend_id" = "${be_id}",
+ "format" = "orc");"""
+ qt_sql """ select arr_map[1]["WdTnFb-LHW8Nel-laB-HCQA"] from local (
+ "file_path" = "${dataFilePath}/t.orc",
+ "backend_id" = "${be_id}",
+ "format" = "orc");"""
+
+ qt_sql """ select
map_map["W1iF16-DE1gzJx-avC-Mrf6"]["HJVQSC-46l3xm7-J6c-moIH"] from local (
+ "file_path" = "${dataFilePath}/t.orc",
+ "backend_id" = "${be_id}",
+ "format" = "orc");"""
+
+ qt_sql """ select map_arr[1] from local (
+ "file_path" = "${dataFilePath}/t.orc",
+ "backend_id" = "${be_id}",
+ "format" = "orc");"""
+ qt_sql """ select map_arr[1][7] from local (
+ "file_path" = "${dataFilePath}/t.orc",
+ "backend_id" = "${be_id}",
+ "format" = "orc");"""
+
+ qt_sql """
+ select * from local(
+ "file_path" = "${dataFilePath}/t.parquet",
+ "backend_id" = "${be_id}",
+ "format" = "parquet"); """
+
+ qt_sql """
+ select count(*) from local(
+ "file_path" = "${dataFilePath}/t.parquet",
+ "backend_id" = "${be_id}",
+ "format" = "parquet"); """
+
+
+ qt_sql """ select arr_arr[1][1] from local (
+ "file_path" = "${dataFilePath}/t.parquet",
+ "backend_id" = "${be_id}",
+ "format" = "parquet");"""
+
+ qt_sql """ select arr_map[1] from local (
+ "file_path" = "${dataFilePath}/t.parquet",
+ "backend_id" = "${be_id}",
+ "format" = "parquet");"""
+ qt_sql """ select arr_map[1]["WdTnFb-LHW8Nel-laB-HCQA"] from local (
+ "file_path" = "${dataFilePath}/t.parquet",
+ "backend_id" = "${be_id}",
+ "format" = "parquet");"""
+
+ qt_sql """ select
map_map["W1iF16-DE1gzJx-avC-Mrf6"]["HJVQSC-46l3xm7-J6c-moIH"] from local (
+ "file_path" = "${dataFilePath}/t.parquet",
+ "backend_id" = "${be_id}",
+ "format" = "parquet");"""
+
+ qt_sql """ select map_arr[1] from local (
+ "file_path" = "${dataFilePath}/t.parquet",
+ "backend_id" = "${be_id}",
+ "format" = "parquet");"""
+ qt_sql """ select map_arr[1][7] from local (
+ "file_path" = "${dataFilePath}/t.parquet",
+ "backend_id" = "${be_id}",
+ "format" = "parquet");"""
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
