hello i am facing issue creating pinot table which...
# troubleshooting
s
hello i am facing issue creating pinot table which has column of type struct/array.. the column daro_score in image is being created as string by the infer-schema-json-data utility and i am unable to upload data. Can you please suggest if array type is allowed in pinot. How can i load this column? documentation only speaks that Data type of the dimension column. Can be INT, LONG, FLOAT, DOUBLE, BOOLEAN, TIMESTAMP, STRING, BYTES.
Copy code
|-- daro_scores: array (nullable = true)
 |    |-- element: struct (containsNull = true)
 |    |    |-- _1: string (nullable = true)
 |    |    |-- _2: double (nullable = true)
m
Pinot has multi-valued columns similar to (but not same semantics) as arrays
s
ok so do i just use array data type? is there any documentation on this.. so i can use the example to create my schema