只能在keyword和text字段上使用通配符查询 - 如何解决此Elasticsearch异常

{
  "error": {
    "root_cause": [
      {
        "type": "illegal_argument_exception",
        "reason": "Can only use wildcard queries on keyword and text fields - not on [price] which is of type [long]"
      }
    ],
    "type": "search_phase_execution_exception",
    "reason": "all shards failed",
    "failed_shards": [...]
  },
  "status": 400
}

illegal_argument_exception: Can only use wildcard queries on keyword and text fields - not on [age] which is of type [integer]
    at org.elasticsearch.index.query.WildcardQueryBuilder.doToQuery(WildcardQueryBuilder.java:...)
    at org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:...)

# 查看指定索引的 mapping
GET /your_index/_mapping

# 查看特定字段的 mapping
GET /your_index/_mapping/field/your_field_name

# 查看所有相关索引的 mapping
GET /index1,index2,index3/_mapping/field/your_field_name

# 查看索引的动态 mapping 配置
GET /your_index/_settings | grep dynamic

// 错误用法：对数值字段使用 wildcard
{ "wildcard": { "price": { "value": "*100*" } } }

// 正确用法：使用 range 查询
{ "range": { "price": { "gte": 100, "lte": 199 } } }

// 对日期字段使用 range 查询
{ "range": { "created_at": { "gte": "2024-01-01", "lte": "2024-12-31" } } }

// 新增 keyword 多字段（适用于已有索引，需结合 reindex）
PUT /your_index/_mapping
{
  "properties": {
    "email": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword"
        }
      }
    }
  }
}

{
  "wildcard": {
    "email.keyword": {
      "value": "*@example.com"
    }
  }
}

# 1. 创建新索引并显式定义 mapping
PUT /your_index_v2
{
  "mappings": {
    "properties": {
      "email": {
        "type": "keyword"
      },
      "price": {
        "type": "long"
      }
    }
  }
}

# 2. 使用 reindex 迁移数据
POST /_reindex
{
  "source": { "index": "your_index" },
  "dest": { "index": "your_index_v2" }
}

# 3. 创建别名指向新索引
POST /_aliases
{
  "actions": [
    { "remove": { "index": "your_index", "alias": "your_alias" } },
    { "add":    { "index": "your_index_v2", "alias": "your_alias" } }
  ]
}

{
  "runtime": {
    "email_as_keyword": {
      "type": "keyword",
      "script": {
        "source": "emit(doc['email'].value)"
      }
    }
  },
  "query": {
    "wildcard": {
      "email_as_keyword": {
        "value": "*@example.com"
      }
    }
  }
}

@Override
public Query wildcardQuery(String value, MultiTermQuery.RewriteMethod method, QueryShardContext context) {
    throw new QueryShardException(context,
        "Can only use wildcard queries on keyword and text fields - not on [" + name
        + "] which is of type [" + typeName() + "]");
}