Ok, I see the issue. Notice that the type of your value field changed. In the first screenshot, the _value column (which represents the field value) is a float (double). In the second screenshot, the _value column is an integer (long).
While it’s technically possible for the same field to use different types when those types are isolated to different shards, at query time, it causes issues like this. There is a recent thread related to just this as well as a recent GitHub issue.
How did you import this CSV?
