Elastic Query Type Casting Error

[akrauss]

I have this index which all the mappings are long type.

I have a query with a structure works with all my other indices:

GET dqs_profgen_*/_search
{
  "query": {
    "bool": {
      "filter": {
        "range": {
          "time_bkt": {
            "from": "now-100d",
            "to": "now"
          }
        }
      }
    }
  },
  "aggs": {
    "network": {
      "composite": {
        "sources": [
          {
            "date": {
              "date_histogram": {
                "field": "time_bkt",
                "interval": "1d"
              }
            }
          },
          {
            "attr1": {
              "terms": {
                "field": "company_id"
              }
            }
          },
          {
            "attr2": {
              "terms": {
                "field": "mkfile_id"
              }
            }
          }
        ],
        "size": 10000
      },
      "aggs": {
        "metric": {
          "sum": {
            "field": "unchanged_profiles"
          }
        }
      }
    }
  }
}

Despite that all the fields are mapped to type long, I get this error

How can I address this error? Do I need to modify my query to map a type?

[spinscale (Alexander Reelsen)]

please stop sharing screenshots but share real code/JSON snippets. Screenshots are super hard to read.

Can you also share the full mapping?

Last but not least please enable the full stack trace by adding error_trace=true to your request and then put that response here as well (or alternatively in a gist/pastebin and link it).

Thanks!

[akrauss]

Hey Alexander,

I solved this problem on my own yesterday and forgot to remove the post- thank you