[jira] [Commented] (DRILL-7248) Apache Drill API returns the numeric column value as string

["Arina Ielchiieva (JIRA)" <ji...@apache.org>]

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

Arina Ielchiieva commented on DRILL-7248:
-----------------------------------------

[~Gayathri01] not sure if there is a workaround.
There is similar Jira - https://issues.apache.org/jira/browse/DRILL-4821

> Apache Drill API returns the numeric column value as string
> -----------------------------------------------------------
>
>                 Key: DRILL-7248
>                 URL: https://issues.apache.org/jira/browse/DRILL-7248
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.14.0
>            Reporter: Gayathri
>            Priority: Blocker
>
> *test.json:*
> [\{"a":"uxv","b":1,"c":2.0},\{"a":"uxv","b":2,"c":3.15}]
> +Example:+ *Request:* \{"queryType" : "SQL","query" : "select * from dfs.`\files\test.json`"};
> *Response:* { "queryId": "233ff474-0902-828b-9efd-0a0bd57eee51",
>  "columns": [
>  "a",
>  "b",
>  "c"
>  ],
>  "rows": [
> { "b": "1", "c": " 2.0", "a": "uxv"}
> , \{ "b": "2", "c": "3.15", "a": "uxv"}
> ]
>  }
> Here in the response, why the column values are coming as string even though it a numeric.
> Can anyone please help me in this. Is there any configuration where I can modify to get the response column values in proper numeric format rather than a string.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)