[jira] [Created] (DRILL-5333) Documentation error in TIME data type description

["Paul Rogers (JIRA)" <ji...@apache.org>]

Paul Rogers created DRILL-5333:
----------------------------------

             Summary: Documentation error in TIME data type description
                 Key: DRILL-5333
                 URL: https://issues.apache.org/jira/browse/DRILL-5333
             Project: Apache Drill
          Issue Type: Bug
          Components: Documentation
    Affects Versions: 1.9.0
            Reporter: Paul Rogers
            Priority: Minor


Consider the following description of the TIME data type from the [documentation|http://drill.apache.org/docs/supported-data-types/]:

{quote}
TIME

24-hour based time before or after January 1, 2001 in hours, minutes, seconds format: HH:mm:ss

22:55:55.23
{quote}

First, TIME has no associated date, so there can be no limitation on the days that can be represented. (If I tell you the bank closes at 5 PM, that statement is not just true after Jan. 1, 2001 -- it is true for as long as the bank exists.)

Second, the example implies that Drill stores milliseconds, which is consistent with the implementation of the {{TimeVector}} data type. But, the format suggests that granularity is seconds.

Finally, Time, as stored internally, has no format: it is a number; the number of milliseconds since the epoch. The format only comes into play when converting two or from text.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)