gortiz opened a new issue, #9172:
URL: https://github.com/apache/pinot/issues/9172
I have a table `hits` with a column `URL` of type String. It doesn't have a
text index. When executing:
```sql
SELECT COUNT(*) FROM hits WHERE TEXT_MATCH(URL, '/.*google.*/')
```
The query fails with:
```
[
{
"message": "QueryExecutionError:\njava.lang.NullPointerException\n\tat
org.apache.pinot.core.operator.filter.TextMatchFilterOperator.getNumMatchingDocs(TextMatchFilterOperator.java:63)\n\tat
org.apache.pinot.core.operator.query.FastFilteredCountOperator.getNextBlock(FastFilteredCountOperator.java:64)\n\tat
org.apache.pinot.core.operator.query.FastFilteredCountOperator.getNextBlock(FastFilteredCountOperator.java:33)\n\tat
org.apache.pinot.core.operator.BaseOperator.nextBlock(BaseOperator.java:39)",
"errorCode": 200
}
]
```
The explain plan says:
```sql
explain plan for SELECT COUNT(*) FROM hits WHERE TEXT_MATCH(URL,
'/.*google.*/')
```
```json
"rows": [
[
"BROKER_REDUCE(limit:10)",
1,
0
],
[
"COMBINE_AGGREGATE",
2,
1
],
[
"PLAN_START(numSegmentsForThisPlan:100)",
-1,
-1
],
[
"FAST_FILTERED_COUNT",
3,
2
],
[
"FILTER_TEXT_INDEX(indexLookUp:text_index,operator:TEXT_MATCH,predicate:text_match(URL,'/.*google.*/'))",
4,
3
]
]
```
It makes sense that queries that require an index fail if it is not there,
but the error should be more indicative. Something like: "Cannot use TEXT_MATCH
on URL column because it doesn't have a text_index"
--
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]
