[IMPALA-2860] allow Impala to interpret "0001-01-01" and later as a date

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 2.2.2
• Component/s: Backend
• Epic Link: Timestamp Compatibility
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Boris Gitline
• Created: 16/Jan/16 00:48
• Updated: 05/Oct/19 00:02
• Resolved: 05/Oct/19 00:02

Description

scenario:

create table foo
stored as parquet
as
select cast('0001-01-01 00:00:00' as timestamp) ts;

result:

Year is out of valid range: 1400..10000

importing lots of data from mainframe systems; the default date on these mainframes is "0001-01-01". As it is, when impala interprets these dates into a timestamp field, it is converted to null.

Issue Links

• relates to: IMPALA-6169 Implement DATE type