[IMPALA-1921] Cast string->*int with a decimal place always returns NULL

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Not A Bug
• Affects Version/s: Impala 2.0
• Component/s: Backend
• Labels: sql-language
• Environment: Server version: impalad version 2.0.0-cdh5 RELEASE (build ecf30af0b4d6e56ea80297df2189367ada6b7da7)
• Epic Link: Numeric Datatype Conversions
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: gpolaert
• Created: 26/Mar/15 15:25
• Updated: 23/Dec/20 23:42
• Resolved: 23/Dec/20 23:42

Description

cast ('-1.0' as int|bigint) should not return NULL but -1.

Issue:

Query: select cast("-1.0" as int)
+---------------------+
| cast('-1.0' as int) |
+---------------------+
| NULL                |
+---------------------+

Workaround:

Query: select cast(cast ("-1.0" as double) as int)
+-------------------------------------+
| cast(cast('-1.0' as double) as int) |
+-------------------------------------+
| -1                                  |
+-------------------------------------+
Fetched 1 row(s) in 0.01s