Hello, I was wondering if it was planned to add the

LIKE

operator to

JSON_MATCH

? I’m currently using

REGEXP_LIKE(JSONEXTRACTSCALAR("labels", '$.demande_intention', 'STRING'), 'terminal')

but it’s very slow (even with small number of scanned documents (21). And maybe having it directly with

JSON_MATCH

could speed-up this operation?

JSON_MATCH("labels", 'demande_intention LIKE ''terminal''')

Thank you

Can you open an issue about it and tag me, please?

done https://github.com/apache/pinot/issues/7842

on this in particular, there are a lot of performance problems in the JsonPath library, but I've fixed a lot of them. For instance, since you mentioned that your labels are sparse, JsonPath throws an exception when it can't produce a value. Unfortunately the changes haven't been released yet.

Yeah, I am only looking at supporting LIKE within JSON_MATCH

For exceptions, I’ve seen this, I use a

JSON_MATCH(labels, 'demande_intention IS NOT NULL')

before trying to extract

well, the exception is still thrown but caught

Do you have any idea when you will be able to implement the LIKE and release it?

I can't promise a timeline, but should be a part of the next Pinot release for sure

And you think using the LIKE with JSON_MATCH will be more performant than using JSONEXTRACTSCALAR ?