Description
Build: 7.0.0:1595
Load travel sample
Create index with below
{
|
"type": "fulltext-index",
|
"name": "first_index",
|
"uuid": "66063f24ff76306e",
|
"sourceType": "gocbcore",
|
"sourceName": "travel-sample",
|
"sourceUUID": "a13a3f621df4b22a387b1ae34fa44726",
|
"planParams": {
|
"maxPartitionsPerPIndex": 171,
|
"indexPartitions": 6
|
},
|
"params": {
|
"doc_config": {
|
"docid_prefix_delim": "",
|
"docid_regexp": "",
|
"mode": "type_field",
|
"type_field": "type"
|
},
|
"mapping": {
|
"analysis": {},
|
"default_analyzer": "standard",
|
"default_datetime_parser": "dateTimeOptional",
|
"default_field": "_all",
|
"default_mapping": {
|
"dynamic": false,
|
"enabled": false,
|
"properties": {
|
"country": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"analyzer": "keyword",
|
"index": true,
|
"name": "country",
|
"type": "text"
|
}
|
]
|
}
|
}
|
},
|
"default_type": "_default",
|
"docvalues_dynamic": true,
|
"index_dynamic": true,
|
"store_dynamic": false,
|
"type_field": "_type",
|
"types": {
|
"airline": {
|
"dynamic": false,
|
"enabled": true,
|
"properties": {
|
"country": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"analyzer": "keyword",
|
"docvalues": true,
|
"include_in_all": true,
|
"include_term_vectors": true,
|
"index": true,
|
"name": "country",
|
"type": "text"
|
}
|
]
|
}
|
}
|
},
|
"airport": {
|
"dynamic": false,
|
"enabled": true,
|
"properties": {
|
"airportname": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"analyzer": "keyword",
|
"docvalues": true,
|
"include_in_all": true,
|
"include_term_vectors": true,
|
"index": true,
|
"name": "airportname",
|
"type": "text"
|
}
|
]
|
}
|
}
|
}
|
}
|
},
|
"store": {
|
"indexType": "scorch"
|
}
|
},
|
"sourceParams": {}
|
}
|
Run query:
select meta().id from `travel-sample` USE INDEX (USING FTS) where type="airline" and country="France"
FTS index created is not being considered for the above query.