Schema is used to define the names, data types, and other information for the columns of a Pinot table.
The Pinot schema is composed of:
Below is a detailed description of each type of field spec.
A dimensionFieldSpec is defined for each dimension column. Here's a list of the fields in the dimensionFieldSpec:
A metricFieldSpec is defined for each metric column. Here's a list of fields in the metricFieldSpec
A dateTimeFieldSpec is used to define time columns of the table. Here's a list of the fields in a dateTimeFieldSpec
Apart from these, there's some advanced fields. These are common to all field specs.