Records are not retrieving when fetch query is applied but results of aggregate query shows that record exist

Description

Class Book { book_name, author, Book_hash_value }
Note: book name is not unique, Author name is unique.

When we are storing records in the weaviate. We first fetch the existing record by applying filter on Book_hash_value.
Even though record is existing, fetch doesn’t return any data. However results of aggregate shows that data exist in the DB.

Server Setup Information

  • Weaviate Server Version: 1.24.7 / 1.24.11
  • Deployment Method: k8s
  • Multi Node? Number of Running Nodes: Single
  • Client Language and Version: 4.5.57

hi @2020ashish !

My bet is that your Book_hash_value is indexed with the default tokenization (word) and when you do a search, using a book hash value, it will not find it as the word tokenization will treat your indexed hash as a words.

can you provide the schema for the Book_hash_value property and some example of indexed value?

you will probably want to set the tokenization for the Book_hash_value to field, meaning that Weaviate will index this property as it is.

We have a nice academy unit around this topic here:

let me know if this helps :slight_smile:

Thanks!