[jira] [Updated] (DRILL-356) Implement support for Date type

["Mehant Baid (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mehant Baid updated DRILL-356:
------------------------------

    Description: 
Add logic to support the following types in Drill: 

Date - Stores date alone (timezoneless)
DateTime - Stores date and time (timezoneless)
Time - Stores time only (timezoneless)
TimeStamp - Stores date and time, contains timezone information
Interval - Used to store an interval of time, following are the parameters which can combine to form an interval type (year, months, days, hours, minutes, seconds, milliseconds)

Except the Interval type all the other data types internally use a java long field to store milliseconds. It represents time since epoch in UTC. Since TimeStamp has a timezone associated with it, it additionally uses an int field to store the timezone index. We maintain a static list of all existing timezones and the int field within TimeStamp represents an index into this list. 

Interval type is used to represent a period of time use one or more of the following fields: Year, month, day, hour, minute, second, millisecond. Internally we convert and store only three fields: months, days, milliseconds. There is a one to one mapping available between all possible fields and out internal fields. Eg: Year to month is (1 Year = 12 months) and so on. 

We use Joda libraries underneath when we want to perform date arithmetic, time zone conversion etc. Although for comparison functions we don't use Joda because our internal representation (of milliseconds) is sufficient enough for all comparisons.

  was:
Add logic to support the following types in Drill: 

Date
DateTime
TimeStamp
Interval


> Implement support for Date type
> -------------------------------
>
>                 Key: DRILL-356
>                 URL: https://issues.apache.org/jira/browse/DRILL-356
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Mehant Baid
>            Assignee: Mehant Baid
>
> Add logic to support the following types in Drill: 
> Date - Stores date alone (timezoneless)
> DateTime - Stores date and time (timezoneless)
> Time - Stores time only (timezoneless)
> TimeStamp - Stores date and time, contains timezone information
> Interval - Used to store an interval of time, following are the parameters which can combine to form an interval type (year, months, days, hours, minutes, seconds, milliseconds)
> Except the Interval type all the other data types internally use a java long field to store milliseconds. It represents time since epoch in UTC. Since TimeStamp has a timezone associated with it, it additionally uses an int field to store the timezone index. We maintain a static list of all existing timezones and the int field within TimeStamp represents an index into this list. 
> Interval type is used to represent a period of time use one or more of the following fields: Year, month, day, hour, minute, second, millisecond. Internally we convert and store only three fields: months, days, milliseconds. There is a one to one mapping available between all possible fields and out internal fields. Eg: Year to month is (1 Year = 12 months) and so on. 
> We use Joda libraries underneath when we want to perform date arithmetic, time zone conversion etc. Although for comparison functions we don't use Joda because our internal representation (of milliseconds) is sufficient enough for all comparisons.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)