INNOCENT-BOY opened a new issue, #12064:
URL: https://github.com/apache/pinot/issues/12064
> Json Index have a limitation:
> The key (left-hand side) of the filter expression must be the leaf level
of the JSON object, for example, "$.addresses[*]"='main st' won't work.
In some scenarios, we need to justify some non-leaf path is not null. Like
below example:
We have one json column named: person
{
"name": "adam",
"age": 20,
"addresses": [
{
"country": "us",
"street": "main st",
"number": 1
},
{
"country": "ca",
"street": "second st",
"number": 2
}
],
"skills": [
"english",
"programming"
]
}
We want to execute JSON_MATCH(person, '"$.addresses" IS NOT NULL') to
conduct data exploration.
Meanwhile we found there is an function named JSON_EXISTS_PATH in Doris:
https://doris.apache.org/docs/sql-manual/sql-functions/json-functions/json-exists-path
which satisfied our demand. We would like to know if the community have plan
to do this.
cc @Jackie-Jiang
--
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]
