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)
