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)