[GitHub] [pinot] gortiz opened a new issue, #9172: Using text_match on string columns without text index throw null pointer exception

[GitBox]

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-unsubscr...@pinot.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org