drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Gilmore (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2373) JSON query request returns all types as strings
Date Wed, 04 Mar 2015 01:47:05 GMT
Adam Gilmore created DRILL-2373:

             Summary: JSON query request returns all types as strings
                 Key: DRILL-2373
                 URL: https://issues.apache.org/jira/browse/DRILL-2373
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - HTTP
    Affects Versions: 0.8.0
            Reporter: Adam Gilmore
            Assignee: Jason Altekruse
            Priority: Minor

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:

{code}select count(*) from cp.`employee.json`{code}

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.

This message was sent by Atlassian JIRA

View raw message