I am trying to understand, how to define MetricSpec and DimensionSpec. If I define the numeric fields like “age”, “populationCount”, “salary” in dimensionSpec only, these fields are by default getting ingested as strings.
I understand, at ingestion time metrics - aggregations of type count,longSum,doubleSum,doubleMin, etc are supported.
If I intend to perform aggregations like avg, sum, min, max on above mentioned fields (or many other complex aggregations, which cannot be predicted at ingestion time). How shall I define them to be ingested as numeric types?
I intend to use PlyQL, to query my dataset. Is there any was to define the query time metric type in PlyQl. Can I define, following at ingestion time ?
Ref : source
Please provide your inputs, my question might be in wrong direction, as i am trying to learn druid.