Minor Description
When we try to query through Apache Drill REST API, the returned response doesn't maintain the column order as given in the query.
Example: Request: {"queryType" : "SQL","query" : "select a,b,c from dfs.`\files\test.json`"};
Response: { "queryId": "233ff474-0902-828b-9efd-0a0bd57eee51",
"columns": [
"a",
"b",
"c"
],
"rows": [
, { "b": "abc", "c": " xyz", "a": "uxv"}
]
}
Is there any way we can maintain the column order through REST API call?