Hi team,
I am working on a project that make use of Apache Drill REST API to run
queries on JSON data. The response which I get from Drill is having rows
with all values as string irrespective of numeric or boolean.
Below is the sample:
*test.json:*
[{"a":"uxv","b":1,"c":2.0},{"a":"uxv","b":2,"c":3.15}]
*Request:* {"queryType" : "SQL","query" : "select * from
dfs.`\files\test.json`"};
*Response:* { "queryId": " ",
"columns": ["a","b","c"],
"rows": [
{ "b": "1", "c": " 2.0", "a": "uxv"}
, { "b": "2", "c": "3.15", "a": "uxv"} ] }
*Expected: *Numeric values without double quotes in response.
One of our requirement is failing because of this. Can anyone please give
some inputs or any configuration needs to be done to make it work as
expected.
Highly appreciating your response in advance.
Thanks,
Gayathri
