suddendust opened a new issue, #10079:
URL: https://github.com/apache/pinot/issues/10079
Applied JSON index on a tags column with the following config (0.9.0):
```
"jsonIndexColumns": [
"tags"
],
```
Ran the query:
`select span_id from spanEventView where JSON_MATCH(tags,
'"$.http.status"=''200''')`
This throws:
```
[
{
"errorCode": 200,
"message": "QueryExecutionError:\njava.lang.IllegalStateException:
Cannot apply JSON_MATCH on column: tags without json index\n\tat
shaded.com.google.common.base.Preconditions.checkState(Preconditions.java:518)\n\tat
org.apache.pinot.core.plan.FilterPlanNode.constructPhysicalOperator(FilterPlanNode.java:225)\n\tat
org.apache.pinot.core.plan.FilterPlanNode.run(FilterPlanNode.java:87)\n\tat
org.apache.pinot.core.plan.DocIdSetPlanNode.run(DocIdSetPlanNode.java:49)"
}
]
```
There is no JSON index created on this column (even after reloading the
table). This, however, worked after making the datatype as JSON. Looks like a
bug, as the docs say: Note that JSON index can only be applied to STRING/JSON
columns whose values are JSON strings.
--
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]