[
https://issues.apache.org/jira/browse/DRILL-7248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Turton closed DRILL-7248.
-------------------------------
Fix Version/s: 1.19.0
Resolution: Fixed
> 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: Major
> Fix For: 1.19.0
>
>
> *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
(v8.20.1#820001)
