my_store_inventory_float

{
  "mappings": {
    "properties": {
      "item_id": { "type": "keyword" },
      "product_name": { "type": "text" },
      "brand_id": { "type": "float" },  // brand_id is float in this index
      "price": { "type": "float" },
      "timestamp": { "type": "date" }
    }
  }
}

my_store_inventory_long

{
  "mappings": {
    "properties": {
      "item_id": { "type": "keyword" },
      "product_name": { "type": "text" },
      "brand_id": { "type": "long" },  // brand_id is long in this index
      "price": { "type": "float" },
      "timestamp": { "type": "date" }
    }
  }
}

{ "index": { "_id": "1", "_index":"my_store_inventory_float" } }
{ "item_id": "item_A1", "product_name": "Super Widget X", "brand_id": 101, "price": 10.99, "timestamp": "2025-05-01T10:00:00Z" }
{ "index": { "_id": "1", "_index":"my_store_inventory_long" } }
{ "item_id": "item_A2", "product_name": "Basic Widget", "brand_id": 101, "price": 8.99, "timestamp": "2025-05-02T11:00:00Z" }

{
 "query": {
    "match_all": {} 
  },
  "aggs": {
    "top_sales_hits": {
        "top_hits": {
        "sort": [
                { "brand_id": "asc" }, 
                { "price": "desc" }
        ],
        "size": 1
        }
    }
  }
}

{
    "error": {
        "root_cause": [],
        "type": "search_phase_execution_exception",
        "reason": "",
        "phase": "fetch",
        "grouped": true,
        "failed_shards": [],
        "caused_by": {
            "type": "class_cast_exception",
            "reason": "class java.lang.Float cannot be cast to class java.lang.Long (java.lang.Float and java.lang.Long are in module java.base of loader 'bootstrap')"
        }
    },
    "status": 500
}

        "caused_by": {
            "type": "illegal_argument_exception",
            "reason": "Can't sort on field [brand_id]; the field has incompatible sort types: [FLOAT] and [LONG] across shards!"
        }
    },
    "status": 400