[IMPALA-7368] Add initial support for DATE type

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 3.3.0
• Epic Color: ghx-label-7
• Assignee: Attila Jeges
• Reporter: Attila Jeges
• Created: 31/Jul/18 09:03
• Updated: 15/Sep/23 18:38
• Resolved: 30/Apr/19 15:19

Description

DATE values describe a particular year/month/day, in the form YYYY-­MM-­DD. For example, DATE '2013-­01-­01'. Date types do not have a time of day component. The range of values supported for the Date type is 0000-­01-­01 to 9999-­12-­31.

The initial DATE type support should incluide the following changes:

• new internal type
• casting between DATE and other types
• codegen infrastructure for expression evaluation
• "IS [NOT] NULL" and "[NOT] IN" predicates
• common comparison operators
• BETWEEN operator
• conditional functions
• infrastructure changes for builtin scalar functions.
• some built-in functions: aggregate functions, analytical functions, math functions.
• support partitioning.
• text support only.

These items are tightly coupled and it makes sense to implement them in one change-set.

Issue Links

• causes: IMPALA-10086 SqlCastException when comparing char with varchar
• is related to: IMPALA-7374 Impala Doc: Doc DATE type