hi folks, I want to consume the pinot table data u...
# troubleshooting
s
hi folks, I want to consume the pinot table data using API, is it using "httpsIPPORT/query/sql"? but we want to custom the metadata for instance:
Copy code
{
    "groupname": "Stars",
    "groupId": 1234,
}
while this one in the documentation return a query overall stats https://docs.pinot.apache.org/users/api/querying-pinot-using-standard-sql/response-format#broker-query-response-fields
x
what kind of groupname you have ?
this query stats is from system and not customizable
s
so what I want is the result data in json format, like:
Copy code
{
    "id: 1234,
    "name": "starysn",
    "age": 30,
    "study": "Law",
    "projectStatus": "case closed"
}
x
ok, that would be very inefficient when the results is large, all the keys are duplicated. For this you need to write your own code to read the schema and iterator the response rows and build the json
s
i see, thanks for the insight