You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2022/08/05 07:59:50 UTC
[GitHub] [pinot] gortiz opened a new issue, #9172: Using text_match on string columns without text index throw null pointer exception
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: commits-unsubscribe@pinot.apache.org.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
[GitHub] [pinot] Jackie-Jiang closed issue #9172: Using text_match on string columns without text index throw null pointer exception
Posted by GitBox <gi...@apache.org>.
Jackie-Jiang closed issue #9172: Using text_match on string columns without text index throw null pointer exception
URL: https://github.com/apache/pinot/issues/9172
--
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