You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "James Turton (Jira)" <ji...@apache.org> on 2022/01/18 11:30:00 UTC
[jira] [Closed] (DRILL-7218) Apache Drill API doesn't preserve the column order
[ https://issues.apache.org/jira/browse/DRILL-7218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Turton closed DRILL-7218.
-------------------------------
Resolution: Not A Bug
> Apache Drill API doesn't preserve the column order
> --------------------------------------------------
>
> Key: DRILL-7218
> URL: https://issues.apache.org/jira/browse/DRILL-7218
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.14.0
> Reporter: Gayathri
> Assignee: James Turton
> Priority: Minor
> Labels: REST_API, drill
>
> 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"}, \{ "b": "abc", "c": " xyz", "a": "uxv"}
> ]
> }
> Is there any way we can maintain the column order through REST API call?
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)