This message was deleted.

Hi Marco -- if you are using the druid/v2/sql endpoint you can request different format types ... here I used CSV in my tests:

curl --location --request POST '<http://localhost:8888/druid/v2/sql/>' \
     --header 'Content-Type: application/json' \
     --data-raw '{ "query" : "SELECT regionName, COUNT(*) FROM wikipedia where regionName is not null  GROUP BY 1 ORDER BY 2 DESC ", "resultFormat":"csv"}'

JSON format I thought requires each fieldname to accompany each field value so I don't think you can get the "single header line" format that CSV provides automatically.

Thank you very much! This is exactly what I was looking for.