[DRILL-5072] REST API Returns String for Integers and all other fields

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.8.0
• Component/s: Client - HTTP
• Assignee: Unassigned
• Reporter: mustafa akin
• Created: 27/Nov/16 09:00
• Updated: 27/Nov/16 09:02

Description

The Drill REST API currently returns all the fields as string values even they are integers or floats. For instance, even explicit casting does not help as it can be seen from the example:

 $ curl -X POST -H "Content-Type: application/json" -d '{"queryType":"SQL", "query": "select CAST (COUNT(*) AS INT) from dfs.`/myfile`"}' http://localhost:8047/query.json 

{
  "columns" : [ "EXPR$0" ],
  "rows" : [ {
    "EXPR$0" : "1"
  } ]
}

I would like to contribute myself if possible.