Unreasonable search returns

I'm getting different results for specific search terms where if I search over a large number of fields it returns the correct number of items, but if I search over a smaller number of fields it returns a different number of items. How can I assure that every matching item in the index is returned?

Welcome to our community! :smiley:

It'd be useful if you showed your mapping, your query and the response Elasticsearch is returning please.

Search is Lucene:name:noah or description:noah or tags:noah
There are in fact 12 of these in the data
What I get back from elastic is the following UUID's:
['CVZIWK222MCFCSZJG7FAANTW4IJQ']
['CGQHPM4F25XPBHSY4DS6G2TGCY2J']
['CCE7GOKRSDQRCAZQZF5NYAYXTEDZ']
['CNRBLLJB7MPHEVFXZSHOW5HLHVCB']
['CYYBZBZGCBHOKHSODCIO3AK3E436']
['C3B2444JFBI5LGD242MYM3ELUEKI']
['CB33CUM5AG3U2YPHKIUK2OSQXACW']
['CB4BOSUD7P6TX6RAKJ25KXP2XF5A']
['CE2YCZCDSZJNBRW5LS2BAQXK4KOQ']
['CFWJT2YCMKEJYPKOTC54S2IQPB66']
['C7JMANU76J4LE4JH44OIJOUJJ7ZA']
['CVGWHXK4RBXXHNMJVOBTTYP6AD5C']
['CVA7GT2PTTZS2BBEYBWPTBPJWNJJ']
['CRARIONKRM2M7KGCY5E7DTT43U53']
['C35O4RVJH56D7WNBALYEIBC5QYUX']
['COMGWAAYGH5DI2SUPWD2H7I2BU4X']
['CMIMQFPFDTXB25WGBQOABNJDAMAK']
['COOKY6VGYRVJJQT5AOESJNXDFE2K']
['C4YVD37HCN5H3FBF3HIRECXQTKIZ']
['CTTGGBYP64JBCANSCWRGOO2MB32B']
['CLSEMJHVG5AY2VNZF3V2W3CUJ2I4']
['COUMTPLWHTVC3K5IKKYJMBBTUPKK']
['CFGE3FIRQ3E4BUM72SNKU3ECLNGL']
['C6U6LAGIACTXJ5XUSUPTQ3REJ6EI']
['CAPTQKRJQBSIXLCXK3BIA44STOM2']
['CSWTVTWK76I6CW3DT7HTWLCCCK4C']
['CNBFXJVWM4H2IT3A6662YNKF5O7J']
['CWJQEJGL3CXXGG6VT3TPQ74CNRKH']
['CKSJFS672XCA7OJV4J54HZP2AAY5']
['CL5LB62LLJHEWKBZ2BEGCMAYCGJN']
['CU664LWG544WG43G2PVFP2UA5F22']
['CFDYJBM55DTID6HG3T7DUOZCRR63']
['CEXQAGYGS7RTZZ7NZSSMNP5EBOTG']
['CULN2BTGCFOM7OXYDVDYK3QIOQ47']
['CTYSLDEGTZENV6TFQBZOSNUHO6RS']
['CBILPTKJ2GEM5SMHQGYDISOPIVJQ']
['CAZOZW2S66JWZYDPSV3TNKGRVKS2']
['CVKEIHBYRXBCQOZK4UGE7I6CMCPI']
['CMMRKTDV5PHMJNJTRMOZMPPOSKQO']
['CALUSKGT7GM3D4NMQLBSZ2MJ6NTB']
['CZEQJDZTHLPXNRBNLWY4G3LTISBE']
['C35O4RVJH56D7WNBALYEIBC5QYUX']
['COMGWAAYGH5DI2SUPWD2H7I2BU4X']
['CMIMQFPFDTXB25WGBQOABNJDAMAK']
['COOKY6VGYRVJJQT5AOESJNXDFE2K']
['C4YVD37HCN5H3FBF3HIRECXQTKIZ']
['CTTGGBYP64JBCANSCWRGOO2MB32B']
['CLSEMJHVG5AY2VNZF3V2W3CUJ2I4']
['COUMTPLWHTVC3K5IKKYJMBBTUPKK']
['CFGE3FIRQ3E4BUM72SNKU3ECLNGL']
['C6U6LAGIACTXJ5XUSUPTQ3REJ6EI']
['CAPTQKRJQBSIXLCXK3BIA44STOM2']
['CSWTVTWK76I6CW3DT7HTWLCCCK4C']
['CNBFXJVWM4H2IT3A6662YNKF5O7J']
['CWJQEJGL3CXXGG6VT3TPQ74CNRKH']
['CKSJFS672XCA7OJV4J54HZP2AAY5']
['CL5LB62LLJHEWKBZ2BEGCMAYCGJN']
['CU664LWG544WG43G2PVFP2UA5F22']
['CFDYJBM55DTID6HG3T7DUOZCRR63']
['CEXQAGYGS7RTZZ7NZSSMNP5EBOTG']
['CULN2BTGCFOM7OXYDVDYK3QIOQ47']
['CTYSLDEGTZENV6TFQBZOSNUHO6RS']
['CBILPTKJ2GEM5SMHQGYDISOPIVJQ']
['CAZOZW2S66JWZYDPSV3TNKGRVKS2']
['CVKEIHBYRXBCQOZK4UGE7I6CMCPI']
['CMMRKTDV5PHMJNJTRMOZMPPOSKQO']
['CALUSKGT7GM3D4NMQLBSZ2MJ6NTB']
['CZEQJDZTHLPXNRBNLWY4G3LTISBE']
['CDF4DYMBQWL3JSU7VR7TOZQCWI7S']
['CVVRDLHDIAISEDH7UFTMS542ABQ4']
['CY72VUZURV3GX2PVJK7ZTFHH4RR2']
['CPNJ4QJXAM6XXNZCRLHK4XQG4OB5']
['CREVZHNGPREHAYQWJURUJNQ3SCTK']
['CRW2JVGHZFDBISLASO542AWCK4TA']
['C26ZMNVXTBHAGZIAPG7PIPK5OUMS']
['CB2KJ6XM7QPDYQTC2K4H7EZDLI63']
['CRSDI6MTQZH6T6JALYHGYQPGGHV3']
['C5WJ6DQSLXEC7TZIP67EVTUQVWSG']
['CBFKT637TYKHVS2KA75CAPDXYUUO']
['CYB3VEA7RV36G7LVADAZNKNXBCKX']
['CYK4BNCZJKXC3VKRDNXDYUAANLML']
['C6WT4Z74Q6SGNNYRIA7B4EHM423H']
['CB3DU5LQFMCB2T2AEBRJIYJA23VR']
['CBCQUNAJIYUR2DWDA6NJ6PAHV2FB']
['CNC5DSHU3ZRC7E2YIA7ZZAAXYBUN']
['CGXB6U6BCQM6BJXC5XX2WILRGIKH']
['CMBJFCU5I262LZ2KBYBLJHUDUNLD']
['CO6QR3HQ22XVNBOHRT5QF55QTWOJ']
['CUU6AL32QRTJDDBMUJE2FN7PJVZX']
['CMQAUUEFGM2CQ34XOIAOXZWDADCD']
['CCBJB6O2PAWJK5PICYG2QXZMVWGL']
['CXFGIVAWKSJ4JWIDKW7FE4CDSTVP']
['CUETP77RLF62PUTAAW2ABP7A2O4D']
['CTBW7HA6XKKMSM64HKF6Q4JQ3EKN']
['C5RL2MZXXZWLJ65WIQTTD32VFMIV']
['CVUGDTPFFFIJIF7LZEYUG73ERMAE']
['C25C3PF7GDJDIJLR4ZDFR3VMSBXQ']
['CTITUMELDEW453O5GJC75ZBLBFUF']
['CG2VTGVIGSWW4MF5P4ZSMKKD4GHL']
['CPIIT6MAJPFGGYO4IAUSAFMGJXTW']
['CLJ5FQXN7BLQPYHMV5WTFMQPXEBP']
['CDBUYMAYPQ6YQ2HE2C4JSYVZ67DD']
['CZJJPTQLNYNBFTQF736X7CFKFM3M']
['CXJL7UICEFKLJWVZ5WXMJJG4FWHS']
['CYW22UKBFHPZ44HEZILSXMJ2NSKM']
['CKNOMZKJ5QTXJPP4GOWYBROVP7ZI']
['CEVIGR746CMJYCVN2LLWYKY4R3MU']
['CXER3BBK5AIXZJEYJDH22ISLHOVT']
['CZA6CKY2XBYXLLFINYNXH352TEDA']
['C5EQHC4IZXA3MJ52B6R3MVSOS2YS']
['CTYFKCQ2PMRLKZHRTCLNVEECGK4Y']
['CX7ZFWG3CFYSFQCTKKBUHCWQ25P2']
['CYQKTUG6JBX7QG7EHMHHYAFQVE2N']
['C34Z7QTV6W4KMK3SGFTMMM3P6SBV']
['CI6FDEWWDKZ7JICUEJXTUGQURUCV']
['CSAINGNCY7RVQTLGBQMV6DRPJDII']
['CTIT4VMO3L7L5KNZ55GNCYTHGTWN']
['CSCTXWDAY3R4GSJCTG7LZ3VA6F57']
['CVJSS3MP64S5NEAKZJHWP5NRP5QP']
['CACWSRN4OWJ5JIO3XSMAGXJALT7V']
['CDS7NARWBIDSFIWWHIXT43EOMFCJ']
['C4E6JA6PBYRJNLAQ23O3HFDBXZCV']
['CM76G6YI3UT6G4ZLDONURQGPFEO2']
['CJZIQN5P5YATLNKXGPWM2TDICZDD']
['CBVWLS2K57EFFL4VVVXS46ONRKQE']
['CE3KOPOE3JZXXVIQP37JTXMHGFOR']
['CJ2KLKQLRXPLDRVWFCVOLREL4SI6']
['CQT2BOD5CN2LZGDEDYL7XDRHQVQ6']
['CNRHVEYHAPDC5WQ4UNLCBVNG4XYZ']
['CUUDEYXFSSWIRAQ2JRWVHUR7WYRI']
['CGXU3XJCKC5EAMBT6OZFCJQGHAUE']
['CLV567MKD4RECR6ENOQIJKIOIBRM']
['CK24KFX5HTIKABLCEHZO6XKUSN3A']
['CO7ZMFEZHD4XWPQ2DED7OQBCRJRT']
['CKHS3KUL65OWKCJMI46EUU3BFAXL']
['CR2DAFL7DUEOJ57JSMJXGTNLSD6G']
['C3SBETLLPCIQKP6GP2T36UYKTZRW']
['CSJT6YELOY47QMSIQ2ANCEPW4MHP']
['CACIAYQYCR643G53S2G7ETAJRMXW']
['C2S3KMJ26R4SO5HIQNUQBM7VFZO2']
['C2LIEGPQJPLH7XTQ7TPJVL63ZW7J']
['CZRGDYMRWIVI7NPCQMG2U67C3HPE']
['CLQWT55N7HBJPO26UYAAB4Z223DC']
['CBV5HU4WKRXHRHK4FBLGMWGRWQBA']
['CM3O3GHMNGRGAXSJQD6FUHPEWMLX']
['CDZTBA6JHQZ7Q5ACO6WEDX7RG2TV']
['C6XGRVN2FAWMGUCNW6AITUJMWN4J']
['CXH462AIRBNTIEPSOU6C3I6ZZYEQ']
['CPQCVDUFXW4LNOLCYEYJCCJDMH32']
['CEDHIJQ6EG62CENIKEGNBHS5MASL']
['CF4A3PNL4AVFZ7AQ5H2TUQL3M3QF']
['CUFN4LYUVJGCU2K52RVIQR54AIWD']
['CX4GXPHXIVKL6SQOCLO4EF4FB6ZO']
['CZYYQH2EO6HKWW6SN4KBEUZVWVT7']
['CMN6GDD4JRP562DICCHB2NEDC3CR']
['CZOZO2IJH3UVVYUHAL7QCPA6TIYP']
['CSKPOZXFBQZGQJD33FR7Y2ECJCCC']
['CGSFYZJF4IN6V4JFD7WXQFJU4BRN']

Only two of which have 'noah' in one of the fields
['CSKPOZXFBQZGQJD33FR7Y2ECJCCC'], ['CGSFYZJF4IN6V4JFD7WXQFJU4BRN']

I don't know what you mean by 'mapping'

Try uppercase the “OR” otherwise you’re searching for the word “or” in text.

Thank you but no change in the returned output with capitalized 'or'

I think we’ll need to see the full JSON for the search to diagnose further.

I'm not using JSON for the search. I simply couldn't get that to function. I'm using lucene.

If you are using elastic something is sending JSON under the covers. To recreate problems we typically need to see the JSON for

  1. the index mapping
  2. example docs you re trying to match/aggregate
  3. the search request

However if you are using Lucene directly and not via elasticsearch it’s probably best to ask the question in the Lucene help forums.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.