You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Gayathri (JIRA)" <ji...@apache.org> on 2019/05/10 09:33:00 UTC

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

Gayathri created DRILL-7248:
-------------------------------

             Summary: Apache Drill API returns the 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


*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)