(doris) branch master updated: [regression](p2) fix test cases result (#28768)

[mo...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

morningman 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 5d8c4656440 [regression](p2) fix test cases result (#28768)
5d8c4656440 is described below

commit 5d8c46564402b2793470bd70da05fafb5f82e62c
Author: Mingyu Chen <mo...@163.com>
AuthorDate: Thu Dec 21 14:38:30 2023 +0800

    [regression](p2) fix test cases result (#28768)
    
    regression-test/data/external_table_p2/hive/test_hive_hudi.out
    regression-test/data/external_table_p2/hive/test_hive_to_array.out
    regression-test/suites/external_table_p2/tvf/test_local_tvf_compression.groovy
    regression-test/suites/external_table_p2/tvf/test_path_partition_keys.groovy
    regression-test/data/external_table_p2/hive/test_hive_text_complex_type.out
---
 .../data/external_table_p2/hive/test_hive_hudi.out | 200 ++++++++++-----------
 .../hive/test_hive_text_complex_type.out           |  42 ++---
 .../external_table_p2/hive/test_hive_to_array.out  |  20 +--
 .../tvf/test_local_tvf_compression.groovy          |  12 ++
 .../tvf/test_path_partition_keys.groovy            |  18 +-
 5 files changed, 156 insertions(+), 136 deletions(-)

diff --git a/regression-test/data/external_table_p2/hive/test_hive_hudi.out b/regression-test/data/external_table_p2/hive/test_hive_hudi.out
index 3bee0e318da..adff3889cf2 100644
--- a/regression-test/data/external_table_p2/hive/test_hive_hudi.out
+++ b/regression-test/data/external_table_p2/hive/test_hive_hudi.out
@@ -18,106 +18,106 @@ row_2	2021-01-01	0	v_0
 row_4	2021-02-01	4	v_4
 
 -- !complex_types --
-20230922203209630	20230922203209630_0_10000	10002		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	10002	a9999	[[9999], [3333], [9999, 8999, NULL]]	{"k9999":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 00:26:48.000000, [10008, 9999, NULL]}
-20230922203209630	20230922203209630_0_9999	10001		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	10001	a9998	[[9998], [3332], [9998, 8998, NULL]]	{"k9998":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 23:25:47.000000, [10007, 9998, NULL]}
-20230922203209630	20230922203209630_0_9998	10000		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	10000	a9997	[[9997], [3332], [9997, 8997, NULL]]	{"k9997":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 22:24:46.000000, [10006, 9997, NULL]}
-20230922203209630	20230922203209630_0_9997	9999		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9999	a9996	[[9996], [3332], [9996, 8996, NULL]]	{"k9996":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 21:23:45.000000, [10005, 9996, NULL]}
-20230922203209630	20230922203209630_0_9996	9998		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9998	a9995	[[9995], [], [9995, 8995, NULL]]	{"k9995":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 20:22:44.000000, [10004, 9995, NULL]}
-20230922203209630	20230922203209630_0_9995	9997		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9997	a9994	[[9994], [3331], [9994, 8994, NULL]]	{"k9994":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 19:21:43.000000, [10003, 9994, NULL]}
-20230922203209630	20230922203209630_0_9994	9996		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9996	a9993	[[9993], [3331], [9993, 8993, NULL]]	{"k9993":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 18:20:42.000000, [10002, 9993, NULL]}
-20230922204306289	20230922204306289_0_542	9995		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9995	a9992-1	[[9992], [3330], [9992, 8992, NULL]]	{"k3":NULL, "k4":[NULL, 9], "k9992":[1, NULL, 9], "k2":[]}	{2012-02-02 17:19:41.000000, [10001, 9992, NULL]}
-20230922203209630	20230922203209630_0_9992	9994		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9994	a9991	[[9991], [3330], [9991, 8991, NULL]]	{"k9991":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 16:18:40.000000, [10000, 9991, NULL]}
-20230922203209630	20230922203209630_0_9991	9993		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9993	a9990	[NULL, [], [9990, 8990, NULL]]	{"k9990":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 15:17:39.000000, [9999, NULL, NULL]}
-20230922203209630	20230922203209630_0_1000	1002		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	1002	a999	[[999], [333], [999, -1, NULL]]	{"k999":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 14:32:13.000000, [1008, 999, NULL]}
-20230922203209630	20230922203209630_0_9990	9992		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9992	a9989	[[9989], [3329], [9989, 8989, NULL]]	{"k9989":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 14:16:38.000000, [9998, 9989, NULL]}
-20230922203209630	20230922203209630_0_9989	9991		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9991	a9988	[[9988], [3329], [9988, 8988, NULL]]	{"k9988":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 13:15:37.000000, [9997, 9988, NULL]}
-20230922203209630	20230922203209630_0_9988	9990		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9990	a9987	[[9987], [3329], [9987, 8987, NULL]]	{"k9987":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 12:14:36.000000, [9996, 9987, NULL]}
-20230922203209630	20230922203209630_0_9987	9989		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9989	a9986	[[9986], [3328], [9986, 8986, NULL]]	{"k9986":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 11:13:35.000000, [9995, 9986, NULL]}
-20230922203209630	20230922203209630_0_9986	9988		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9988	a9985	[[9985], [], [9985, 8985, NULL]]	{"k9985":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 10:12:34.000000, [9994, 9985, NULL]}
-20230922203209630	20230922203209630_0_9985	9987		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9987	a9984	[[9984], [3328], [9984, 8984, NULL]]	{"k9984":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 09:11:33.000000, [9993, 9984, NULL]}
-20230922203209630	20230922203209630_0_9984	9986		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9986	a9983	[[9983], [3327], [9983, 8983, NULL]]	{"k9983":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 08:10:32.000000, [9992, 9983, NULL]}
-20230922204306289	20230922204306289_0_32	9985		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9985	a9982-1	[[9982], [3327], [9982, 8982, NULL]]	{"k3":NULL, "k4":[NULL, 9], "k9982":[1, NULL, 9], "k2":[]}	{2012-02-02 07:09:31.000000, [9991, 9982, NULL]}
-20230922203209630	20230922203209630_0_9982	9984		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9984	a9981	[[9981], [3327], [9981, 8981, NULL]]	{"k9981":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 06:08:30.000000, [9990, 9981, NULL]}
-20230922203209630	20230922203209630_0_9981	9983		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9983	a9980	[NULL, [], [9980, 8980, NULL]]	{"k9980":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 05:07:29.000000, [9989, NULL, NULL]}
-20230922203209630	20230922203209630_0_999	1001		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	1001	a998	[[998], [332], [998, -2, NULL]]	{"k998":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 13:31:12.000000, [1007, 998, NULL]}
-20230922203209630	20230922203209630_0_9980	9982		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9982	a9979	[[9979], [3326], [9979, 8979, NULL]]	{"k9979":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 04:06:28.000000, [9988, 9979, NULL]}
-20230922203209630	20230922203209630_0_9979	9981		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9981	a9978	[[9978], [3326], [9978, 8978, NULL]]	{"k9978":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 03:05:27.000000, [9987, 9978, NULL]}
-20230922203209630	20230922203209630_0_9978	9980		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9980	a9977	[[9977], [3325], [9977, 8977, NULL]]	{"k9977":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 02:04:26.000000, [9986, 9977, NULL]}
-20230922203209630	20230922203209630_0_9977	9979		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9979	a9976	[[9976], [3325], [9976, 8976, NULL]]	{"k9976":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 01:03:25.000000, [9985, 9976, NULL]}
-20230922203209630	20230922203209630_0_9976	9978		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9978	a9975	[[9975], [], [9975, 8975, NULL]]	{"k9975":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 10:02:24.000000, [9984, 9975, NULL]}
-20230922203209630	20230922203209630_0_9975	9977		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9977	a9974	[[9974], [3324], [9974, 8974, NULL]]	{"k9974":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 09:58:23.000000, [9983, 9974, NULL]}
-20230922203209630	20230922203209630_0_9974	9976		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9976	a9973	[[9973], [3324], [9973, 8973, NULL]]	{"k9973":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 08:57:22.000000, [9982, 9973, NULL]}
-20230922204306289	20230922204306289_0_939	9975		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9975	a9972-1	[[9972], [3324], [9972, 8972, NULL]]	{"k9972":[1, NULL, 9], "k3":NULL, "k4":[NULL, 9], "k2":[]}	{2012-02-04 07:56:21.000000, [9981, 9972, NULL]}
-20230922203209630	20230922203209630_0_9972	9974		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9974	a9971	[[9971], [3323], [9971, 8971, NULL]]	{"k9971":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 06:55:20.000000, [9980, 9971, NULL]}
-20230922203209630	20230922203209630_0_9971	9973		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9973	a9970	[NULL, [], [9970, 8970, NULL]]	{"k9970":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 05:54:19.000000, [9979, NULL, NULL]}
-20230922203209630	20230922203209630_0_998	1000		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	1000	a997	[[997], [332], [997, -3, NULL]]	{"k997":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 12:30:11.000000, [1006, 997, NULL]}
-20230922203209630	20230922203209630_0_9970	9972		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9972	a9969	[[9969], [3323], [9969, 8969, NULL]]	{"k9969":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 04:53:18.000000, [9978, 9969, NULL]}
-20230922203209630	20230922203209630_0_9969	9971		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9971	a9968	[[9968], [3322], [9968, 8968, NULL]]	{"k9968":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 03:52:17.000000, [9977, 9968, NULL]}
-20230922203209630	20230922203209630_0_9968	9970		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9970	a9967	[[9967], [3322], [9967, 8967, NULL]]	{"k9967":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 02:51:16.000000, [9976, 9967, NULL]}
-20230922203209630	20230922203209630_0_9967	9969		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9969	a9966	[[9966], [3322], [9966, 8966, NULL]]	{"k9966":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 01:50:15.000000, [9975, 9966, NULL]}
-20230922203209630	20230922203209630_0_9966	9968		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9968	a9965	[[9965], [], [9965, 8965, NULL]]	{"k9965":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 00:49:14.000000, [9974, 9965, NULL]}
-20230922203209630	20230922203209630_0_9965	9967		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9967	a9964	[[9964], [3321], [9964, 8964, NULL]]	{"k9964":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 23:48:13.000000, [9973, 9964, NULL]}
-20230922203209630	20230922203209630_0_9964	9966		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9966	a9963	[[9963], [3321], [9963, 8963, NULL]]	{"k9963":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 22:47:12.000000, [9972, 9963, NULL]}
-20230922204306289	20230922204306289_0_173	9965		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9965	a9962-1	[[9962], [3320], [9962, 8962, NULL]]	{"k3":NULL, "k9962":[1, NULL, 9], "k4":[NULL, 9], "k2":[]}	{2012-02-03 21:46:11.000000, [9971, 9962, NULL]}
-20230922203209630	20230922203209630_0_9962	9964		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9964	a9961	[[9961], [3320], [9961, 8961, NULL]]	{"k9961":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 20:45:10.000000, [9970, 9961, NULL]}
-20230922203209630	20230922203209630_0_9961	9963		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9963	a9960	[NULL, [], [9960, 8960, NULL]]	{"k9960":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 19:44:09.000000, [9969, NULL, NULL]}
-20230922203209630	20230922203209630_0_997	999		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	999	a996	[[996], [332], [996, -4, NULL]]	{"k996":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 11:29:10.000000, [1005, 996, NULL]}
-20230922203209630	20230922203209630_0_9960	9962		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9962	a9959	[[9959], [3319], [9959, 8959, NULL]]	{"k9959":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 18:43:08.000000, [9968, 9959, NULL]}
-20230922203209630	20230922203209630_0_9959	9961		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9961	a9958	[[9958], [3319], [9958, 8958, NULL]]	{"k9958":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 17:42:07.000000, [9967, 9958, NULL]}
-20230922203209630	20230922203209630_0_9958	9960		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9960	a9957	[[9957], [3319], [9957, 8957, NULL]]	{"k9957":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 16:41:06.000000, [9966, 9957, NULL]}
-20230922203209630	20230922203209630_0_9957	9959		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9959	a9956	[[9956], [3318], [9956, 8956, NULL]]	{"k9956":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 15:40:05.000000, [9965, 9956, NULL]}
-20230922203209630	20230922203209630_0_9956	9958		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9958	a9955	[[9955], [], [9955, 8955, NULL]]	{"k9955":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 14:39:04.000000, [9964, 9955, NULL]}
-20230922203209630	20230922203209630_0_9955	9957		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9957	a9954	[[9954], [3318], [9954, 8954, NULL]]	{"k9954":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 13:38:58.000000, [9963, 9954, NULL]}
-20230922203209630	20230922203209630_0_9954	9956		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9956	a9953	[[9953], [3317], [9953, 8953, NULL]]	{"k9953":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 12:37:57.000000, [9962, 9953, NULL]}
-20230922204306289	20230922204306289_0_665	9955		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9955	a9952-1	[[9952], [3317], [9952, 8952, NULL]]	{"k3":NULL, "k4":[NULL, 9], "k9952":[1, NULL, 9], "k2":[]}	{2012-02-03 11:36:56.000000, [9961, 9952, NULL]}
-20230922203209630	20230922203209630_0_9952	9954		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9954	a9951	[[9951], [3317], [9951, 8951, NULL]]	{"k9951":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 10:35:55.000000, [9960, 9951, NULL]}
-20230922203209630	20230922203209630_0_9951	9953		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9953	a9950	[NULL, [], [9950, 8950, NULL]]	{"k9950":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 09:34:54.000000, [9959, NULL, NULL]}
-20230922203209630	20230922203209630_0_996	998		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	998	a995	[[995], [], [995, -5, NULL]]	{"k995":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 10:28:09.000000, [1004, 995, NULL]}
-20230922203209630	20230922203209630_0_9950	9952		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9952	a9949	[[9949], [3316], [9949, 8949, NULL]]	{"k9949":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 08:33:53.000000, [9958, 9949, NULL]}
-20230922203209630	20230922203209630_0_9949	9951		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9951	a9948	[[9948], [3316], [9948, 8948, NULL]]	{"k9948":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 07:32:52.000000, [9957, 9948, NULL]}
-20230922203209630	20230922203209630_0_9948	9950		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9950	a9947	[[9947], [3315], [9947, 8947, NULL]]	{"k9947":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 06:31:51.000000, [9956, 9947, NULL]}
-20230922203209630	20230922203209630_0_9947	9949		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9949	a9946	[[9946], [3315], [9946, 8946, NULL]]	{"k9946":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 05:30:50.000000, [9955, 9946, NULL]}
-20230922203209630	20230922203209630_0_9946	9948		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9948	a9945	[[9945], [], [9945, 8945, NULL]]	{"k9945":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 04:29:49.000000, [9954, 9945, NULL]}
-20230922203209630	20230922203209630_0_9945	9947		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9947	a9944	[[9944], [3314], [9944, 8944, NULL]]	{"k9944":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 03:28:48.000000, [9953, 9944, NULL]}
-20230922203209630	20230922203209630_0_9944	9946		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9946	a9943	[[9943], [3314], [9943, 8943, NULL]]	{"k9943":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 02:27:47.000000, [9952, 9943, NULL]}
-20230922204306289	20230922204306289_0_53	9945		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9945	a9942-1	[[9942], [3314], [9942, 8942, NULL]]	{"k3":NULL, "k4":[NULL, 9], "k9942":[1, NULL, 9], "k2":[]}	{2012-02-03 01:26:46.000000, [9951, 9942, NULL]}
-20230922203209630	20230922203209630_0_9942	9944		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9944	a9941	[[9941], [3313], [9941, 8941, NULL]]	{"k9941":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-03 00:25:45.000000, [9950, 9941, NULL]}
-20230922203209630	20230922203209630_0_9941	9943		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9943	a9940	[NULL, [], [9940, 8940, NULL]]	{"k9940":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 23:24:44.000000, [9949, NULL, NULL]}
-20230922203209630	20230922203209630_0_995	997		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	997	a994	[[994], [331], [994, -6, NULL]]	{"k994":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 09:27:08.000000, [1003, 994, NULL]}
-20230922203209630	20230922203209630_0_9940	9942		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9942	a9939	[[9939], [3313], [9939, 8939, NULL]]	{"k9939":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 22:23:43.000000, [9948, 9939, NULL]}
-20230922203209630	20230922203209630_0_9939	9941		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9941	a9938	[[9938], [3312], [9938, 8938, NULL]]	{"k9938":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 21:22:42.000000, [9947, 9938, NULL]}
-20230922203209630	20230922203209630_0_9938	9940		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9940	a9937	[[9937], [3312], [9937, 8937, NULL]]	{"k9937":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 20:21:41.000000, [9946, 9937, NULL]}
-20230922203209630	20230922203209630_0_9937	9939		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9939	a9936	[[9936], [3312], [9936, 8936, NULL]]	{"k9936":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 19:20:40.000000, [9945, 9936, NULL]}
-20230922203209630	20230922203209630_0_9936	9938		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9938	a9935	[[9935], [], [9935, 8935, NULL]]	{"k9935":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 18:19:39.000000, [9944, 9935, NULL]}
-20230922203209630	20230922203209630_0_9935	9937		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9937	a9934	[[9934], [3311], [9934, 8934, NULL]]	{"k9934":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 17:18:38.000000, [9943, 9934, NULL]}
-20230922203209630	20230922203209630_0_9934	9936		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9936	a9933	[[9933], [3311], [9933, 8933, NULL]]	{"k9933":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 16:17:37.000000, [9942, 9933, NULL]}
-20230922204306289	20230922204306289_0_991	9935		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9935	a9932-1	[[9932], [3310], [9932, 8932, NULL]]	{"k3":NULL, "k4":[NULL, 9], "k9932":[1, NULL, 9], "k2":[]}	{2012-02-02 15:16:36.000000, [9941, 9932, NULL]}
-20230922203209630	20230922203209630_0_9932	9934		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9934	a9931	[[9931], [3310], [9931, 8931, NULL]]	{"k9931":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 14:15:35.000000, [9940, 9931, NULL]}
-20230922203209630	20230922203209630_0_9931	9933		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9933	a9930	[NULL, [], [9930, 8930, NULL]]	{"k9930":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 13:14:34.000000, [9939, NULL, NULL]}
-20230922203209630	20230922203209630_0_994	996		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	996	a993	[[993], [331], [993, -7, NULL]]	{"k993":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 08:26:07.000000, [1002, 993, NULL]}
-20230922203209630	20230922203209630_0_9930	9932		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9932	a9929	[[9929], [3309], [9929, 8929, NULL]]	{"k9929":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 12:13:33.000000, [9938, 9929, NULL]}
-20230922203209630	20230922203209630_0_9929	9931		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9931	a9928	[[9928], [3309], [9928, 8928, NULL]]	{"k9928":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 11:12:32.000000, [9937, 9928, NULL]}
-20230922203209630	20230922203209630_0_9928	9930		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9930	a9927	[[9927], [3309], [9927, 8927, NULL]]	{"k9927":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 10:11:31.000000, [9936, 9927, NULL]}
-20230922203209630	20230922203209630_0_9927	9929		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9929	a9926	[[9926], [3308], [9926, 8926, NULL]]	{"k9926":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 09:10:30.000000, [9935, 9926, NULL]}
-20230922203209630	20230922203209630_0_9926	9928		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9928	a9925	[[9925], [], [9925, 8925, NULL]]	{"k9925":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 08:09:29.000000, [9934, 9925, NULL]}
-20230922203209630	20230922203209630_0_9925	9927		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9927	a9924	[[9924], [3308], [9924, 8924, NULL]]	{"k9924":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 07:08:28.000000, [9933, 9924, NULL]}
-20230922203209630	20230922203209630_0_9924	9926		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9926	a9923	[[9923], [3307], [9923, 8923, NULL]]	{"k9923":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 06:07:27.000000, [9932, 9923, NULL]}
-20230922204306289	20230922204306289_0_778	9925		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9925	a9922-1	[[9922], [3307], [9922, 8922, NULL]]	{"k3":NULL, "k4":[NULL, 9], "k9922":[1, NULL, 9], "k2":[]}	{2012-02-02 05:06:26.000000, [9931, 9922, NULL]}
-20230922203209630	20230922203209630_0_9922	9924		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9924	a9921	[[9921], [3307], [9921, 8921, NULL]]	{"k9921":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 04:05:25.000000, [9930, 9921, NULL]}
-20230922203209630	20230922203209630_0_9921	9923		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9923	a9920	[NULL, [], [9920, 8920, NULL]]	{"k9920":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 03:04:24.000000, [9929, NULL, NULL]}
-20230922204306289	20230922204306289_0_100	995		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	995	a992-1	[[992], [330], [992, -8, NULL]]	{"k3":NULL, "k4":[NULL, 9], "k992":[1, NULL, 9], "k2":[]}	{2012-02-02 07:25:06.000000, [1001, 992, NULL]}
-20230922203209630	20230922203209630_0_9920	9922		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9922	a9919	[[9919], [3306], [9919, 8919, NULL]]	{"k9919":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 02:03:23.000000, [9928, 9919, NULL]}
-20230922203209630	20230922203209630_0_9919	9921		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9921	a9918	[[9918], [3306], [9918, 8918, NULL]]	{"k9918":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 01:02:22.000000, [9927, 9918, NULL]}
-20230922203209630	20230922203209630_0_9918	9920		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9920	a9917	[[9917], [3305], [9917, 8917, NULL]]	{"k9917":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 10:58:21.000000, [9926, 9917, NULL]}
-20230922203209630	20230922203209630_0_9917	9919		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9919	a9916	[[9916], [3305], [9916, 8916, NULL]]	{"k9916":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 09:57:20.000000, [9925, 9916, NULL]}
-20230922203209630	20230922203209630_0_9916	9918		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9918	a9915	[[9915], [], [9915, 8915, NULL]]	{"k9915":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 08:56:19.000000, [9924, 9915, NULL]}
-20230922203209630	20230922203209630_0_9915	9917		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9917	a9914	[[9914], [3304], [9914, 8914, NULL]]	{"k9914":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 07:55:18.000000, [9923, 9914, NULL]}
-20230922203209630	20230922203209630_0_9914	9916		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9916	a9913	[[9913], [3304], [9913, 8913, NULL]]	{"k9913":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 06:54:17.000000, [9922, 9913, NULL]}
-20230922204306289	20230922204306289_0_750	9915		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9915	a9912-1	[[9912], [3304], [9912, 8912, NULL]]	{"k3":NULL, "k4":[NULL, 9], "k9912":[1, NULL, 9], "k2":[]}	{2012-02-04 05:53:16.000000, [9921, 9912, NULL]}
-20230922203209630	20230922203209630_0_9912	9914		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9914	a9911	[[9911], [3303], [9911, 8911, NULL]]	{"k9911":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 04:52:15.000000, [9920, 9911, NULL]}
-20230922203209630	20230922203209630_0_9911	9913		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9913	a9910	[NULL, [], [9910, 8910, NULL]]	{"k9910":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 03:51:14.000000, [9919, NULL, NULL]}
-20230922203209630	20230922203209630_0_992	994		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	994	a991	[[991], [330], [991, -9, NULL]]	{"k991":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-02 06:24:05.000000, [1000, 991, NULL]}
-20230922203209630	20230922203209630_0_9910	9912		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9912	a9909	[[9909], [3303], [9909, 8909, NULL]]	{"k9909":[1, NULL, 9], "k2":[], "k3":NULL, "k4":[NULL, 9]}	{2012-02-04 02:50:13.000000, [9918, 9909, NULL]}
+20230922203209630	20230922203209630_0_10000	10002		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	10002	a9999	[[9999], [3333], [9999, 8999, null]]	{"k9999":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 00:26:48.000000", "col2": [10008, 9999, null]}
+20230922203209630	20230922203209630_0_9999	10001		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	10001	a9998	[[9998], [3332], [9998, 8998, null]]	{"k9998":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 23:25:47.000000", "col2": [10007, 9998, null]}
+20230922203209630	20230922203209630_0_9998	10000		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	10000	a9997	[[9997], [3332], [9997, 8997, null]]	{"k9997":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 22:24:46.000000", "col2": [10006, 9997, null]}
+20230922203209630	20230922203209630_0_9997	9999		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9999	a9996	[[9996], [3332], [9996, 8996, null]]	{"k9996":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 21:23:45.000000", "col2": [10005, 9996, null]}
+20230922203209630	20230922203209630_0_9996	9998		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9998	a9995	[[9995], [], [9995, 8995, null]]	{"k9995":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 20:22:44.000000", "col2": [10004, 9995, null]}
+20230922203209630	20230922203209630_0_9995	9997		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9997	a9994	[[9994], [3331], [9994, 8994, null]]	{"k9994":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 19:21:43.000000", "col2": [10003, 9994, null]}
+20230922203209630	20230922203209630_0_9994	9996		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9996	a9993	[[9993], [3331], [9993, 8993, null]]	{"k9993":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 18:20:42.000000", "col2": [10002, 9993, null]}
+20230922204306289	20230922204306289_0_542	9995		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9995	a9992-1	[[9992], [3330], [9992, 8992, null]]	{"k3":null, "k4":[null, 9], "k9992":[1, null, 9], "k2":[]}	{"col1": "2012-02-02 17:19:41.000000", "col2": [10001, 9992, null]}
+20230922203209630	20230922203209630_0_9992	9994		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9994	a9991	[[9991], [3330], [9991, 8991, null]]	{"k9991":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 16:18:40.000000", "col2": [10000, 9991, null]}
+20230922203209630	20230922203209630_0_9991	9993		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9993	a9990	[null, [], [9990, 8990, null]]	{"k9990":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 15:17:39.000000", "col2": [9999, null, null]}
+20230922203209630	20230922203209630_0_1000	1002		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	1002	a999	[[999], [333], [999, -1, null]]	{"k999":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 14:32:13.000000", "col2": [1008, 999, null]}
+20230922203209630	20230922203209630_0_9990	9992		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9992	a9989	[[9989], [3329], [9989, 8989, null]]	{"k9989":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 14:16:38.000000", "col2": [9998, 9989, null]}
+20230922203209630	20230922203209630_0_9989	9991		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9991	a9988	[[9988], [3329], [9988, 8988, null]]	{"k9988":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 13:15:37.000000", "col2": [9997, 9988, null]}
+20230922203209630	20230922203209630_0_9988	9990		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9990	a9987	[[9987], [3329], [9987, 8987, null]]	{"k9987":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 12:14:36.000000", "col2": [9996, 9987, null]}
+20230922203209630	20230922203209630_0_9987	9989		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9989	a9986	[[9986], [3328], [9986, 8986, null]]	{"k9986":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 11:13:35.000000", "col2": [9995, 9986, null]}
+20230922203209630	20230922203209630_0_9986	9988		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9988	a9985	[[9985], [], [9985, 8985, null]]	{"k9985":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 10:12:34.000000", "col2": [9994, 9985, null]}
+20230922203209630	20230922203209630_0_9985	9987		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9987	a9984	[[9984], [3328], [9984, 8984, null]]	{"k9984":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 09:11:33.000000", "col2": [9993, 9984, null]}
+20230922203209630	20230922203209630_0_9984	9986		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9986	a9983	[[9983], [3327], [9983, 8983, null]]	{"k9983":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 08:10:32.000000", "col2": [9992, 9983, null]}
+20230922204306289	20230922204306289_0_32	9985		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9985	a9982-1	[[9982], [3327], [9982, 8982, null]]	{"k3":null, "k4":[null, 9], "k9982":[1, null, 9], "k2":[]}	{"col1": "2012-02-02 07:09:31.000000", "col2": [9991, 9982, null]}
+20230922203209630	20230922203209630_0_9982	9984		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9984	a9981	[[9981], [3327], [9981, 8981, null]]	{"k9981":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 06:08:30.000000", "col2": [9990, 9981, null]}
+20230922203209630	20230922203209630_0_9981	9983		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9983	a9980	[null, [], [9980, 8980, null]]	{"k9980":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 05:07:29.000000", "col2": [9989, null, null]}
+20230922203209630	20230922203209630_0_999	1001		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	1001	a998	[[998], [332], [998, -2, null]]	{"k998":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 13:31:12.000000", "col2": [1007, 998, null]}
+20230922203209630	20230922203209630_0_9980	9982		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9982	a9979	[[9979], [3326], [9979, 8979, null]]	{"k9979":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 04:06:28.000000", "col2": [9988, 9979, null]}
+20230922203209630	20230922203209630_0_9979	9981		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9981	a9978	[[9978], [3326], [9978, 8978, null]]	{"k9978":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 03:05:27.000000", "col2": [9987, 9978, null]}
+20230922203209630	20230922203209630_0_9978	9980		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9980	a9977	[[9977], [3325], [9977, 8977, null]]	{"k9977":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 02:04:26.000000", "col2": [9986, 9977, null]}
+20230922203209630	20230922203209630_0_9977	9979		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9979	a9976	[[9976], [3325], [9976, 8976, null]]	{"k9976":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 01:03:25.000000", "col2": [9985, 9976, null]}
+20230922203209630	20230922203209630_0_9976	9978		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9978	a9975	[[9975], [], [9975, 8975, null]]	{"k9975":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 10:02:24.000000", "col2": [9984, 9975, null]}
+20230922203209630	20230922203209630_0_9975	9977		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9977	a9974	[[9974], [3324], [9974, 8974, null]]	{"k9974":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 09:58:23.000000", "col2": [9983, 9974, null]}
+20230922203209630	20230922203209630_0_9974	9976		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9976	a9973	[[9973], [3324], [9973, 8973, null]]	{"k9973":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 08:57:22.000000", "col2": [9982, 9973, null]}
+20230922204306289	20230922204306289_0_939	9975		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9975	a9972-1	[[9972], [3324], [9972, 8972, null]]	{"k9972":[1, null, 9], "k3":null, "k4":[null, 9], "k2":[]}	{"col1": "2012-02-04 07:56:21.000000", "col2": [9981, 9972, null]}
+20230922203209630	20230922203209630_0_9972	9974		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9974	a9971	[[9971], [3323], [9971, 8971, null]]	{"k9971":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 06:55:20.000000", "col2": [9980, 9971, null]}
+20230922203209630	20230922203209630_0_9971	9973		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9973	a9970	[null, [], [9970, 8970, null]]	{"k9970":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 05:54:19.000000", "col2": [9979, null, null]}
+20230922203209630	20230922203209630_0_998	1000		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	1000	a997	[[997], [332], [997, -3, null]]	{"k997":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 12:30:11.000000", "col2": [1006, 997, null]}
+20230922203209630	20230922203209630_0_9970	9972		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9972	a9969	[[9969], [3323], [9969, 8969, null]]	{"k9969":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 04:53:18.000000", "col2": [9978, 9969, null]}
+20230922203209630	20230922203209630_0_9969	9971		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9971	a9968	[[9968], [3322], [9968, 8968, null]]	{"k9968":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 03:52:17.000000", "col2": [9977, 9968, null]}
+20230922203209630	20230922203209630_0_9968	9970		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9970	a9967	[[9967], [3322], [9967, 8967, null]]	{"k9967":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 02:51:16.000000", "col2": [9976, 9967, null]}
+20230922203209630	20230922203209630_0_9967	9969		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9969	a9966	[[9966], [3322], [9966, 8966, null]]	{"k9966":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 01:50:15.000000", "col2": [9975, 9966, null]}
+20230922203209630	20230922203209630_0_9966	9968		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9968	a9965	[[9965], [], [9965, 8965, null]]	{"k9965":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 00:49:14.000000", "col2": [9974, 9965, null]}
+20230922203209630	20230922203209630_0_9965	9967		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9967	a9964	[[9964], [3321], [9964, 8964, null]]	{"k9964":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 23:48:13.000000", "col2": [9973, 9964, null]}
+20230922203209630	20230922203209630_0_9964	9966		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9966	a9963	[[9963], [3321], [9963, 8963, null]]	{"k9963":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 22:47:12.000000", "col2": [9972, 9963, null]}
+20230922204306289	20230922204306289_0_173	9965		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9965	a9962-1	[[9962], [3320], [9962, 8962, null]]	{"k3":null, "k9962":[1, null, 9], "k4":[null, 9], "k2":[]}	{"col1": "2012-02-03 21:46:11.000000", "col2": [9971, 9962, null]}
+20230922203209630	20230922203209630_0_9962	9964		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9964	a9961	[[9961], [3320], [9961, 8961, null]]	{"k9961":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 20:45:10.000000", "col2": [9970, 9961, null]}
+20230922203209630	20230922203209630_0_9961	9963		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9963	a9960	[null, [], [9960, 8960, null]]	{"k9960":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 19:44:09.000000", "col2": [9969, null, null]}
+20230922203209630	20230922203209630_0_997	999		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	999	a996	[[996], [332], [996, -4, null]]	{"k996":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 11:29:10.000000", "col2": [1005, 996, null]}
+20230922203209630	20230922203209630_0_9960	9962		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9962	a9959	[[9959], [3319], [9959, 8959, null]]	{"k9959":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 18:43:08.000000", "col2": [9968, 9959, null]}
+20230922203209630	20230922203209630_0_9959	9961		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9961	a9958	[[9958], [3319], [9958, 8958, null]]	{"k9958":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 17:42:07.000000", "col2": [9967, 9958, null]}
+20230922203209630	20230922203209630_0_9958	9960		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9960	a9957	[[9957], [3319], [9957, 8957, null]]	{"k9957":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 16:41:06.000000", "col2": [9966, 9957, null]}
+20230922203209630	20230922203209630_0_9957	9959		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9959	a9956	[[9956], [3318], [9956, 8956, null]]	{"k9956":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 15:40:05.000000", "col2": [9965, 9956, null]}
+20230922203209630	20230922203209630_0_9956	9958		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9958	a9955	[[9955], [], [9955, 8955, null]]	{"k9955":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 14:39:04.000000", "col2": [9964, 9955, null]}
+20230922203209630	20230922203209630_0_9955	9957		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9957	a9954	[[9954], [3318], [9954, 8954, null]]	{"k9954":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 13:38:58.000000", "col2": [9963, 9954, null]}
+20230922203209630	20230922203209630_0_9954	9956		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9956	a9953	[[9953], [3317], [9953, 8953, null]]	{"k9953":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 12:37:57.000000", "col2": [9962, 9953, null]}
+20230922204306289	20230922204306289_0_665	9955		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9955	a9952-1	[[9952], [3317], [9952, 8952, null]]	{"k3":null, "k4":[null, 9], "k9952":[1, null, 9], "k2":[]}	{"col1": "2012-02-03 11:36:56.000000", "col2": [9961, 9952, null]}
+20230922203209630	20230922203209630_0_9952	9954		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9954	a9951	[[9951], [3317], [9951, 8951, null]]	{"k9951":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 10:35:55.000000", "col2": [9960, 9951, null]}
+20230922203209630	20230922203209630_0_9951	9953		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9953	a9950	[null, [], [9950, 8950, null]]	{"k9950":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 09:34:54.000000", "col2": [9959, null, null]}
+20230922203209630	20230922203209630_0_996	998		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	998	a995	[[995], [], [995, -5, null]]	{"k995":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 10:28:09.000000", "col2": [1004, 995, null]}
+20230922203209630	20230922203209630_0_9950	9952		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9952	a9949	[[9949], [3316], [9949, 8949, null]]	{"k9949":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 08:33:53.000000", "col2": [9958, 9949, null]}
+20230922203209630	20230922203209630_0_9949	9951		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9951	a9948	[[9948], [3316], [9948, 8948, null]]	{"k9948":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 07:32:52.000000", "col2": [9957, 9948, null]}
+20230922203209630	20230922203209630_0_9948	9950		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9950	a9947	[[9947], [3315], [9947, 8947, null]]	{"k9947":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 06:31:51.000000", "col2": [9956, 9947, null]}
+20230922203209630	20230922203209630_0_9947	9949		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9949	a9946	[[9946], [3315], [9946, 8946, null]]	{"k9946":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 05:30:50.000000", "col2": [9955, 9946, null]}
+20230922203209630	20230922203209630_0_9946	9948		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9948	a9945	[[9945], [], [9945, 8945, null]]	{"k9945":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 04:29:49.000000", "col2": [9954, 9945, null]}
+20230922203209630	20230922203209630_0_9945	9947		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9947	a9944	[[9944], [3314], [9944, 8944, null]]	{"k9944":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 03:28:48.000000", "col2": [9953, 9944, null]}
+20230922203209630	20230922203209630_0_9944	9946		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9946	a9943	[[9943], [3314], [9943, 8943, null]]	{"k9943":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 02:27:47.000000", "col2": [9952, 9943, null]}
+20230922204306289	20230922204306289_0_53	9945		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9945	a9942-1	[[9942], [3314], [9942, 8942, null]]	{"k3":null, "k4":[null, 9], "k9942":[1, null, 9], "k2":[]}	{"col1": "2012-02-03 01:26:46.000000", "col2": [9951, 9942, null]}
+20230922203209630	20230922203209630_0_9942	9944		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9944	a9941	[[9941], [3313], [9941, 8941, null]]	{"k9941":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-03 00:25:45.000000", "col2": [9950, 9941, null]}
+20230922203209630	20230922203209630_0_9941	9943		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9943	a9940	[null, [], [9940, 8940, null]]	{"k9940":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 23:24:44.000000", "col2": [9949, null, null]}
+20230922203209630	20230922203209630_0_995	997		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	997	a994	[[994], [331], [994, -6, null]]	{"k994":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 09:27:08.000000", "col2": [1003, 994, null]}
+20230922203209630	20230922203209630_0_9940	9942		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9942	a9939	[[9939], [3313], [9939, 8939, null]]	{"k9939":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 22:23:43.000000", "col2": [9948, 9939, null]}
+20230922203209630	20230922203209630_0_9939	9941		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9941	a9938	[[9938], [3312], [9938, 8938, null]]	{"k9938":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 21:22:42.000000", "col2": [9947, 9938, null]}
+20230922203209630	20230922203209630_0_9938	9940		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9940	a9937	[[9937], [3312], [9937, 8937, null]]	{"k9937":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 20:21:41.000000", "col2": [9946, 9937, null]}
+20230922203209630	20230922203209630_0_9937	9939		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9939	a9936	[[9936], [3312], [9936, 8936, null]]	{"k9936":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 19:20:40.000000", "col2": [9945, 9936, null]}
+20230922203209630	20230922203209630_0_9936	9938		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9938	a9935	[[9935], [], [9935, 8935, null]]	{"k9935":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 18:19:39.000000", "col2": [9944, 9935, null]}
+20230922203209630	20230922203209630_0_9935	9937		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9937	a9934	[[9934], [3311], [9934, 8934, null]]	{"k9934":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 17:18:38.000000", "col2": [9943, 9934, null]}
+20230922203209630	20230922203209630_0_9934	9936		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9936	a9933	[[9933], [3311], [9933, 8933, null]]	{"k9933":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 16:17:37.000000", "col2": [9942, 9933, null]}
+20230922204306289	20230922204306289_0_991	9935		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9935	a9932-1	[[9932], [3310], [9932, 8932, null]]	{"k3":null, "k4":[null, 9], "k9932":[1, null, 9], "k2":[]}	{"col1": "2012-02-02 15:16:36.000000", "col2": [9941, 9932, null]}
+20230922203209630	20230922203209630_0_9932	9934		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9934	a9931	[[9931], [3310], [9931, 8931, null]]	{"k9931":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 14:15:35.000000", "col2": [9940, 9931, null]}
+20230922203209630	20230922203209630_0_9931	9933		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9933	a9930	[null, [], [9930, 8930, null]]	{"k9930":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 13:14:34.000000", "col2": [9939, null, null]}
+20230922203209630	20230922203209630_0_994	996		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	996	a993	[[993], [331], [993, -7, null]]	{"k993":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 08:26:07.000000", "col2": [1002, 993, null]}
+20230922203209630	20230922203209630_0_9930	9932		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9932	a9929	[[9929], [3309], [9929, 8929, null]]	{"k9929":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 12:13:33.000000", "col2": [9938, 9929, null]}
+20230922203209630	20230922203209630_0_9929	9931		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9931	a9928	[[9928], [3309], [9928, 8928, null]]	{"k9928":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 11:12:32.000000", "col2": [9937, 9928, null]}
+20230922203209630	20230922203209630_0_9928	9930		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9930	a9927	[[9927], [3309], [9927, 8927, null]]	{"k9927":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 10:11:31.000000", "col2": [9936, 9927, null]}
+20230922203209630	20230922203209630_0_9927	9929		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9929	a9926	[[9926], [3308], [9926, 8926, null]]	{"k9926":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 09:10:30.000000", "col2": [9935, 9926, null]}
+20230922203209630	20230922203209630_0_9926	9928		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9928	a9925	[[9925], [], [9925, 8925, null]]	{"k9925":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 08:09:29.000000", "col2": [9934, 9925, null]}
+20230922203209630	20230922203209630_0_9925	9927		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9927	a9924	[[9924], [3308], [9924, 8924, null]]	{"k9924":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 07:08:28.000000", "col2": [9933, 9924, null]}
+20230922203209630	20230922203209630_0_9924	9926		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9926	a9923	[[9923], [3307], [9923, 8923, null]]	{"k9923":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 06:07:27.000000", "col2": [9932, 9923, null]}
+20230922204306289	20230922204306289_0_778	9925		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9925	a9922-1	[[9922], [3307], [9922, 8922, null]]	{"k3":null, "k4":[null, 9], "k9922":[1, null, 9], "k2":[]}	{"col1": "2012-02-02 05:06:26.000000", "col2": [9931, 9922, null]}
+20230922203209630	20230922203209630_0_9922	9924		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9924	a9921	[[9921], [3307], [9921, 8921, null]]	{"k9921":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 04:05:25.000000", "col2": [9930, 9921, null]}
+20230922203209630	20230922203209630_0_9921	9923		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9923	a9920	[null, [], [9920, 8920, null]]	{"k9920":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 03:04:24.000000", "col2": [9929, null, null]}
+20230922204306289	20230922204306289_0_100	995		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	995	a992-1	[[992], [330], [992, -8, null]]	{"k3":null, "k4":[null, 9], "k992":[1, null, 9], "k2":[]}	{"col1": "2012-02-02 07:25:06.000000", "col2": [1001, 992, null]}
+20230922203209630	20230922203209630_0_9920	9922		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9922	a9919	[[9919], [3306], [9919, 8919, null]]	{"k9919":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 02:03:23.000000", "col2": [9928, 9919, null]}
+20230922203209630	20230922203209630_0_9919	9921		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9921	a9918	[[9918], [3306], [9918, 8918, null]]	{"k9918":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 01:02:22.000000", "col2": [9927, 9918, null]}
+20230922203209630	20230922203209630_0_9918	9920		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9920	a9917	[[9917], [3305], [9917, 8917, null]]	{"k9917":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 10:58:21.000000", "col2": [9926, 9917, null]}
+20230922203209630	20230922203209630_0_9917	9919		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9919	a9916	[[9916], [3305], [9916, 8916, null]]	{"k9916":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 09:57:20.000000", "col2": [9925, 9916, null]}
+20230922203209630	20230922203209630_0_9916	9918		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9918	a9915	[[9915], [], [9915, 8915, null]]	{"k9915":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 08:56:19.000000", "col2": [9924, 9915, null]}
+20230922203209630	20230922203209630_0_9915	9917		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9917	a9914	[[9914], [3304], [9914, 8914, null]]	{"k9914":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 07:55:18.000000", "col2": [9923, 9914, null]}
+20230922203209630	20230922203209630_0_9914	9916		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9916	a9913	[[9913], [3304], [9913, 8913, null]]	{"k9913":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 06:54:17.000000", "col2": [9922, 9913, null]}
+20230922204306289	20230922204306289_0_750	9915		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0	9915	a9912-1	[[9912], [3304], [9912, 8912, null]]	{"k3":null, "k4":[null, 9], "k9912":[1, null, 9], "k2":[]}	{"col1": "2012-02-04 05:53:16.000000", "col2": [9921, 9912, null]}
+20230922203209630	20230922203209630_0_9912	9914		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9914	a9911	[[9911], [3303], [9911, 8911, null]]	{"k9911":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 04:52:15.000000", "col2": [9920, 9911, null]}
+20230922203209630	20230922203209630_0_9911	9913		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9913	a9910	[null, [], [9910, 8910, null]]	{"k9910":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 03:51:14.000000", "col2": [9919, null, null]}
+20230922203209630	20230922203209630_0_992	994		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	994	a991	[[991], [330], [991, -9, null]]	{"k991":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-02 06:24:05.000000", "col2": [1000, 991, null]}
+20230922203209630	20230922203209630_0_9910	9912		8b83d7ed-c150-4177-9dbb-d41169e8b9c7-0_0-163-0_20230922203209630.parquet	9912	a9909	[[9909], [3303], [9909, 8909, null]]	{"k9909":[1, null, 9], "k2":[], "k3":null, "k4":[null, 9]}	{"col1": "2012-02-04 02:50:13.000000", "col2": [9918, 9909, null]}
 
 -- !skip_merge --
 20230605145009209	20230605145009209_0_0	rowId:row_1	partitionId=2021-01-01/versionId=v_0	65ffc5d9-397a-456e-a735-30f3ad37466f-0_0-33-96_20230605145009209.parquet	row_1	2021-01-01	0	bob	v_0	toBeDel0	0	1000000
diff --git a/regression-test/data/external_table_p2/hive/test_hive_text_complex_type.out b/regression-test/data/external_table_p2/hive/test_hive_text_complex_type.out
index e1ecf56bfbf..334aef473a6 100644
--- a/regression-test/data/external_table_p2/hive/test_hive_text_complex_type.out
+++ b/regression-test/data/external_table_p2/hive/test_hive_text_complex_type.out
@@ -1,36 +1,36 @@
 -- This file is automatically generated. You should know what you did if you want to edit this
 -- !sql1 --
-1	{101:1}	{102:10}	{"field1":100}	{"field2":2000000}	{"field3":300000000}	{"field4":3.14}	{"field5":3.14159}	{103:"Hello"}	{"field6":2023-07-28 12:34:56.000000}	{"field7":2023-07-28}	{1, 1, 20, 3000000, 44444444444, 3.14, 3.14159, "Hello", 2023-07-28 12:34:56.000000, 2023-07-28}
-2	{201:1}	{202:11}	{"field1":200}	{"field2":9000000}	{"field3":8000000000}	{"field4":9.13321}	{"field5":322.14159}	{203:"Hello"}	{"field6":2023-07-28 12:34:56.000000}	{"field7":2023-07-28}	{1, 1, 201, 300011000, 44444444444, 3.14, 3.14159, "world", 2023-07-28 12:34:56.000000, 2023-06-28}
-3	{201:1}	{202:10}	{"field1":120}	{"field2":44440000}	{"field3":700000000}	{"field4":3.100004}	{"field5":3.00014159}	{103:"Hello"}	{"field6":2023-07-28 12:34:56.000000}	{"field7":2023-07-28}	{1, 1, 700, 300011000, 3333333334, 3.00014, 3.3314159, "hello world", 2023-07-28 01:34:56.000000, 2023-07-27}
-10	{101:1, 102:1, 103:1}	{102:10, 104:1, 105:2}	{"field1":100, "field0":100}	{"field2":3000000}	{"field3":300000000}	{"field4":3.14, "hello world":0.111, "hell0":7.001}	{"field5":3.14159}	{103:"Hello"}	{"field6":2023-07-28 12:34:56.000000, "field000006":2023-07-08 12:34:57.000000, "field2432456":2023-07-28 12:34:50.000000}	{"field7":2023-07-28}	{1, 1, 20, 3000000, 44444444444, 3.14, 3.14159, "Hello", 2023-07-28 12:34:56.000000, 2023-07-28}
-11	{101:1, 102:1, 13:1, 12:1}	{102:10, 14:1, 15:2, 12:10}	{"field1":100, "fie88ld0":100, "fieweld0":100, "fieeeld1":100, "fieeeld0":100, "feeield0":100, "feeield1":100, "firreld0":100, "field0":100}	{"field2":3000000, "abcd":4000000, "1231":3000000}	{"fi7eld3":300000000, "field30":300000000, "fielwwd3":300000000, "fi055":300000000, "field7":300000121323}	{"field4":3.14, "hello world":0.111, "hell0":7.001}	{"field5":3.14159}	{103:"Hello", 0:"hello"}	{"field6":2023-07-28 12:34:56.000000, " [...]
+1	{101:1}	{102:10}	{"field1":100}	{"field2":2000000}	{"field3":300000000}	{"field4":3.14}	{"field5":3.14159}	{103:"Hello"}	{"field6":"2023-07-28 12:34:56.000000"}	{"field7":"2023-07-28"}	{"field1": 1, "field2": 1, "field3": 20, "field4": 3000000, "field5": 44444444444, "field6": 3.14, "field7": 3.14159, "field8": "Hello", "field9": "2023-07-28 12:34:56.000000", "field10": "2023-07-28"}
+2	{201:1}	{202:11}	{"field1":200}	{"field2":9000000}	{"field3":8000000000}	{"field4":9.13321}	{"field5":322.14159}	{203:"Hello"}	{"field6":"2023-07-28 12:34:56.000000"}	{"field7":"2023-07-28"}	{"field1": 1, "field2": 1, "field3": 201, "field4": 300011000, "field5": 44444444444, "field6": 3.14, "field7": 3.14159, "field8": "world", "field9": "2023-07-28 12:34:56.000000", "field10": "2023-06-28"}
+3	{201:1}	{202:10}	{"field1":120}	{"field2":44440000}	{"field3":700000000}	{"field4":3.100004}	{"field5":3.00014159}	{103:"Hello"}	{"field6":"2023-07-28 12:34:56.000000"}	{"field7":"2023-07-28"}	{"field1": 1, "field2": 1, "field3": 700, "field4": 300011000, "field5": 3333333334, "field6": 3.00014, "field7": 3.3314159, "field8": "hello world", "field9": "2023-07-28 01:34:56.000000", "field10": "2023-07-27"}
+10	{101:1, 102:1, 103:1}	{102:10, 104:1, 105:2}	{"field1":100, "field0":100}	{"field2":3000000}	{"field3":300000000}	{"field4":3.14, "hello world":0.111, "hell0":7.001}	{"field5":3.14159}	{103:"Hello"}	{"field6":"2023-07-28 12:34:56.000000", "field000006":"2023-07-08 12:34:57.000000", "field2432456":"2023-07-28 12:34:50.000000"}	{"field7":"2023-07-28"}	{"field1": 1, "field2": 1, "field3": 20, "field4": 3000000, "field5": 44444444444, "field6": 3.14, "field7": 3.14159, "field8": "Hello",  [...]
+11	{101:1, 102:1, 13:1, 12:1}	{102:10, 14:1, 15:2, 12:10}	{"field1":100, "fie88ld0":100, "fieweld0":100, "fieeeld1":100, "fieeeld0":100, "feeield0":100, "feeield1":100, "firreld0":100, "field0":100}	{"field2":3000000, "abcd":4000000, "1231":3000000}	{"fi7eld3":300000000, "field30":300000000, "fielwwd3":300000000, "fi055":300000000, "field7":300000121323}	{"field4":3.14, "hello world":0.111, "hell0":7.001}	{"field5":3.14159}	{103:"Hello", 0:"hello"}	{"field6":"2023-07-28 12:34:56.000000", [...]
 
 -- !sql2 --
-1	{101:1}	{102:10}	{"field1":100}	{"field2":2000000}	{"field3":300000000}	{"field4":3.14}	{"field5":3.14159}	{103:"Hello"}	{"field6":2023-07-28 12:34:56.000000}	{"field7":2023-07-28}	{1, 1, 20, 3000000, 44444444444, 3.14, 3.14159, "Hello", 2023-07-28 12:34:56.000000, 2023-07-28}
-2	{201:1}	{202:11}	{"field1":200}	{"field2":9000000}	{"field3":8000000000}	{"field4":9.13321}	{"field5":322.14159}	{203:"Hello"}	{"field6":2023-07-28 12:34:56.000000}	{"field7":2023-07-28}	{1, 1, 201, 300011000, 44444444444, 3.14, 3.14159, "world", 2023-07-28 12:34:56.000000, 2023-06-28}
-3	{201:1}	{202:10}	{"field1":120}	{"field2":44440000}	{"field3":700000000}	{"field4":3.100004}	{"field5":3.00014159}	{103:"Hello"}	{"field6":2023-07-28 12:34:56.000000}	{"field7":2023-07-28}	{1, 1, 700, 300011000, 3333333334, 3.00014, 3.3314159, "hello world", 2023-07-28 01:34:56.000000, 2023-07-27}
-10	{101:1, 102:1, 103:1}	{102:10, 104:1, 105:2}	{"field1":100, "field0":100}	{"field2":3000000}	{"field3":300000000}	{"field4":3.14, "hello world":0.111, "hell0":7.001}	{"field5":3.14159}	{103:"Hello"}	{"field6":2023-07-28 12:34:56.000000, "field000006":2023-07-08 12:34:57.000000, "field2432456":2023-07-28 12:34:50.000000}	{"field7":2023-07-28}	{1, 1, 20, 3000000, 44444444444, 3.14, 3.14159, "Hello", 2023-07-28 12:34:56.000000, 2023-07-28}
-11	{101:1, 102:1, 13:1, 12:1}	{102:10, 14:1, 15:2, 12:10}	{"field1":100, "fie88ld0":100, "fieweld0":100, "fieeeld1":100, "fieeeld0":100, "feeield0":100, "feeield1":100, "firreld0":100, "field0":100}	{"field2":3000000, "abcd":4000000, "1231":3000000}	{"fi7eld3":300000000, "field30":300000000, "fielwwd3":300000000, "fi055":300000000, "field7":300000121323}	{"field4":3.14, "hello world":0.111, "hell0":7.001}	{"field5":3.14159}	{103:"Hello", 0:"hello"}	{"field6":2023-07-28 12:34:56.000000, " [...]
+1	{101:1}	{102:10}	{"field1":100}	{"field2":2000000}	{"field3":300000000}	{"field4":3.14}	{"field5":3.14159}	{103:"Hello"}	{"field6":"2023-07-28 12:34:56.000000"}	{"field7":"2023-07-28"}	{"field1": 1, "field2": 1, "field3": 20, "field4": 3000000, "field5": 44444444444, "field6": 3.14, "field7": 3.14159, "field8": "Hello", "field9": "2023-07-28 12:34:56.000000", "field10": "2023-07-28"}
+2	{201:1}	{202:11}	{"field1":200}	{"field2":9000000}	{"field3":8000000000}	{"field4":9.13321}	{"field5":322.14159}	{203:"Hello"}	{"field6":"2023-07-28 12:34:56.000000"}	{"field7":"2023-07-28"}	{"field1": 1, "field2": 1, "field3": 201, "field4": 300011000, "field5": 44444444444, "field6": 3.14, "field7": 3.14159, "field8": "world", "field9": "2023-07-28 12:34:56.000000", "field10": "2023-06-28"}
+3	{201:1}	{202:10}	{"field1":120}	{"field2":44440000}	{"field3":700000000}	{"field4":3.100004}	{"field5":3.00014159}	{103:"Hello"}	{"field6":"2023-07-28 12:34:56.000000"}	{"field7":"2023-07-28"}	{"field1": 1, "field2": 1, "field3": 700, "field4": 300011000, "field5": 3333333334, "field6": 3.00014, "field7": 3.3314159, "field8": "hello world", "field9": "2023-07-28 01:34:56.000000", "field10": "2023-07-27"}
+10	{101:1, 102:1, 103:1}	{102:10, 104:1, 105:2}	{"field1":100, "field0":100}	{"field2":3000000}	{"field3":300000000}	{"field4":3.14, "hello world":0.111, "hell0":7.001}	{"field5":3.14159}	{103:"Hello"}	{"field6":"2023-07-28 12:34:56.000000", "field000006":"2023-07-08 12:34:57.000000", "field2432456":"2023-07-28 12:34:50.000000"}	{"field7":"2023-07-28"}	{"field1": 1, "field2": 1, "field3": 20, "field4": 3000000, "field5": 44444444444, "field6": 3.14, "field7": 3.14159, "field8": "Hello",  [...]
+11	{101:1, 102:1, 13:1, 12:1}	{102:10, 14:1, 15:2, 12:10}	{"field1":100, "fie88ld0":100, "fieweld0":100, "fieeeld1":100, "fieeeld0":100, "feeield0":100, "feeield1":100, "firreld0":100, "field0":100}	{"field2":3000000, "abcd":4000000, "1231":3000000}	{"fi7eld3":300000000, "field30":300000000, "fielwwd3":300000000, "fi055":300000000, "field7":300000121323}	{"field4":3.14, "hello world":0.111, "hell0":7.001}	{"field5":3.14159}	{103:"Hello", 0:"hello"}	{"field6":"2023-07-28 12:34:56.000000", [...]
 
 -- !filter_complex --
 50000	50000	50000
 
 -- !sql3 --
-1	{20:{"key":100, "key10":100, "abcd":1}, 200:{"key100":33300, "abwedewcd":2}, 2000:{"key1000":1000, "abcqqqqd":3}}	[[{1:1, 20:1, 200:1}, {1:1, 20:1, 200:1}, {1:1, 20:1, 200:1}]]	{50000, {3:"value3", 4:"value4", 5:"value5", 10:"11"}, {1, 0, 7}, [1, 2, 3, 3333, 4, 4, 5, 5, 6, 0]}	{4:{50:[1, 1, 0, 0, 1, 1, 1, 1], 500:[1, 1, 0, 0], 40:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 1:{0:[0, 0]}}	{6:{0, "example"}}
-2	{10:{"key10":100, "abcd":1}, 100:{"key100":100, "abcd":2}, 1000:{"key1000":1000, "abcd":3}}	[[{1:1, 10:1, 100:1}]]	{5, {3:"value3", 4:"value4", 5:"value5"}, {1, 0, 7}, [1, 2, 3]}	{4:{5:[1, 1, 0, 0], 4:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 0:{0:[0, 0]}}	{6:{0, "example"}}
+1	{20:{"key":100, "key10":100, "abcd":1}, 200:{"key100":33300, "abwedewcd":2}, 2000:{"key1000":1000, "abcqqqqd":3}}	[[{1:1, 20:1, 200:1}, {1:1, 20:1, 200:1}, {1:1, 20:1, 200:1}]]	{"field1": 50000, "field2": {3:"value3", 4:"value4", 5:"value5", 10:"11"}, "field3": {"sub_field1": 1, "sub_field2": 0, "sub_field3": 7}, "field4": [1, 2, 3, 3333, 4, 4, 5, 5, 6, 0]}	{4:{50:[1, 1, 0, 0, 1, 1, 1, 1], 500:[1, 1, 0, 0], 40:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 1:{0:[0, 0]}}	{6:{"sub_field1": 0, "sub_fi [...]
+2	{10:{"key10":100, "abcd":1}, 100:{"key100":100, "abcd":2}, 1000:{"key1000":1000, "abcd":3}}	[[{1:1, 10:1, 100:1}]]	{"field1": 5, "field2": {3:"value3", 4:"value4", 5:"value5"}, "field3": {"sub_field1": 1, "sub_field2": 0, "sub_field3": 7}, "field4": [1, 2, 3]}	{4:{5:[1, 1, 0, 0], 4:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 0:{0:[0, 0]}}	{6:{"sub_field1": 0, "sub_field2": "example"}}
 
 -- !sql4 --
-1	{20:{"key":100, "key10":100, "abcd":1}, 200:{"key100":33300, "abwedewcd":2}, 2000:{"key1000":1000, "abcqqqqd":3}}	[[{1:1, 20:1, 200:1}, {1:1, 20:1, 200:1}, {1:1, 20:1, 200:1}]]	{50000, {3:"value3", 4:"value4", 5:"value5", 10:"11"}, {1, 0, 7}, [1, 2, 3, 3333, 4, 4, 5, 5, 6, 0]}	{4:{50:[1, 1, 0, 0, 1, 1, 1, 1], 500:[1, 1, 0, 0], 40:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 1:{0:[0, 0]}}	{6:{0, "example"}}
-2	{10:{"key10":100, "abcd":1}, 100:{"key100":100, "abcd":2}, 1000:{"key1000":1000, "abcd":3}}	[[{1:1, 10:1, 100:1}]]	{5, {3:"value3", 4:"value4", 5:"value5"}, {1, 0, 7}, [1, 2, 3]}	{4:{5:[1, 1, 0, 0], 4:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 0:{0:[0, 0]}}	{6:{0, "example"}}
+1	{20:{"key":100, "key10":100, "abcd":1}, 200:{"key100":33300, "abwedewcd":2}, 2000:{"key1000":1000, "abcqqqqd":3}}	[[{1:1, 20:1, 200:1}, {1:1, 20:1, 200:1}, {1:1, 20:1, 200:1}]]	{"field1": 50000, "field2": {3:"value3", 4:"value4", 5:"value5", 10:"11"}, "field3": {"sub_field1": 1, "sub_field2": 0, "sub_field3": 7}, "field4": [1, 2, 3, 3333, 4, 4, 5, 5, 6, 0]}	{4:{50:[1, 1, 0, 0, 1, 1, 1, 1], 500:[1, 1, 0, 0], 40:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 1:{0:[0, 0]}}	{6:{"sub_field1": 0, "sub_fi [...]
+2	{10:{"key10":100, "abcd":1}, 100:{"key100":100, "abcd":2}, 1000:{"key1000":1000, "abcd":3}}	[[{1:1, 10:1, 100:1}]]	{"field1": 5, "field2": {3:"value3", 4:"value4", 5:"value5"}, "field3": {"sub_field1": 1, "sub_field2": 0, "sub_field3": 7}, "field4": [1, 2, 3]}	{4:{5:[1, 1, 0, 0], 4:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 0:{0:[0, 0]}}	{6:{"sub_field1": 0, "sub_field2": "example"}}
 
 -- !sql5 --
-1	{1:{10, 20, [{"key1":[[[[{1003, "text1", 1}, {10133, "text2", 0}], [{10332, "text3", 1}, {103, "text4", 0}]]]], "key2":[[[[{1770, "text1000", 1}, {1177, "text2111", 0}], [{1211, "text311", 1}, {11113, "text114", 0}, {13111, "text114", 0}, {11131, "text114", 0}, {11113, "text114", 0}]]]], "key3":[[[[{10, "text1000", 1}, {11, "text2111", 0}], [{122, "text311231", 1}, {13, "text1131214", 0}, {1322, "text114", 0}, {1322, "text114", 0}, {13, "text11224", 0}]], [[{13120, "text1031300", 1}, { [...]
-2	{1:{10, 20, [{"key1":[[[[{1003, "text1", 1}, {10133, "text2", 0}], [{10332, "text3", 1}, {103, "text4", 0}]]]], "key2":[[[[{1770, "text1000", 1}, {1177, "text2111", 0}], [{1211, "text311", 1}, {11113, "text114", 0}, {13111, "text114", 0}, {11131, "text114", 0}, {11113, "text114", 0}]]]], "key3":[[[[{10, "text1000", 1}, {11, "text2111", 0}], [{122, "text311231", 1}, {13, "text1131214", 0}, {1322, "text114", 0}, {1322, "text114", 0}, {13, "text11224", 0}]], [[{13120, "text1031300", 1}, { [...]
+1	{1:{"a": 10, "b": 20, "c": [{"key1":[[[[{"aa": 1003, "bb": "text1", "cc": 1}, {"aa": 10133, "bb": "text2", "cc": 0}], [{"aa": 10332, "bb": "text3", "cc": 1}, {"aa": 103, "bb": "text4", "cc": 0}]]]], "key2":[[[[{"aa": 1770, "bb": "text1000", "cc": 1}, {"aa": 1177, "bb": "text2111", "cc": 0}], [{"aa": 1211, "bb": "text311", "cc": 1}, {"aa": 11113, "bb": "text114", "cc": 0}, {"aa": 13111, "bb": "text114", "cc": 0}, {"aa": 11131, "bb": "text114", "cc": 0}, {"aa": 11113, "bb": "text114", "c [...]
+2	{1:{"a": 10, "b": 20, "c": [{"key1":[[[[{"aa": 1003, "bb": "text1", "cc": 1}, {"aa": 10133, "bb": "text2", "cc": 0}], [{"aa": 10332, "bb": "text3", "cc": 1}, {"aa": 103, "bb": "text4", "cc": 0}]]]], "key2":[[[[{"aa": 1770, "bb": "text1000", "cc": 1}, {"aa": 1177, "bb": "text2111", "cc": 0}], [{"aa": 1211, "bb": "text311", "cc": 1}, {"aa": 11113, "bb": "text114", "cc": 0}, {"aa": 13111, "bb": "text114", "cc": 0}, {"aa": 11131, "bb": "text114", "cc": 0}, {"aa": 11113, "bb": "text114", "c [...]
 
 -- !sql6 --
-1	{1:{10, 20, [{"key1":[[[[{1003, "text1", 1}, {10133, "text2", 0}], [{10332, "text3", 1}, {103, "text4", 0}]]]], "key2":[[[[{1770, "text1000", 1}, {1177, "text2111", 0}], [{1211, "text311", 1}, {11113, "text114", 0}, {13111, "text114", 0}, {11131, "text114", 0}, {11113, "text114", 0}]]]], "key3":[[[[{10, "text1000", 1}, {11, "text2111", 0}], [{122, "text311231", 1}, {13, "text1131214", 0}, {1322, "text114", 0}, {1322, "text114", 0}, {13, "text11224", 0}]], [[{13120, "text1031300", 1}, { [...]
-2	{1:{10, 20, [{"key1":[[[[{1003, "text1", 1}, {10133, "text2", 0}], [{10332, "text3", 1}, {103, "text4", 0}]]]], "key2":[[[[{1770, "text1000", 1}, {1177, "text2111", 0}], [{1211, "text311", 1}, {11113, "text114", 0}, {13111, "text114", 0}, {11131, "text114", 0}, {11113, "text114", 0}]]]], "key3":[[[[{10, "text1000", 1}, {11, "text2111", 0}], [{122, "text311231", 1}, {13, "text1131214", 0}, {1322, "text114", 0}, {1322, "text114", 0}, {13, "text11224", 0}]], [[{13120, "text1031300", 1}, { [...]
+1	{1:{"a": 10, "b": 20, "c": [{"key1":[[[[{"aa": 1003, "bb": "text1", "cc": 1}, {"aa": 10133, "bb": "text2", "cc": 0}], [{"aa": 10332, "bb": "text3", "cc": 1}, {"aa": 103, "bb": "text4", "cc": 0}]]]], "key2":[[[[{"aa": 1770, "bb": "text1000", "cc": 1}, {"aa": 1177, "bb": "text2111", "cc": 0}], [{"aa": 1211, "bb": "text311", "cc": 1}, {"aa": 11113, "bb": "text114", "cc": 0}, {"aa": 13111, "bb": "text114", "cc": 0}, {"aa": 11131, "bb": "text114", "cc": 0}, {"aa": 11113, "bb": "text114", "c [...]
+2	{1:{"a": 10, "b": 20, "c": [{"key1":[[[[{"aa": 1003, "bb": "text1", "cc": 1}, {"aa": 10133, "bb": "text2", "cc": 0}], [{"aa": 10332, "bb": "text3", "cc": 1}, {"aa": 103, "bb": "text4", "cc": 0}]]]], "key2":[[[[{"aa": 1770, "bb": "text1000", "cc": 1}, {"aa": 1177, "bb": "text2111", "cc": 0}], [{"aa": 1211, "bb": "text311", "cc": 1}, {"aa": 11113, "bb": "text114", "cc": 0}, {"aa": 13111, "bb": "text114", "cc": 0}, {"aa": 11131, "bb": "text114", "cc": 0}, {"aa": 11113, "bb": "text114", "c [...]
 
 -- !sql7 --
 1
@@ -49,14 +49,14 @@
 1
 
 -- !sql12 --
-1	{20:{"key":100, "key10":100, "abcd":1}, 200:{"key100":33300, "abwedewcd":2}, 2000:{"key1000":1000, "abcqqqqd":3}}	[[{1:1, 20:1, 200:1}, {1:1, 20:1, 200:1}, {1:1, 20:1, 200:1}]]	{50000, {3:"value3", 4:"value4", 5:"value5", 10:"11"}, {1, 0, 7}, [1, 2, 3, 3333, 4, 4, 5, 5, 6, 0]}	{4:{50:[1, 1, 0, 0, 1, 1, 1, 1], 500:[1, 1, 0, 0], 40:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 1:{0:[0, 0]}}	{6:{0, "example"}}
-2	{10:{"key10":100, "abcd":1}, 100:{"key100":100, "abcd":2}, 1000:{"key1000":1000, "abcd":3}}	[[{1:1, 10:1, 100:1}]]	{5, {3:"value3", 4:"value4", 5:"value5"}, {1, 0, 7}, [1, 2, 3]}	{4:{5:[1, 1, 0, 0], 4:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 0:{0:[0, 0]}}	{6:{0, "example"}}
+1	{20:{"key":100, "key10":100, "abcd":1}, 200:{"key100":33300, "abwedewcd":2}, 2000:{"key1000":1000, "abcqqqqd":3}}	[[{1:1, 20:1, 200:1}, {1:1, 20:1, 200:1}, {1:1, 20:1, 200:1}]]	{"field1": 50000, "field2": {3:"value3", 4:"value4", 5:"value5", 10:"11"}, "field3": {"sub_field1": 1, "sub_field2": 0, "sub_field3": 7}, "field4": [1, 2, 3, 3333, 4, 4, 5, 5, 6, 0]}	{4:{50:[1, 1, 0, 0, 1, 1, 1, 1], 500:[1, 1, 0, 0], 40:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 1:{0:[0, 0]}}	{6:{"sub_field1": 0, "sub_fi [...]
+2	{10:{"key10":100, "abcd":1}, 100:{"key100":100, "abcd":2}, 1000:{"key1000":1000, "abcd":3}}	[[{1:1, 10:1, 100:1}]]	{"field1": 5, "field2": {3:"value3", 4:"value4", 5:"value5"}, "field3": {"sub_field1": 1, "sub_field2": 0, "sub_field3": 7}, "field4": [1, 2, 3]}	{4:{5:[1, 1, 0, 0], 4:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 0:{0:[0, 0]}}	{6:{"sub_field1": 0, "sub_field2": "example"}}
 
 -- !sql13 --
 1	{4:{50:[1, 1, 0, 0, 1, 1, 1, 1], 500:[1, 1, 0, 0], 40:[1, 1, 0, 0, 0], 3:[1, 1, 0, 0]}, 1:{0:[0, 0]}}
 
 -- !sql14 --
-{5, {3:"value3", 4:"value4", 5:"value5"}, {1, 0, 7}, [1, 2, 3]}
+{"field1": 5, "field2": {3:"value3", 4:"value4", 5:"value5"}, "field3": {"sub_field1": 1, "sub_field2": 0, "sub_field3": 7}, "field4": [1, 2, 3]}
 
 -- !sql15 --
 2
diff --git a/regression-test/data/external_table_p2/hive/test_hive_to_array.out b/regression-test/data/external_table_p2/hive/test_hive_to_array.out
index f14ff73656d..be2f15df94a 100644
--- a/regression-test/data/external_table_p2/hive/test_hive_to_array.out
+++ b/regression-test/data/external_table_p2/hive/test_hive_to_array.out
@@ -1,10 +1,10 @@
 -- This file is automatically generated. You should know what you did if you want to edit this
 -- !types --
-[1, 2, 3, 4]	[10, 20, 30, 40]	[100, 200, 300]	[100000000000000, 20000000000000, 30000000000000, 40000000000000]	[1, 0, 1]	[1.23, 4.56, 7.89]	[10.1, 20.2, 30.3]	["apple", "banana", "orange"]	[2023-07-04 12:00:00.000000, 2023-07-05 12:00:00.000000, 2023-07-06 12:00:00.000000]	[2023-07-04, 2023-07-05, 2023-07-06]	[1111111.111, 2111111.111, 3111111.111]	["a", "b", "c"]	["aa", "bb", "cc"]
-[10, 20, 30]	[100, 200, 300, 400]	[1000, 2000, 3000]	[1000000000000000, 200000000000000, 300000000000000, 400000000000000]	[1, 1, 1, 1]	[12.3, 45.6, 78.9]	[100.1, 200.2, 300.3]	["grapes", "watermelon", "kiwi"]	[2023-07-03 12:00:00.000000, 2023-07-03 12:00:00.000000, 2023-07-03 12:00:00.000000]	[2021-07-05, 2021-07-05, 2021-07-05]	[2222222.111, 2222222.112, 2222222.113]	\N	\N
-[20, 30, 40, 50]	[200, 300, 400, 500]	[10000, 20000, 30000]	[100000000000000, 20000000000000, 30000000000000]	[1, 1, 1, 1, 0, 0]	[120.3, 450.6, 780.9]	[100.001, 200.002, 300.003]	["melon", "strawberry", "blueberry"]	[2023-07-02 12:00:00.000000, 2023-07-02 12:00:00.000000, 2023-07-02 12:00:00.000000]	[2021-07-06, 2021-07-06, 2021-07-06]	[1111111.111, 2111111.111, 3111111.111]	\N	\N
-[40, 50, 60, 70]	[210, 310, 410, 510]	[110000, 210000, 310000]	[400000000000000, 50000000000000, 60000000000000]	[1]	[120.301, 450.602, 780.90009]	[100.0000001, 200.0000002, 300.0000003]	["hello", "world"]	[2023-07-02 12:00:00.000000, 2023-07-02 12:00:00.000000, 2023-07-02 12:00:00.000000]	[2021-07-06, 2021-07-06, 2021-07-06]	[3311111.111, 2211111.111, 3121111.111]	["1"]	["hello", "world"]
-[4, 5, 6, 7]	[2100, 3100, 4100, 5100]	[110000, 220000, 330000]	[60000000000000, 60000000000000, 60000000000000]	[1]	[120.301, 450.602, 780.90009]	[100.0000001, 200.0000002, 300.0000003]	["hive", "text", "file", "format"]	[2023-07-09 12:00:00.000000, 2023-07-09 12:00:00.000000, 2023-07-09 12:00:00.000000]	[2021-07-09, 2021-07-09, 2021-07-09]	[3311111.111, 2211111.111, 3121111.111]	["d", "d", "d", "d"]	["ffffffff"]
+[1, 2, 3, 4]	[10, 20, 30, 40]	[100, 200, 300]	[100000000000000, 20000000000000, 30000000000000, 40000000000000]	[1, 0, 1]	[1.23, 4.56, 7.89]	[10.1, 20.2, 30.3]	["apple", "banana", "orange"]	["2023-07-04 12:00:00.000000", "2023-07-05 12:00:00.000000", "2023-07-06 12:00:00.000000"]	["2023-07-04", "2023-07-05", "2023-07-06"]	[1111111.111, 2111111.111, 3111111.111]	["a", "b", "c"]	["aa", "bb", "cc"]
+[10, 20, 30]	[100, 200, 300, 400]	[1000, 2000, 3000]	[1000000000000000, 200000000000000, 300000000000000, 400000000000000]	[1, 1, 1, 1]	[12.3, 45.6, 78.9]	[100.1, 200.2, 300.3]	["grapes", "watermelon", "kiwi"]	["2023-07-03 12:00:00.000000", "2023-07-03 12:00:00.000000", "2023-07-03 12:00:00.000000"]	["2021-07-05", "2021-07-05", "2021-07-05"]	[2222222.111, 2222222.112, 2222222.113]	\N	\N
+[20, 30, 40, 50]	[200, 300, 400, 500]	[10000, 20000, 30000]	[100000000000000, 20000000000000, 30000000000000]	[1, 1, 1, 1, 0, 0]	[120.3, 450.6, 780.9]	[100.001, 200.002, 300.003]	["melon", "strawberry", "blueberry"]	["2023-07-02 12:00:00.000000", "2023-07-02 12:00:00.000000", "2023-07-02 12:00:00.000000"]	["2021-07-06", "2021-07-06", "2021-07-06"]	[1111111.111, 2111111.111, 3111111.111]	\N	\N
+[40, 50, 60, 70]	[210, 310, 410, 510]	[110000, 210000, 310000]	[400000000000000, 50000000000000, 60000000000000]	[1]	[120.301, 450.602, 780.90009]	[100.0000001, 200.0000002, 300.0000003]	["hello", "world"]	["2023-07-02 12:00:00.000000", "2023-07-02 12:00:00.000000", "2023-07-02 12:00:00.000000"]	["2021-07-06", "2021-07-06", "2021-07-06"]	[3311111.111, 2211111.111, 3121111.111]	["1"]	["hello", "world"]
+[4, 5, 6, 7]	[2100, 3100, 4100, 5100]	[110000, 220000, 330000]	[60000000000000, 60000000000000, 60000000000000]	[1]	[120.301, 450.602, 780.90009]	[100.0000001, 200.0000002, 300.0000003]	["hive", "text", "file", "format"]	["2023-07-09 12:00:00.000000", "2023-07-09 12:00:00.000000", "2023-07-09 12:00:00.000000"]	["2021-07-09", "2021-07-09", "2021-07-09"]	[3311111.111, 2211111.111, 3121111.111]	["d", "d", "d", "d"]	["ffffffff"]
 
 -- !array --
 1	[[[1, 2, 3], [4, 5, 6], [7, 8, 9]], [[10, 11, 12], [13, 14, 15], [16, 17, 18]]]
@@ -14,9 +14,9 @@
 5	[[[1, 2, 3], [4, 5, 6], [7, 8, 9]], [[10, 11, 12], [13, 14, 15], [16, 17, 18]], [[1, 2, 3], [4, 5, 6], [7, 8, 9]], [[10, 11, 12], [13, 14, 15], [16, 17, 18]]]
 
 -- !delimiter --
-[1, 2, 3, 4]	[10, 20, 30, 40]	[100, 200, 300]	[100000000000000, 20000000000000, 30000000000000, 40000000000000]	[1, 0, 1]	[1.23, 4.56, 7.89]	[10.1, 20.2, 30.3]	["apple", "banana", "orange"]	[2023-07-04 12:00:00.000000, 2023-07-05 12:00:00.000000, 2023-07-06 12:00:00.000000]	[2023-07-04, 2023-07-05, 2023-07-06]	[1111111.111, 2111111.111, 3111111.111]	1	[[[1, 2, 3], [4, 5, 6], [7, 8, 9]], [[10, 11, 12], [13, 14, 15], [16, 17, 18]]]
-[10, 20, 30]	[100, 200, 300, 400]	[1000, 2000, 3000]	[1000000000000000, 200000000000000, 300000000000000, 400000000000000]	[1, 1, 1, 1]	[12.3, 45.6, 78.9]	[100.1, 200.2, 300.3]	["grapes", "watermelon", "kiwi"]	[2023-07-03 12:00:00.000000, 2023-07-03 12:00:00.000000, 2023-07-03 12:00:00.000000]	[2021-07-05, 2021-07-05, 2021-07-05]	[2222222.111, 2222222.112, 2222222.113]	2	[[[19, 20, 21], [22, 23, 24], [25, 26, 27]], [[28], [31], [34]], [[28, 29], [31, 32], [34, 35]]]
-[20, 30, 40, 50]	[200, 300, 400, 500]	[10000, 20000, 30000]	[100000000000000, 20000000000000, 30000000000000]	[1, 1, 1, 1, 0, 0]	[120.3, 450.6, 780.9]	[100.001, 200.002, 300.003]	["melon", "strawberry", "blueberry"]	[2023-07-02 12:00:00.000000, 2023-07-02 12:00:00.000000, 2023-07-02 12:00:00.000000]	[2021-07-06, 2021-07-06, 2021-07-06]	[1111111.111, 2111111.111, 3111111.111]	3	[[[1, 2, 3], [4, 5, 6], [7, 8, 9]]]
-[40, 50, 60, 70]	[210, 310, 410, 510]	[110000, 210000, 310000]	[400000000000000, 50000000000000, 60000000000000]	[1]	[120.301, 450.602, 780.90009]	[100.0000001, 200.0000002, 300.0000003]	["hello", "world"]	[2023-07-02 12:00:00.000000, 2023-07-02 12:00:00.000000, 2023-07-02 12:00:00.000000]	[2021-07-06, 2021-07-06, 2021-07-06]	[3311111.111, 2211111.111, 3121111.111]	4	[[[1]]]
-[4, 5, 6, 7]	[2100, 3100, 4100, 5100]	[110000, 220000, 330000]	[60000000000000, 60000000000000, 60000000000000]	[1]	[120.301, 450.602, 780.90009]	[100.0000001, 200.0000002, 300.0000003]	["hive", "text", "file", "format"]	[2023-07-09 12:00:00.000000, 2023-07-09 12:00:00.000000, 2023-07-09 12:00:00.000000]	[2021-07-09, 2021-07-09, 2021-07-09]	[3311111.111, 2211111.111, 3121111.111]	5	[[[1, 2, 3], [4, 5, 6], [7, 8, 9]], [[10, 11, 12], [13, 14, 15], [16, 17, 18]], [[1, 2, 3], [4, 5, 6], [7,  [...]
+[1, 2, 3, 4]	[10, 20, 30, 40]	[100, 200, 300]	[100000000000000, 20000000000000, 30000000000000, 40000000000000]	[1, 0, 1]	[1.23, 4.56, 7.89]	[10.1, 20.2, 30.3]	["apple", "banana", "orange"]	["2023-07-04 12:00:00.000000", "2023-07-05 12:00:00.000000", "2023-07-06 12:00:00.000000"]	["2023-07-04", "2023-07-05", "2023-07-06"]	[1111111.111, 2111111.111, 3111111.111]	1	[[[1, 2, 3], [4, 5, 6], [7, 8, 9]], [[10, 11, 12], [13, 14, 15], [16, 17, 18]]]
+[10, 20, 30]	[100, 200, 300, 400]	[1000, 2000, 3000]	[1000000000000000, 200000000000000, 300000000000000, 400000000000000]	[1, 1, 1, 1]	[12.3, 45.6, 78.9]	[100.1, 200.2, 300.3]	["grapes", "watermelon", "kiwi"]	["2023-07-03 12:00:00.000000", "2023-07-03 12:00:00.000000", "2023-07-03 12:00:00.000000"]	["2021-07-05", "2021-07-05", "2021-07-05"]	[2222222.111, 2222222.112, 2222222.113]	2	[[[19, 20, 21], [22, 23, 24], [25, 26, 27]], [[28], [31], [34]], [[28, 29], [31, 32], [34, 35]]]
+[20, 30, 40, 50]	[200, 300, 400, 500]	[10000, 20000, 30000]	[100000000000000, 20000000000000, 30000000000000]	[1, 1, 1, 1, 0, 0]	[120.3, 450.6, 780.9]	[100.001, 200.002, 300.003]	["melon", "strawberry", "blueberry"]	["2023-07-02 12:00:00.000000", "2023-07-02 12:00:00.000000", "2023-07-02 12:00:00.000000"]	["2021-07-06", "2021-07-06", "2021-07-06"]	[1111111.111, 2111111.111, 3111111.111]	3	[[[1, 2, 3], [4, 5, 6], [7, 8, 9]]]
+[40, 50, 60, 70]	[210, 310, 410, 510]	[110000, 210000, 310000]	[400000000000000, 50000000000000, 60000000000000]	[1]	[120.301, 450.602, 780.90009]	[100.0000001, 200.0000002, 300.0000003]	["hello", "world"]	["2023-07-02 12:00:00.000000", "2023-07-02 12:00:00.000000", "2023-07-02 12:00:00.000000"]	["2021-07-06", "2021-07-06", "2021-07-06"]	[3311111.111, 2211111.111, 3121111.111]	4	[[[1]]]
+[4, 5, 6, 7]	[2100, 3100, 4100, 5100]	[110000, 220000, 330000]	[60000000000000, 60000000000000, 60000000000000]	[1]	[120.301, 450.602, 780.90009]	[100.0000001, 200.0000002, 300.0000003]	["hive", "text", "file", "format"]	["2023-07-09 12:00:00.000000", "2023-07-09 12:00:00.000000", "2023-07-09 12:00:00.000000"]	["2021-07-09", "2021-07-09", "2021-07-09"]	[3311111.111, 2211111.111, 3121111.111]	5	[[[1, 2, 3], [4, 5, 6], [7, 8, 9]], [[10, 11, 12], [13, 14, 15], [16, 17, 18]], [[1, 2, 3], [4, [...]
 
diff --git a/regression-test/suites/external_table_p2/tvf/test_local_tvf_compression.groovy b/regression-test/suites/external_table_p2/tvf/test_local_tvf_compression.groovy
index 8b13d88a4fc..343afab56f9 100644
--- a/regression-test/suites/external_table_p2/tvf/test_local_tvf_compression.groovy
+++ b/regression-test/suites/external_table_p2/tvf/test_local_tvf_compression.groovy
@@ -41,6 +41,7 @@ suite("test_local_tvf_compression", "p2,external,tvf,external_remote,external_re
         "file_path" = "${outFilePath}/${filename}.${compress_type}",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "compress_type" ="${compress_type}") order by c1,c2,c3,c4,c5  limit 12;            
     """
     
@@ -49,6 +50,7 @@ suite("test_local_tvf_compression", "p2,external,tvf,external_remote,external_re
         "file_path" = "${outFilePath}/${filename}.${compress_type}",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "compress_type" ="${compress_type}") where c1="1" order by c1,c2,c3,c4,c5  limit 12;            
     """
 
@@ -60,6 +62,7 @@ suite("test_local_tvf_compression", "p2,external,tvf,external_remote,external_re
         "file_path" = "${outFilePath}/${filename}.${compress_type}",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "compress_type" ="${compress_type}") order by c1,c2,c3,c4,c5 limit 15;            
     """
     qt_bz2_2 """
@@ -67,6 +70,7 @@ suite("test_local_tvf_compression", "p2,external,tvf,external_remote,external_re
         "file_path" = "${outFilePath}/${filename}.${compress_type}",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "compress_type" ="${compress_type}") order by cast(c4 as date),c1 limit 15;            
     """
 
@@ -80,6 +84,7 @@ suite("test_local_tvf_compression", "p2,external,tvf,external_remote,external_re
         "file_path" = "${outFilePath}/${filename}.${compress_type}",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "compress_type" ="${compress_type}FRAME") order by c1,c2,c3,c4,c5 limit 20;            
     """
     qt_lz4_2 """
@@ -87,6 +92,7 @@ suite("test_local_tvf_compression", "p2,external,tvf,external_remote,external_re
         "file_path" = "${outFilePath}/${filename}.${compress_type}",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "compress_type" ="${compress_type}FRAME")  where c2!="abcsdasdsadsad"  order by cast(c1 as int),c2,c3  limit 20;            
     """
 
@@ -98,6 +104,7 @@ suite("test_local_tvf_compression", "p2,external,tvf,external_remote,external_re
         "file_path" = "${outFilePath}/${filename}.${compress_type}",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "compress_type" ="${compress_type}") order by c1,c2,c3,c4,c5 limit 12 ;            
     """
     qt_deflate_2 """ 
@@ -105,6 +112,7 @@ suite("test_local_tvf_compression", "p2,external,tvf,external_remote,external_re
         "file_path" = "${outFilePath}/${filename}.${compress_type}",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "compress_type" ="${compress_type}") group by c4 order by c4 limit 12 ;            
     """ 
    
@@ -116,6 +124,7 @@ suite("test_local_tvf_compression", "p2,external,tvf,external_remote,external_re
         "file_path" = "${outFilePath}/${filename}.${compress_type}",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "compress_type" ="${compress_type}block") order by c1,c2,c3,c4,c5  limit 22 ;            
     """    
     qt_snappy_2 """ 
@@ -123,6 +132,7 @@ suite("test_local_tvf_compression", "p2,external,tvf,external_remote,external_re
         "file_path" = "${outFilePath}/${filename}.${compress_type}",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "compress_type" ="${compress_type}block") where c2="abcd" order by c3 limit 22 ;            
     """
 
@@ -132,6 +142,7 @@ suite("test_local_tvf_compression", "p2,external,tvf,external_remote,external_re
         select count(*) from local(
             "file_path" = "../be.out",
             "backend_id" = "${be_id}",
+            "column_separator" = ",",
             "format" = "csv")
         where c1 like "%FE type%";
         """
@@ -144,6 +155,7 @@ suite("test_local_tvf_compression", "p2,external,tvf,external_remote,external_re
         select count(*) from local(
             "file_path" = "./xx.out",
             "backend_id" = "${be_id}",
+            "column_separator" = ",",
             "format" = "csv")
         where c1 like "%FE type%";
         """
diff --git a/regression-test/suites/external_table_p2/tvf/test_path_partition_keys.groovy b/regression-test/suites/external_table_p2/tvf/test_path_partition_keys.groovy
index dcd98af2f9d..a859d1efb9b 100644
--- a/regression-test/suites/external_table_p2/tvf/test_path_partition_keys.groovy
+++ b/regression-test/suites/external_table_p2/tvf/test_path_partition_keys.groovy
@@ -29,6 +29,7 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
             "uri" = "${baseUri}/dt1=cyw/*",
             "hadoop.username" = "hadoop",
             "format" = "csv",
+            "column_separator" = ",",
             "path_partition_keys"="dt1" ) order by c1,c2 ;
         """ 
 
@@ -37,6 +38,7 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
             "uri" = "${baseUri}/dt1=cyw/*",
             "hadoop.username" = "hadoop",
             "format" = "csv",
+            "column_separator" = ",",
             "path_partition_keys"="dt1") where dt1!="cyw" order by c1,c2 limit 3;
         """ 
 
@@ -45,6 +47,7 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
             "uri" = "${baseUri}/dt1=hello/*",
             "hadoop.username" = "hadoop",
             "format" = "csv",
+            "column_separator" = ",",
             "path_partition_keys"="dt1") group by c1,dt1 order by c1;
         """ 
     
@@ -53,6 +56,7 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
             "uri" = "${baseUri}/dt2=two/dt1=hello/*",
             "hadoop.username" = "hadoop",
             "format" = "csv",
+            "column_separator" = ",",
             "path_partition_keys"="dt1") order by c1;
         """ 
 
@@ -61,6 +65,7 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
             "uri" = "${baseUri}/dt2=two/dt1=cyw/*",
             "hadoop.username" = "hadoop",
             "format" = "csv",
+            "column_separator" = ",",
             "path_partition_keys"="dt2,dt1");
         """
 
@@ -83,6 +88,7 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
         "file_path" = "${outFilePath}/dt1=cyw/a.csv",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "path_partition_keys"="dt1") order by c1,c2;
     """
     
@@ -91,6 +97,7 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
         "file_path" = "${outFilePath}/dt1=cyw/*",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "path_partition_keys"="dt1") order by c1,c2  limit 2;
     """
     
@@ -99,6 +106,7 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
         "file_path" = "${outFilePath}/dt1=hello/c.csv",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "path_partition_keys"="dt1") order by c1,c2  limit 7;
     """
 
@@ -107,6 +115,7 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
         "file_path" = "${outFilePath}/dt2=two/dt1=hello/c.csv",
         "backend_id" = "${be_id}",
         "format" = "csv",
+        "column_separator" = ",",
         "path_partition_keys"="dt2,dt1") order by c1,c2  limit 9;
     """
     
@@ -114,7 +123,6 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
     String ak = getS3AK()
     String sk = getS3SK()
     String s3_endpoint = getS3Endpoint()
-    String region = getS3Region()
     String bucket = context.config.otherConfigs.get("s3BucketName");
     
     sql """ set query_timeout=3600; """ 
@@ -125,8 +133,8 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
         "URI" = "https://${bucket}.${s3_endpoint}/regression/tvf/test_path_partition_keys/dt1=cyw/b.csv",    
         "s3.access_key" = "${ak}",     
         "s3.secret_key" = "${sk}",     
-        "REGION" = "${region}",    
         "FORMAT" = "csv",
+        "column_separator" = ",",
         "use_path_style" = "true",
         "path_partition_keys"="dt1") 
     """
@@ -139,8 +147,8 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
         "URI" = "https://${bucket}.${s3_endpoint}/regression/tvf/test_path_partition_keys/dt1=hello/c.csv",    
         "s3.access_key" = "${ak}",     
         "s3.secret_key" = "${sk}",     
-        "REGION" = "${region}",    
         "FORMAT" = "csv",
+        "column_separator" = ",",
         "use_path_style" = "true",
         "path_partition_keys"="dt1") limit 3;
     """
@@ -152,8 +160,8 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
         "URI" = "https://${bucket}.${s3_endpoint}/regression/tvf/test_path_partition_keys/dt2=two/dt1=hello/c.csv",    
         "s3.access_key" = "${ak}",     
         "s3.secret_key" = "${sk}",     
-        "REGION" = "${region}",    
         "FORMAT" = "csv",
+        "column_separator" = ",",
         "use_path_style" = "true",
         "path_partition_keys"="dt1") limit 3;
     """
@@ -165,9 +173,9 @@ suite("test_path_partition_keys", "p2,external,tvf,external_remote,external_remo
         "URI" = "https://${bucket}.${s3_endpoint}/regression/tvf/test_path_partition_keys/dt2=two/dt1=cyw/b.csv",    
         "s3.access_key" = "${ak}",     
         "s3.secret_key" = "${sk}",     
-        "REGION" = "${region}",    
         "FORMAT" = "csv",
         "use_path_style" = "true",
+        "column_separator" = ",",
         "path_partition_keys"="dt2,dt1") limit 3;
     """
 }


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org