Hi. we want to replace

regexp_like

with

TEXT_MATCH

operator. column in schema:

{
      "name": "backend_name",
      "dataType": "STRING",
      "defaultNullValue": ""
    },

we have added below fields: Table configs:

"tableIndexConfig": {
      "noDictionaryColumns": [
        "backend_name"
      ],

"fieldConfigList": [
      {
        "name": "backend_name",
        "encodingType": "RAW",
        "indexType": "TEXT",
        "indexTypes": [
          "TEXT"
        ]
      }
    ],

after clicking on reload all segments from UI, we are unable to see any effect. cannot run TEXT_MATCH queries. Tried reloading from swagger API too. version: 0.9.1

@Atri Sharma ^^

Error we are getting:

[
  {
    "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.filter.AndFilterOperator.getNextBlock(AndFilterOperator.java:41)",
    "errorCode": 200
  }
]

Yeah, this means the text index isn't getting created.

Error is fixed now. Issue was similar to https://apache-pinot.slack.com/archives/CDRCA57FC/p1615997908031500. After few hours, we could see the results.