Hi, I have a STRING column product_str with json b...
# generala
Arpit
10/28/2021, 2:42 PMHi, 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 PMIts stuck
m
Mayank
10/29/2021, 2:28 AM
Your quotes seem incorrect?
a
Arpit
10/29/2021, 3:15 PMI 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?
Arpit
10/29/2021, 3:30 PMRunning 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?
Richard Startin
10/29/2021, 6:46 PMfrom your ingestion logs, but also from the server logs for the query