drill-issues mailing list archives

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

     [ https://issues.apache.org/jira/browse/DRILL-7248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Gayathri updated DRILL-7248:
----------------------------
    Description: 
*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.

  was:
*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.


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

Mime
View raw message