Hi team, I tried to create a text index in the sam...
# troubleshooting
t
Hi team, I tried to create a text index in the sample table dimBaseballTeams on teamName column, but when I use text match query, I got
Copy code
{
  "message": "QueryExecutionError:\njava.lang.NullPointerException\n\tat org.apache.pinot.core.operator.filter.TextMatchFilterOperator.getNextBlock(TextMatchFilterOperator.java:45)\n\tat org.apache.pinot.core.operator.filter.TextMatchFilterOperator.getNextBlock(TextMatchFilterOperator.java:30)\n\tat org.apache.pinot.core.operator.BaseOperator.nextBlock(BaseOperator.java:49)\n\tat org.apache.pinot.core.operator.DocIdSetOperator.getNextBlock(DocIdSetOperator.java:62)",
  "errorCode": 200
}
Here is my table config
Copy code
{
  "tableName": "dimBaseballTeams",
  "tableType": "OFFLINE",
  "isDimTable": true,
  "segmentsConfig": {
    "segmentPushType": "REFRESH",
    "replication": "1"
  },
  "tableIndexConfig": {
    "noDictionaryColumns": [
      "teamName"
    ]
  },
  "fieldConfigList": [
    {
      "name": "teamName",
      "encodingType": "RAW",
      "indexType": "TEXT"
    }
  ],
  "tenants": {},
  "metadata": {
    "customConfigs": {}
  }
}
m
What's the query? cc: @Sidd
t
select * from dimBaseballTeams where text_match(teamName, 'Florida')
@Mayank @Sidd
s
@Tao Hu I can help take a look in a bit. Most likely index didn't get created. That's why NPE
I can jump on a call after 4:30 to look at the segment and see what's going on
t
sounds good, thank you! @Sidd
has been resolved by @Sidd, thank you so much
m
@Tao Hu @Sidd just to close the loop here, what was the issue? Is there something we can add in the docs?
t
It was because I didn’t call the api to update table config. It might be useful to add this step in the doc because the current version gives people a sense that they can just edit the config file directly .
m
Thanks, will update.