[jira] [Commented] (DRILL-7218) Apache Drill API doesn't preserve the column order

["Volodymyr Vysotskyi (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-7218?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16826106#comment-16826106 ] 

Volodymyr Vysotskyi commented on DRILL-7218:
--------------------------------------------

[~Gayathri01], the order of the columns is preserved in the {{columns}} list. {{rows}} is just a list of maps, where every map shouldn't preserve the order of columns.

> 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
>            Priority: Blocker
>              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
(v7.6.3#76005)