Description
Build: 7.0.0 build 5302
Create a bucket: default
Load below 2 docs:
emp10000001
|
{
|
"emp_id": "10000001",
|
"name": "AAAAAAAA",
|
"dept": "Engineering",
|
"email": "kory@mcdiabetes.com",
|
"salary": 75891.68,
|
"join_date": "2015-08-13T09:30:00",
|
"languages_known": [
|
"Quechua",
|
"Portuguese",
|
"Africans"
|
],
|
"is_manager": true,
|
"mutated": 0,
|
"type": "emp",
|
"manages": {
|
"team_size": 6,
|
"reports": [
|
"Hedda Wright",
|
"Callia Robinson Sr.",
|
"Trista Baker III",
|
"Joby Allen",
|
"Basha Foster",
|
"Salina Allen"
|
]
|
}
|
}
|
|
|
wiki10000001
|
{
|
"title": "April",
|
"id": "1",
|
"revision": {
|
"comment": "robot Modifying: [[bar:Aprü]]",
|
"timestamp": "2010-05-13T20:42:11Z",
|
"text": {
|
"@xml:space": "preserve",
|
"#text": "'''April''' is the fourth month of the year with 30 days. The name April comes from that Latin word ''aperire'' which means \"to open\". This probably refers to growing plants in spring. April begins on the same day of week as ''[[July]]'' in all years and also ''[[January]]'' in leap years.\n\nApril's flower is the Sweet Pea and its birthstone is the Diamond. The meaning of the Diamond is Innocence.\n\n== April in poetry ==\nPoets use ''April'' to mean the end of winter. For example: ''April showers bring [[May]] flowers.''\n\n== Events in April ==\n* [[April Fools' Day]] occurs on [[April 1]]st.\n* [[Easter]] occurs on a [[week|Sunday]] between [[March 22]]nd and [[April 25]]th.\n* Australia and New Zealand celebrate ANZAC Day on 25th April. [http://www.awm.gov.au/dawn/spirit/meaning.asp ANZAC] means - Australian and New Zealand Army Corps and began in 1915.\n\n{{Months}}\n\n{{Stub}}\n\n[[af:April]]\n[[als:April]]\n[[ang:Ēastermōnaþ]]\n[[ar:أبريل]]\n[[an:Abril]]\n[[arc:ܢܝܣܢ]]\n[[frp:Avril]]\n[[ast:Abril]]\n[[gn:Jasyrundy]]\n[[ay:Yapu apthapi phaxsi]]\n[[az:Aprel]]\n[[bn:এপ্রিল]]\n[[zh-min-nan:4 goe̍h]]\n[[ba:Апрель (Алағарай)]]\n[[be:Красавік]]\n[[be-x-old:Красавік]]\n[[bcl:Abril]]\n[[bar:Aprü]]\n[[bs:April]]\n[[br:Ebrel]]\n[[bg:Април]]\n[[ca:Abril]]\n[[cv:Ака]]\n[[ceb:Abril]]\n[[cs:Duben]]\n[[co:Aprile]]\n[[cy:Ebrill]]\n[[da:April]]\n[[de:April]]\n[[dv:އެޕްރީލް]]\n[[dsb:Jatšownik]]\n[[et:Aprill]]\n[[el:Απρίλιος]]\n[[en:April]]\n[[myv:Чадыков]]\n[[es:Abril]]\n[[eo:Aprilo]]\n[[ext:Abril]]\n[[eu:Apiril]]\n[[ee:Afɔfiɛ]]\n[[fa:آوریل]]\n[[hif:April]]\n[[fo:Apríl]]\n[[fr:Avril]]\n[[fy:April]]\n[[fur:Avrîl]]\n[[ga:An tAibreán]]\n[[gv:Averil]]\n[[gd:An Giblean]]\n[[gl:Abril]]\n[[gan:4月]]\n[[gu:એપ્રિલ]]\n[[xal:Мөрн сар]]\n[[ko:4월]]\n[[haw:‘Apelila]]\n[[hy:Ապրիլ]]\n[[hi:अप्रैल]]\n[[hsb:Apryl]]\n[[hr:Travanj]]\n[[io:Aprilo]]\n[[ig:April]]\n[[ilo:Abril]]\n[[id:April]]\n[[ia:April]]\n[[ie:April]]\n[[iu:ᐊᐃᐳᕆᓪ/aipuril]]\n[[os:Апрель]]\n[[xh:Tshazimpuzi]]\n[[is:Apríl]]\n[[it:Aprile]]\n[[he:אפריל]]\n[[jv:April]]\n[[kl:Apriili]]\n[[kn:ಏಪ್ರಿಲ್]]\n[[ka:აპრილი]]\n[[csb:Łżëkwiôt]]\n[[kk:Сәуір]]\n[[kw:Mis Ebrel]]\n[[ky:Апрель]]\n[[sw:Aprili]]\n[[kv:Кос му тӧлысь]]\n[[ht:Avril]]\n[[ku:Avrêl]]\n[[lad:Avril]]\n[[lo:ເມສາ]]\n[[la:Aprilis]]\n[[lv:Aprīlis]]\n[[lb:Abrëll]]\n[[lt:Balandis]]\n[[lij:Arvî]]\n[[li:April]]\n[[ln:Sánzá ya mínei]]\n[[lmo:April]]\n[[hu:Április]]\n[[mk:Април]]\n[[mg:Aprily]]\n[[ml:ഏപ്രില്]]\n[[mt:April]]\n[[mi:Paenga-whāwhā]]\n[[mr:एप्रिल महिना]]\n[[arz:ابريل]]\n[[ms:April]]\n[[mdf:Апрельков]]\n[[my:ဧပြီ]]\n[[nah:Tlanāuhti]]\n[[nl:April]]\n[[nds-nl:April]]\n[[ja:4月]]\n[[nap:Abbrile]]\n[[pih:Ieprel]]\n[[no:April]]\n[[nn:April]]\n[[nrm:Avri]]\n[[nov:Aprile]]\n[[oc:Abril]]\n[[mhr:Вӱдшор]]\n[[uz:Aprel]]\n[[pa:ਅਪ੍ਰੈਲ]]\n[[pnb:اپریل]]\n[[km:ខែមេសា]]\n[[tpi:Epril]]\n[[nds:April]]\n[[pl:Kwiecień]]\n[[pnt:Απρίλτς]]\n[[pt:Abril]]\n[[crh:Aprel]]\n[[ksh:Apprill (Moohnd)]]\n[[ro:Aprilie]]\n[[qu:Ayriway killa]]\n[[ru:Апрель]]\n[[sah:Муус устар]]\n[[se:Cuoŋománnu]]\n[[sc:Abrile]]\n[[sco:Aprile]]\n[[sq:Prilli]]\n[[scn:Aprili]]\n[[ss:Mábasa]]\n[[sk:Apríl]]\n[[sl:April]]\n[[szl:Kwjećyń]]\n[[so:Abriil]]\n[[ckb:نیسان]]\n[[sr:Април]]\n[[sh:April]]\n[[su:April]]\n[[fi:Huhtikuu]]\n[[sv:April]]\n[[tl:Abril]]\n[[ta:ஏப்ரல்]]\n[[kab:Yebrir]]\n[[roa-tara:Abbrile]]\n[[tt:Äpril]]\n[[te:ఏప్రిల్]]\n[[th:เมษายน]]\n[[tg:Апрел]]\n[[tr:Nisan]]\n[[tk:Aprel]]\n[[udm:Апрель]]\n[[uk:Квітень]]\n[[ur:اپريل]]\n[[vec:Avril]]\n[[vi:Tháng tư]]\n[[vo:Prilul]]\n[[fiu-vro:Mahlakuu]]\n[[wa:Avri]]\n[[vls:April]]\n[[war:Abril]]\n[[wo:Awril]]\n[[ts:Dzivamusoko]]\n[[yi:אפריל]]\n[[yo:April]]\n[[zh-yue:4月]]\n[[diq:Nisane]]\n[[bat-smg:Balondis]]\n[[zh:4月]]"
|
},
|
"contributor": {
|
"username": "Xqbot",
|
"id": "40158"
|
},
|
"id": "2196110",
|
"minor": null
|
},
|
"mutated": 0,
|
"type": "wiki"
|
}
|
Create FTS index with below- emp type mapped index
{
|
"type": "fulltext-index",
|
"name": "custom_index",
|
"uuid": "568ed4f8e82dc8b4",
|
"sourceType": "gocbcore",
|
"sourceName": "default",
|
"sourceUUID": "a206d895c8363568a50fc7db7ff891b0",
|
"planParams": {
|
"maxPartitionsPerPIndex": 512,
|
"indexPartitions": 2
|
},
|
"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": true,
|
"enabled": false
|
},
|
"default_type": "_default",
|
"docvalues_dynamic": true,
|
"index_dynamic": true,
|
"store_dynamic": false,
|
"type_field": "type",
|
"types": {
|
"emp": {
|
"dynamic": false,
|
"enabled": true,
|
"properties": {
|
"is_manager": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"include_in_all": true,
|
"include_term_vectors": true,
|
"index": true,
|
"name": "is_manager",
|
"type": "boolean"
|
}
|
]
|
},
|
"join_date": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"include_in_all": true,
|
"include_term_vectors": true,
|
"index": true,
|
"name": "join_date",
|
"type": "datetime"
|
}
|
]
|
},
|
"manages": {
|
"dynamic": false,
|
"enabled": true,
|
"properties": {
|
"team_size": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"include_in_all": true,
|
"include_term_vectors": true,
|
"index": true,
|
"name": "team_size",
|
"type": "number"
|
}
|
]
|
}
|
}
|
},
|
"mutated": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"include_in_all": true,
|
"include_term_vectors": true,
|
"index": true,
|
"name": "mutated",
|
"type": "number"
|
}
|
]
|
},
|
"name": {
|
"dynamic": false,
|
"enabled": true,
|
"fields": [
|
{
|
"analyzer": "keyword",
|
"include_in_all": true,
|
"include_term_vectors": true,
|
"index": true,
|
"name": "name",
|
"type": "text"
|
}
|
]
|
}
|
}
|
}
|
}
|
},
|
"store": {
|
"indexType": "scorch",
|
"mossStoreOptions": {},
|
"segmentVersion": 15
|
}
|
},
|
"sourceParams": {}
|
}
|
Running below query returns both the docs where expectation is only emp10000001
curl -XPOST -H "Content-Type: application/json" \
|
-u <username>:<password> http://172.23.97.212:8094/api/index/custom_index/query \
|
-d '{
|
"explain": true,
|
"fields": [
|
"*"
|
],
|
"highlight": {},
|
"query": {
|
"query": "-name:\"Kory Palmer\""
|
}
|
}'
|
Attachments
Issue Links
- duplicates
-
MB-47472 [FTS]NEG N1QL search query to fetch non-indexed field with custom map index returns 0 results
-
- Closed
-
- is duplicated by
-
-
- Closed
-
- relates to
-
-
- Closed
-