drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gayathri (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-7248) Apache Drill API returns the column value as string
Date Fri, 10 May 2019 09:33:00 GMT
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)

Mime
View raw message