This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch branch-3.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.1 by this push:
new 977d707d989 branch-3.1: [fix](es) Fix array not supporting json
subtype #55738 (#56535)
977d707d989 is described below
commit 977d707d989ef59c16d43d34127a3e30766367ce
Author: zy-kkk <[email protected]>
AuthorDate: Sun Sep 28 15:06:11 2025 +0800
branch-3.1: [fix](es) Fix array not supporting json subtype #55738 (#56535)
pick #55738
---
be/src/exec/es/es_scroll_parser.cpp | 19 +++
.../scripts/data/composite_type_array_bulk.json | 20 +--
.../index/array_meta_composite_type_array.json | 3 +-
.../scripts/index/es6_composite_type_array.json | 10 +-
.../scripts/index/es7_composite_type_array.json | 10 +-
.../data/external_table_p0/es/test_es_query.out | 150 ++++++++++-----------
6 files changed, 121 insertions(+), 91 deletions(-)
diff --git a/be/src/exec/es/es_scroll_parser.cpp
b/be/src/exec/es/es_scroll_parser.cpp
index 6e72596bd4d..eea51013e7e 100644
--- a/be/src/exec/es/es_scroll_parser.cpp
+++ b/be/src/exec/es/es_scroll_parser.cpp
@@ -529,6 +529,22 @@ Status process_date_column(const rapidjson::Value& col,
PrimitiveType sub_type,
return Status::OK();
}
+Status process_jsonb_column(const rapidjson::Value& col, PrimitiveType
sub_type,
+ bool pure_doc_value, vectorized::Array& array) {
+ if (!col.IsArray()) {
+ JsonBinaryValue jsonb_value(json_value_to_string(col));
+ vectorized::JsonbField json(jsonb_value.value(), jsonb_value.size());
+ array.push_back(vectorized::Field(json));
+ } else {
+ for (const auto& sub_col : col.GetArray()) {
+ JsonBinaryValue jsonb_value(json_value_to_string(sub_col));
+ vectorized::JsonbField json(jsonb_value.value(),
jsonb_value.size());
+ array.push_back(vectorized::Field(json));
+ }
+ }
+ return Status::OK();
+}
+
Status ScrollParser::parse_column(const rapidjson::Value& col, PrimitiveType
sub_type,
bool pure_doc_value, vectorized::Array&
array,
const cctz::time_zone& time_zone) {
@@ -564,6 +580,9 @@ Status ScrollParser::parse_column(const rapidjson::Value&
col, PrimitiveType sub
return process_date_column<DateV2Value<DateTimeV2ValueType>, uint64_t>(
col, sub_type, pure_doc_value, array, time_zone);
}
+ case TYPE_JSONB: {
+ return process_jsonb_column(col, sub_type, pure_doc_value, array);
+ }
default:
LOG(ERROR) << "Do not support Array type: " << sub_type;
return Status::InternalError("Unsupported type");
diff --git
a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/composite_type_array_bulk.json
b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/composite_type_array_bulk.json
index 6d84244316a..5bb3bf67f2a 100755
---
a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/composite_type_array_bulk.json
+++
b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/composite_type_array_bulk.json
@@ -1,10 +1,10 @@
-{"name": "Andy", "sports": "soccer", "scores": 100}
-{"name": "Betty", "sports": "pingpong ball", "scores": 90}
-{"name": "Cindy", "sports": "武术", "scores": 89}
-{"name": "David", "sports": ["volleyball"], "scores": [77]}
-{"name": "Emily", "sports": ["baseball", "golf", "hockey"], "scores": [56, 78,
99]}
-{"name": "Frank", "sports": ["rugby", "cricket", "boxing"], "scores": [45, 67,
88]}
-{"name": "Grace", "sports": ["table tennis", "badminton", "athletics"],
"scores": [34, 56, 78]}
-{"name": "Henry", "sports": ["archery", "fencing", "weightlifting"], "scores":
[23, 45, 67]}
-{"name": "Ivy", "sports": ["judo", "karate", "taekwondo"], "scores": [12, 34,
56]}
-{"name": "Jack", "sports": ["wrestling", "gymnastics", "surfing"], "scores":
[1, 23, 45]}
\ No newline at end of file
+{"name": "Andy", "sports": "soccer", "scores": 100, "z_details": [{"position":
"forward", "club": "Manchester", "salary": 50000}]}
+{"name": "Betty", "sports": "pingpong ball", "scores": 90, "z_details":
[{"position": "attacker", "club": "Beijing", "salary": 30000}]}
+{"name": "Cindy", "sports": "武术", "scores": 89, "z_details": [{"position":
"fighter", "club": "Shaolin", "salary": 25000}]}
+{"name": "David", "sports": ["volleyball"], "scores": [77], "z_details":
[{"position": "spiker", "club": "Tokyo", "salary": 40000}]}
+{"name": "Emily", "sports": ["baseball", "golf", "hockey"], "scores": [56, 78,
99], "z_details": [{"position": "pitcher", "club": "Yankees", "salary": 80000},
{"position": "driver", "club": "PGA", "salary": 120000}, {"position": "center",
"club": "Rangers", "salary": 90000}]}
+{"name": "Frank", "sports": ["rugby", "cricket", "boxing"], "scores": [45, 67,
88], "z_details": [{"position": "scrum-half", "club": "Leicester", "salary":
60000}, {"position": "batsman", "club": "Mumbai", "salary": 70000},
{"position": "heavyweight", "club": "Vegas", "salary": 150000}]}
+{"name": "Grace", "sports": ["table tennis", "badminton", "athletics"],
"scores": [34, 56, 78], "z_details": [{"position": "attacker", "club": "China",
"salary": 35000}, {"position": "singles", "club": "Denmark", "salary": 45000},
{"position": "sprinter", "club": "Jamaica", "salary": 85000}]}
+{"name": "Henry", "sports": ["archery", "fencing", "weightlifting"], "scores":
[23, 45, 67], "z_details": [{"position": "recurve", "club": "Korea", "salary":
20000}, {"position": "epee", "club": "France", "salary": 30000}, {"position":
"heavyweight", "club": "Bulgaria", "salary": 55000}]}
+{"name": "Ivy", "sports": ["judo", "karate", "taekwondo"], "scores": [12, 34,
56], "z_details": [{"position": "lightweight", "club": "Japan", "salary":
25000}, {"position": "kata", "club": "Okinawa", "salary": 22000}, {"position":
"middleweight", "club": "Korea", "salary": 28000}]}
+{"name": "Jack", "sports": ["wrestling", "gymnastics", "surfing"], "scores":
[1, 23, 45], "z_details": [{"position": "freestyle", "club": "Russia",
"salary": 15000}, {"position": "rings", "club": "Romania", "salary": 35000},
{"position": "longboard", "club": "Hawaii", "salary": 50000}]}
\ No newline at end of file
diff --git
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/array_meta_composite_type_array.json
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/array_meta_composite_type_array.json
index a9ccc1ab850..6adb86672da 100644
---
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/array_meta_composite_type_array.json
+++
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/array_meta_composite_type_array.json
@@ -3,7 +3,8 @@
"doris":{
"array_fields":[
"sports",
- "scores"
+ "scores",
+ "z_details"
]
}
}
diff --git
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es6_composite_type_array.json
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es6_composite_type_array.json
index 3a38a8f22d3..081be7fc166 100755
---
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es6_composite_type_array.json
+++
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es6_composite_type_array.json
@@ -8,7 +8,15 @@
"properties": {
"name": { "type": "keyword" },
"sports": { "type": "keyword", "doc_values": false},
- "scores": { "type": "integer", "doc_values": false}
+ "scores": { "type": "integer", "doc_values": false},
+ "z_details": {
+ "type": "object",
+ "properties": {
+ "position": { "type": "keyword" },
+ "club": { "type": "keyword" },
+ "salary": { "type": "integer" }
+ }
+ }
}
}
}
diff --git
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es7_composite_type_array.json
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es7_composite_type_array.json
index 3529cc61eb7..6af71903ca7 100644
---
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es7_composite_type_array.json
+++
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es7_composite_type_array.json
@@ -7,7 +7,15 @@
"properties": {
"name": { "type": "keyword" },
"sports": { "type": "keyword", "doc_values": false},
- "scores": { "type": "integer", "doc_values": false}
+ "scores": { "type": "integer", "doc_values": false},
+ "z_details": {
+ "type": "object",
+ "properties": {
+ "position": { "type": "keyword" },
+ "club": { "type": "keyword" },
+ "salary": { "type": "integer" }
+ }
+ }
}
}
}
diff --git a/regression-test/data/external_table_p0/es/test_es_query.out
b/regression-test/data/external_table_p0/es/test_es_query.out
index 61b9fd69845..536d492b64c 100644
--- a/regression-test/data/external_table_p0/es/test_es_query.out
+++ b/regression-test/data/external_table_p0/es/test_es_query.out
@@ -64,9 +64,6 @@ text_ignore_above_10
4444
4444
--- !sql20 --
-["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string1
[1, 2, 3, 4] 2022-08-08 2022-08-08T12:10:10 text#1 ["2020-01-01",
"2020-01-02"] 3.14 [1, 2, 3, 4] [1, 1.1, 1.2, 1.3] [1, 2, 3, 4]
["a", "b", "c"] [{"name":"Andy","age":18},{"name":"Tim","age":28}]
2022-08-08T12:10:10 2022-08-08T12:10:10 2022-08-08T20:10:10 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770]
[{"last":"Smith","fi [...]
-
-- !sql21 --
["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string1
[1, 2, 3, 4] 2022-08-08 2022-08-08T12:10:10 text#1 ["2020-01-01",
"2020-01-02"] 3.14 [1, 2, 3, 4] [1, 1.1, 1.2, 1.3] [1, 2, 3, 4]
["a", "b", "c"] [{"name":"Andy","age":18},{"name":"Tim","age":28}]
2022-08-08T12:10:10 2022-08-08T12:10:10 2022-08-08T20:10:10 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770]
[{"last":"Smith","fi [...]
@@ -221,15 +218,15 @@ text_ignore_above_10
2022-08-08T20:10:10
-- !sql_5_27 --
-Andy [100] ["soccer"]
-Betty [90] ["pingpong ball"]
-Cindy [89] ["武术"]
-David [77] ["volleyball"]
-Emily [56, 78, 99] ["baseball", "golf", "hockey"]
-Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
-Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
-Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
-Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
+Andy [100] ["soccer"]
["{"club":"Manchester","position":"forward","salary":50000}"]
+Betty [90] ["pingpong ball"]
["{"club":"Beijing","position":"attacker","salary":30000}"]
+Cindy [89] ["武术"]
["{"club":"Shaolin","position":"fighter","salary":25000}"]
+David [77] ["volleyball"]
["{"club":"Tokyo","position":"spiker","salary":40000}"]
+Emily [56, 78, 99] ["baseball", "golf", "hockey"]
["{"club":"Yankees","position":"pitcher","salary":80000}",
"{"club":"PGA","position":"driver","salary":120000}",
"{"club":"Rangers","position":"center","salary":90000}"]
+Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
["{"club":"Leicester","position":"scrum-half","salary":60000}",
"{"club":"Mumbai","position":"batsman","salary":70000}",
"{"club":"Vegas","position":"heavyweight","salary":150000}"]
+Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
["{"club":"China","position":"attacker","salary":35000}",
"{"club":"Denmark","position":"singles","salary":45000}",
"{"club":"Jamaica","position":"sprinter","salary":85000}"]
+Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
["{"club":"Korea","position":"recurve","salary":20000}",
"{"club":"France","position":"epee","salary":30000}",
"{"club":"Bulgaria","position":"heavyweight","salary":55000}"]
+Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
["{"club":"Japan","position":"lightweight","salary":25000}",
"{"club":"Okinawa","position":"kata","salary":22000}",
"{"club":"Korea","position":"middleweight","salary":28000}"]
-- !sql_5_28 --
value1 value2
@@ -375,15 +372,15 @@ text_ignore_above_10
2022-08-08T20:10:10
-- !sql_6_27 --
-Andy [100] ["soccer"]
-Betty [90] ["pingpong ball"]
-Cindy [89] ["武术"]
-David [77] ["volleyball"]
-Emily [56, 78, 99] ["baseball", "golf", "hockey"]
-Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
-Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
-Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
-Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
+Andy [100] ["soccer"]
["{"club":"Manchester","position":"forward","salary":50000}"]
+Betty [90] ["pingpong ball"]
["{"club":"Beijing","position":"attacker","salary":30000}"]
+Cindy [89] ["武术"]
["{"club":"Shaolin","position":"fighter","salary":25000}"]
+David [77] ["volleyball"]
["{"club":"Tokyo","position":"spiker","salary":40000}"]
+Emily [56, 78, 99] ["baseball", "golf", "hockey"]
["{"club":"Yankees","position":"pitcher","salary":80000}",
"{"club":"PGA","position":"driver","salary":120000}",
"{"club":"Rangers","position":"center","salary":90000}"]
+Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
["{"club":"Leicester","position":"scrum-half","salary":60000}",
"{"club":"Mumbai","position":"batsman","salary":70000}",
"{"club":"Vegas","position":"heavyweight","salary":150000}"]
+Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
["{"club":"China","position":"attacker","salary":35000}",
"{"club":"Denmark","position":"singles","salary":45000}",
"{"club":"Jamaica","position":"sprinter","salary":85000}"]
+Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
["{"club":"Korea","position":"recurve","salary":20000}",
"{"club":"France","position":"epee","salary":30000}",
"{"club":"Bulgaria","position":"heavyweight","salary":55000}"]
+Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
["{"club":"Japan","position":"lightweight","salary":25000}",
"{"club":"Okinawa","position":"kata","salary":22000}",
"{"club":"Korea","position":"middleweight","salary":28000}"]
-- !sql_6_28 --
value1 value2
@@ -571,15 +568,15 @@ text_ignore_above_10
1660191010000
-- !sql_7_34 --
-Andy [100] ["soccer"]
-Betty [90] ["pingpong ball"]
-Cindy [89] ["武术"]
-David [77] ["volleyball"]
-Emily [56, 78, 99] ["baseball", "golf", "hockey"]
-Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
-Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
-Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
-Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
+Andy [100] ["soccer"]
["{"club":"Manchester","position":"forward","salary":50000}"]
+Betty [90] ["pingpong ball"]
["{"club":"Beijing","position":"attacker","salary":30000}"]
+Cindy [89] ["武术"]
["{"club":"Shaolin","position":"fighter","salary":25000}"]
+David [77] ["volleyball"]
["{"club":"Tokyo","position":"spiker","salary":40000}"]
+Emily [56, 78, 99] ["baseball", "golf", "hockey"]
["{"club":"Yankees","position":"pitcher","salary":80000}",
"{"club":"PGA","position":"driver","salary":120000}",
"{"club":"Rangers","position":"center","salary":90000}"]
+Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
["{"club":"Leicester","position":"scrum-half","salary":60000}",
"{"club":"Mumbai","position":"batsman","salary":70000}",
"{"club":"Vegas","position":"heavyweight","salary":150000}"]
+Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
["{"club":"China","position":"attacker","salary":35000}",
"{"club":"Denmark","position":"singles","salary":45000}",
"{"club":"Jamaica","position":"sprinter","salary":85000}"]
+Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
["{"club":"Korea","position":"recurve","salary":20000}",
"{"club":"France","position":"epee","salary":30000}",
"{"club":"Bulgaria","position":"heavyweight","salary":55000}"]
+Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
["{"club":"Japan","position":"lightweight","salary":25000}",
"{"club":"Okinawa","position":"kata","salary":22000}",
"{"club":"Korea","position":"middleweight","salary":28000}"]
-- !sql_7_35 --
string1 text#1
@@ -775,15 +772,15 @@ text_ignore_above_10
1660191010000
-- !sql_8_32 --
-Andy [100] ["soccer"]
-Betty [90] ["pingpong ball"]
-Cindy [89] ["武术"]
-David [77] ["volleyball"]
-Emily [56, 78, 99] ["baseball", "golf", "hockey"]
-Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
-Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
-Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
-Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
+Andy [100] ["soccer"]
["{"club":"Manchester","position":"forward","salary":50000}"]
+Betty [90] ["pingpong ball"]
["{"club":"Beijing","position":"attacker","salary":30000}"]
+Cindy [89] ["武术"]
["{"club":"Shaolin","position":"fighter","salary":25000}"]
+David [77] ["volleyball"]
["{"club":"Tokyo","position":"spiker","salary":40000}"]
+Emily [56, 78, 99] ["baseball", "golf", "hockey"]
["{"club":"Yankees","position":"pitcher","salary":80000}",
"{"club":"PGA","position":"driver","salary":120000}",
"{"club":"Rangers","position":"center","salary":90000}"]
+Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
["{"club":"Leicester","position":"scrum-half","salary":60000}",
"{"club":"Mumbai","position":"batsman","salary":70000}",
"{"club":"Vegas","position":"heavyweight","salary":150000}"]
+Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
["{"club":"China","position":"attacker","salary":35000}",
"{"club":"Denmark","position":"singles","salary":45000}",
"{"club":"Jamaica","position":"sprinter","salary":85000}"]
+Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
["{"club":"Korea","position":"recurve","salary":20000}",
"{"club":"France","position":"epee","salary":30000}",
"{"club":"Bulgaria","position":"heavyweight","salary":55000}"]
+Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
["{"club":"Japan","position":"lightweight","salary":25000}",
"{"club":"Okinawa","position":"kata","salary":22000}",
"{"club":"Korea","position":"middleweight","salary":28000}"]
-- !sql_8_33 --
string1 text#1
@@ -880,9 +877,6 @@ text_ignore_above_10
4444
4444
--- !sql20 --
-["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string1
[1, 2, 3, 4] 2022-08-08 2022-08-08T12:10:10 text#1 ["2020-01-01",
"2020-01-02"] 3.14 [1, 2, 3, 4] [1, 1.1, 1.2, 1.3] [1, 2, 3, 4]
["a", "b", "c"] [{"name":"Andy","age":18},{"name":"Tim","age":28}]
2022-08-08T12:10:10 2022-08-08T12:10:10 2022-08-08T20:10:10 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770]
[{"last":"Smith","fi [...]
-
-- !sql21 --
["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string1
[1, 2, 3, 4] 2022-08-08 2022-08-08T12:10:10 text#1 ["2020-01-01",
"2020-01-02"] 3.14 [1, 2, 3, 4] [1, 1.1, 1.2, 1.3] [1, 2, 3, 4]
["a", "b", "c"] [{"name":"Andy","age":18},{"name":"Tim","age":28}]
2022-08-08T12:10:10 2022-08-08T12:10:10 2022-08-08T20:10:10 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770]
[{"last":"Smith","fi [...]
@@ -1037,15 +1031,15 @@ text_ignore_above_10
2022-08-08T20:10:10
-- !sql_5_27 --
-Andy [100] ["soccer"]
-Betty [90] ["pingpong ball"]
-Cindy [89] ["武术"]
-David [77] ["volleyball"]
-Emily [56, 78, 99] ["baseball", "golf", "hockey"]
-Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
-Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
-Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
-Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
+Andy [100] ["soccer"]
["{"club":"Manchester","position":"forward","salary":50000}"]
+Betty [90] ["pingpong ball"]
["{"club":"Beijing","position":"attacker","salary":30000}"]
+Cindy [89] ["武术"]
["{"club":"Shaolin","position":"fighter","salary":25000}"]
+David [77] ["volleyball"]
["{"club":"Tokyo","position":"spiker","salary":40000}"]
+Emily [56, 78, 99] ["baseball", "golf", "hockey"]
["{"club":"Yankees","position":"pitcher","salary":80000}",
"{"club":"PGA","position":"driver","salary":120000}",
"{"club":"Rangers","position":"center","salary":90000}"]
+Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
["{"club":"Leicester","position":"scrum-half","salary":60000}",
"{"club":"Mumbai","position":"batsman","salary":70000}",
"{"club":"Vegas","position":"heavyweight","salary":150000}"]
+Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
["{"club":"China","position":"attacker","salary":35000}",
"{"club":"Denmark","position":"singles","salary":45000}",
"{"club":"Jamaica","position":"sprinter","salary":85000}"]
+Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
["{"club":"Korea","position":"recurve","salary":20000}",
"{"club":"France","position":"epee","salary":30000}",
"{"club":"Bulgaria","position":"heavyweight","salary":55000}"]
+Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
["{"club":"Japan","position":"lightweight","salary":25000}",
"{"club":"Okinawa","position":"kata","salary":22000}",
"{"club":"Korea","position":"middleweight","salary":28000}"]
-- !sql_5_28 --
value1 value2
@@ -1191,15 +1185,15 @@ text_ignore_above_10
2022-08-08T20:10:10
-- !sql_6_27 --
-Andy [100] ["soccer"]
-Betty [90] ["pingpong ball"]
-Cindy [89] ["武术"]
-David [77] ["volleyball"]
-Emily [56, 78, 99] ["baseball", "golf", "hockey"]
-Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
-Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
-Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
-Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
+Andy [100] ["soccer"]
["{"club":"Manchester","position":"forward","salary":50000}"]
+Betty [90] ["pingpong ball"]
["{"club":"Beijing","position":"attacker","salary":30000}"]
+Cindy [89] ["武术"]
["{"club":"Shaolin","position":"fighter","salary":25000}"]
+David [77] ["volleyball"]
["{"club":"Tokyo","position":"spiker","salary":40000}"]
+Emily [56, 78, 99] ["baseball", "golf", "hockey"]
["{"club":"Yankees","position":"pitcher","salary":80000}",
"{"club":"PGA","position":"driver","salary":120000}",
"{"club":"Rangers","position":"center","salary":90000}"]
+Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
["{"club":"Leicester","position":"scrum-half","salary":60000}",
"{"club":"Mumbai","position":"batsman","salary":70000}",
"{"club":"Vegas","position":"heavyweight","salary":150000}"]
+Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
["{"club":"China","position":"attacker","salary":35000}",
"{"club":"Denmark","position":"singles","salary":45000}",
"{"club":"Jamaica","position":"sprinter","salary":85000}"]
+Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
["{"club":"Korea","position":"recurve","salary":20000}",
"{"club":"France","position":"epee","salary":30000}",
"{"club":"Bulgaria","position":"heavyweight","salary":55000}"]
+Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
["{"club":"Japan","position":"lightweight","salary":25000}",
"{"club":"Okinawa","position":"kata","salary":22000}",
"{"club":"Korea","position":"middleweight","salary":28000}"]
-- !sql_6_28 --
value1 value2
@@ -1387,15 +1381,15 @@ text_ignore_above_10
1660191010000
-- !sql_7_34 --
-Andy [100] ["soccer"]
-Betty [90] ["pingpong ball"]
-Cindy [89] ["武术"]
-David [77] ["volleyball"]
-Emily [56, 78, 99] ["baseball", "golf", "hockey"]
-Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
-Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
-Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
-Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
+Andy [100] ["soccer"]
["{"club":"Manchester","position":"forward","salary":50000}"]
+Betty [90] ["pingpong ball"]
["{"club":"Beijing","position":"attacker","salary":30000}"]
+Cindy [89] ["武术"]
["{"club":"Shaolin","position":"fighter","salary":25000}"]
+David [77] ["volleyball"]
["{"club":"Tokyo","position":"spiker","salary":40000}"]
+Emily [56, 78, 99] ["baseball", "golf", "hockey"]
["{"club":"Yankees","position":"pitcher","salary":80000}",
"{"club":"PGA","position":"driver","salary":120000}",
"{"club":"Rangers","position":"center","salary":90000}"]
+Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
["{"club":"Leicester","position":"scrum-half","salary":60000}",
"{"club":"Mumbai","position":"batsman","salary":70000}",
"{"club":"Vegas","position":"heavyweight","salary":150000}"]
+Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
["{"club":"China","position":"attacker","salary":35000}",
"{"club":"Denmark","position":"singles","salary":45000}",
"{"club":"Jamaica","position":"sprinter","salary":85000}"]
+Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
["{"club":"Korea","position":"recurve","salary":20000}",
"{"club":"France","position":"epee","salary":30000}",
"{"club":"Bulgaria","position":"heavyweight","salary":55000}"]
+Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
["{"club":"Japan","position":"lightweight","salary":25000}",
"{"club":"Okinawa","position":"kata","salary":22000}",
"{"club":"Korea","position":"middleweight","salary":28000}"]
-- !sql_7_35 --
string1 text#1
@@ -1591,15 +1585,15 @@ text_ignore_above_10
1660191010000
-- !sql_8_32 --
-Andy [100] ["soccer"]
-Betty [90] ["pingpong ball"]
-Cindy [89] ["武术"]
-David [77] ["volleyball"]
-Emily [56, 78, 99] ["baseball", "golf", "hockey"]
-Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
-Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
-Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
-Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
+Andy [100] ["soccer"]
["{"club":"Manchester","position":"forward","salary":50000}"]
+Betty [90] ["pingpong ball"]
["{"club":"Beijing","position":"attacker","salary":30000}"]
+Cindy [89] ["武术"]
["{"club":"Shaolin","position":"fighter","salary":25000}"]
+David [77] ["volleyball"]
["{"club":"Tokyo","position":"spiker","salary":40000}"]
+Emily [56, 78, 99] ["baseball", "golf", "hockey"]
["{"club":"Yankees","position":"pitcher","salary":80000}",
"{"club":"PGA","position":"driver","salary":120000}",
"{"club":"Rangers","position":"center","salary":90000}"]
+Frank [45, 67, 88] ["rugby", "cricket", "boxing"]
["{"club":"Leicester","position":"scrum-half","salary":60000}",
"{"club":"Mumbai","position":"batsman","salary":70000}",
"{"club":"Vegas","position":"heavyweight","salary":150000}"]
+Grace [34, 56, 78] ["table tennis", "badminton", "athletics"]
["{"club":"China","position":"attacker","salary":35000}",
"{"club":"Denmark","position":"singles","salary":45000}",
"{"club":"Jamaica","position":"sprinter","salary":85000}"]
+Henry [23, 45, 67] ["archery", "fencing", "weightlifting"]
["{"club":"Korea","position":"recurve","salary":20000}",
"{"club":"France","position":"epee","salary":30000}",
"{"club":"Bulgaria","position":"heavyweight","salary":55000}"]
+Ivy [12, 34, 56] ["judo", "karate", "taekwondo"]
["{"club":"Japan","position":"lightweight","salary":25000}",
"{"club":"Okinawa","position":"kata","salary":22000}",
"{"club":"Korea","position":"middleweight","salary":28000}"]
-- !sql_8_33 --
string1 text#1
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
