saurabhd336 opened a new pull request, #12532:
URL: https://github.com/apache/pinot/pull/12532
inspired by JSONEXTRACTINDEX, allows extracting contexual json array
elements matching a given json match predicate, using the json index
eg:
For a dataset like
```
{"jsonDoc": [{"name__s": "key00", "value": 1}, {"name__s": "key01", "value":
2}, {"name__s": "key02", "value": 3}, {"name__s": "key03", "value": 4}]}
{"jsonDoc": [{"name__s": "key10", "value": 5}, {"name__s": "key11", "value":
6}, {"name__s": "key12", "value": 7}, {"name__s": "key13", "value": 8}]}
{"jsonDoc": [{"name__s": "key20", "value": 9}, {"name__s": "key21", "value":
10}, {"name__s": "key22", "value": 11}, {"name__s": "key23", "value": 12}]}
{"jsonDoc": [{"name__s": "key30", "value": 13}, {"name__s": "key31",
"value": 14}, {"name__s": "key32", "value": 15}, {"name__s": "key33", "value":
16}]}
{"jsonDoc": [{"name__s": "key40", "value": 17}, {"name__s": "key41",
"value": 18}, {"name__s": "key42", "value": 19}, {"name__s": "key43", "value":
20}]}
```
```
select $docId, jsonextractarrayindex(jsonDoc, '$..value', 'INT_ARRAY', 0,
'REGEXP_LIKE("$..name__s", ''key.2'')') from jsonArrayExtractTest limit 10
```
returns
```
[{"name__s":"key00","value":1},{"name__s":"key01","value":2},{"name__s":"key02","value":3},{"name__s":"key03","value":4}]
1
[{"name__s":"key10","value":5},{"name__s":"key11","value":6},{"name__s":"key12","value":7},{"name__s":"key13","value":8}]
5
[{"name__s":"key20","value":9},{"name__s":"key21","value":10},{"name__s":"key22","value":11},{"name__s":"key23","value":12}]
9
[{"name__s":"key30","value":13},{"name__s":"key31","value":14},{"name__s":"key32","value":15},{"name__s":"key33","value":16}]
13
[{"name__s":"key40","value":17},{"name__s":"key41","value":18},{"name__s":"key42","value":19},{"name__s":"key43","value":20}]
17
[{"name__s":"key00","value":1},{"name__s":"key01","value":2},{"name__s":"key02","value":3},{"name__s":"key03","value":4}]
1
[{"name__s":"key10","value":5},{"name__s":"key11","value":6},{"name__s":"key12","value":7},{"name__s":"key13","value":8}]
5
[{"name__s":"key20","value":9},{"name__s":"key21","value":10},{"name__s":"key22","value":11},{"name__s":"key23","value":12}]
9
[{"name__s":"key30","value":13},{"name__s":"key31","value":14},{"name__s":"key32","value":15},{"name__s":"key33","value":16}]
13
[{"name__s":"key40","value":17},{"name__s":"key41","value":18},{"name__s":"key42","value":19},{"name__s":"key43","value":20}]
17
```
i.e. extracts the corresponding array element(s) where a certain json
condition is met. Also adds a way to solve REGEXP_LIKE on JSON_MATCH
WIP
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
