https://pinot.apache.org/ logo
#general
Title
# general
a

Arpit

10/28/2021, 2:42 PM
Hi, I have a STRING column product_str with json blob stored. I have created an index on the column as mentioned in the doc. Sample data from column looks like this: {"fieldA":{"key1":"val1"},"fieldB":"something"} My query is Select ••• from mytable where json_match(product_str, '"$.fieldB"=''somevalue''') I am not getting any result back with above query. Any ideas ?
m

Mayank

10/28/2021, 5:34 PM
Are you getting zero records back? Or the query gets stuck?
a

Arpit

10/28/2021, 6:02 PM
Its stuck
m

Mayank

10/29/2021, 2:28 AM
Your quotes seem incorrect?
a

Arpit

10/29/2021, 3:15 PM
I started with a new cluster and created the table again with JSON index on one of the string JSON column and strangely the ingestion is showing error (JSON Parse exception: unexpected end-of-input within/between objects entries) and the number of rows is stuck around 7k. Without index, ingestion is working fine. What could be the cause?
Running a simple query return IndexoutofBoundsexception
m

Mayank

10/29/2021, 6:26 PM
@User ^^
r

Richard Startin

10/29/2021, 6:45 PM
@User could you share the full stack trace please?
from your ingestion logs, but also from the server logs for the query