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 <morning...@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-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org