[DRILL-2373] JSON query request returns all types as strings

• Type: Bug
• Status: In Progress
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.7.0, 0.8.0
• Fix Version/s: Future
• Component/s: Client - HTTP
• Assignee: Adam Gilmore
• Reporter: Adam Gilmore
• Created: 04/Mar/15 01:46
• Updated: 24/Jun/16 21:50

Description

I'm not sure if the query JSON endpoint is a valid, documented feature of Drill, but at the moment it returns all results as strings.

So, for example:

select count(*) from cp.`employee.json`

Will return "1155" (as a string) as opposed to 1155 (as a numeric JSON value).

It really should be returning numeric values as proper JSON numeric values. Same should apply for boolean values.

How we handle other data types (i.e. dates, intervals, timestamps, etc.) needs discussion.