[IMPALA-1424] ABS(int) should return an INT instead of DOUBLE

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.1
• Fix Version/s: Impala 2.1
• Assignee: Martin Grund
• Reporter: casey
• Created: 27/Oct/14 02:36
• Updated: 28/Oct/14 16:07
• Resolved: 28/Oct/14 16:07

Description

It's unlikely that people would want their INT data to turn into a DOUBLE as part of ABS(). Other systems such as Postgresql retain the INT.

Query: create TABLE FOO AS SELECT ABS(CAST(1 AS INT)) col
+-------------------+
| summary           |
+-------------------+
| Inserted 1 row(s) |
+-------------------+
Fetched 1 row(s) in 0.33s


[casey-desktop:21000] > desc foo;
Query: describe foo
+------+--------+---------+
| name | type   | comment |
+------+--------+---------+
| col  | double |         |
+------+--------+---------+
Fetched 1 row(s) in 0.00s

functional=# CREATE TABLE FOO AS SELECT ABS(CAST(1 AS INT)) col;
SELECT 1


functional=# \d foo;
      Table "public.foo"
 Column |  Type   | Modifiers 
--------+---------+-----------
 col    | integer | 

Example usage

Query: select now() + interval abs(int_col) year from alltypestiny
ERROR: AnalysisException: Operand 'abs(int_col)' of timestamp arithmetic expression 'now() + INTERVAL abs(int_col) year' returns type 'DOUBLE'. Expected an integer type.