Hi,
I was experimenting with the mongo storage system and I found that when I query a field that doesn't usually have any value, I get this error "You tried to write a Float8 type when you are using a ValueWriter of type NullableIntWriterImpl." Based on a bit of googling I found that this means drill has inferred the incorrect type for that field. I was hoping I could override the inferred type using CAST or something, but CAST didn't work. Is there a way to tell drill what type a field from mongodb is supposed to be? Example query: SELECT _id, CAST(points AS DOUBLE) FROM mongo.formative.answers AS answer WHERE answer.createdAt > DATE_SUB(current_timestamp, interval '1' day) LIMIT 100 In this case "points" isn't set on every row, so I guess drill assumes it is "NullableInt" when really it is should be considered a double. We also have many boolean fields that are not set by default that we would want to query. What's the standard workaround for this case?
