[GitHub] [pinot] amrishlal commented on issue #7504: Querying JSON-type columns that are arrays at the top level doesn't work with dot notation.

[GitBox <gi...@apache.org>]

amrishlal commented on issue #7504:
URL: https://github.com/apache/pinot/issues/7504#issuecomment-933112730


   I have created a PR to fix this issue. Please see #7511. Also, it seems like a similar fix is needed in `JsonIndex / JSON_MATCH` as well to allow for running queries such as:
   
   ```
   SELECT *
     FROM testTable
   WHERE JSON_MATCH(jsonColumn, '\"$.[2]\" IS NOT NULL') AND JSON_MATCH(jsonColumn, '\"$.[2]\" = ''test''')
   ```
   
   I am assuming that you can take a look at `JsonIndex / JSON_MATCH` changes?


-- 
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: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org