[IMPALA-4072] Numeric Datatype Conversions and Error Handling

• Type: Epic
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 2.6.0
• Component/s: Backend, Frontend
• Epic Name: Numeric Datatype Conversions
• Epic Color: ghx-label-6
• Assignee: Unassigned
• Reporter: Greg Rahn
• Created: 02/Sep/16 22:34
• Updated: 24/Oct/17 20:14

Description

Unlike most RDBMS systems, Impala does not error on most numeric overflow scenarios. Today it can simply return NULL or exhibit C++ like behavior (casting 500 to a TINYINT returns -12). To provide a UX more like RDBMS systems, failing on numeric overflow should be added when using strict_mode (introduced in IMPALA-3579).