I think luoc is exactly right in his diagnosis. So Daniel, does this
query run fine on Drill 1.19 with store.mongo.all_text_mode = true?
Thanks
James
On 2022/02/01 05:39, luoc wrote:
Hi Daniel,
I should guess the reason for this case, but I need to verify it first.
Basically, under the full text, the ObjectId exists as a key-value pair (Map
structure), not as a character or number value.
On Jan 31, 2022, at 23:45, Daniel Clark<[email protected]> wrote:
Here it is. Please see the attached file.
On Mon, Jan 31, 2022 at 4:22 AM James Turton<[email protected]> wrote:
Please also attach the query profile if you can.
Thanks
James
