Aggregate count error compared to GET results

Support
1

Description

I am getting a mismatch between what returns in a Get query and an Aggregate query for the same parameters (using hybrid search + where clause). The Get query returns 20 objects. The Aggregate query is returning a count of 228. I have no idea how to make them the same. Thank you for any help!

{
  results: Aggregate {
    CollectionObjects0304_1102(
      where: {
        operator: Like
        path: ["department"]
        valueString: "textiles department"
      }
      hybrid: {
        query: "concept cars"
        alpha: 0
      }
      objectLimit: 50000
    ) {
      meta {
        count
      }
    }
  }
  get: Get {
    CollectionObjects0304_1102(
      where: {
        operator: Like
        path: ["department"]
        valueString: "textiles department"
      }
      hybrid: {
        query: "concept cars"
        alpha: 0
      }
      limit: 100
      offset: 0
    ) {
      _additional {
        id
      }
    }
  }
}

Server Setup Information

  • Weaviate Server Version: 1.36.5
  • Deployment Method: Shared Cloud
2

Good morning @Sol_Vitkin ,

You’re using our Weaviate Cloud, so you can always open a ticket with us at support@weaviate.io. It’s the fastest way to get help, we can access your cluster and troubleshoot or diagnose issues directly.

If you haven’t already, please do open tickets when you need support, as you’re a cloud customer. We’ll get back to you there and help out.

Have a lovely weekend!

Best,
Mohamed Shahin
Weaviate Admin, Support Engineer
(Ireland, UTC±00:00/+01:00)