[IMPALA-3177] If data overflows FLOAT/DOUBLE data type, impala should issue a warning

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Not A Bug
• Affects Version/s: Impala 2.3.0
• Component/s: Backend
• Labels: ramp-up
• Epic Link: Numeric Datatype Conversions
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Eric Lin
• Created: 11/Mar/16 01:10
• Updated: 20/Mar/17 22:17
• Resolved: 07/Sep/16 00:29

Description

See test case below:

create table test (a float);

put the following data manually into HDFS location for the table:

3.302823479723636e+38
3.302823479723636e+58
test

now select data out from Impala return the following:

Query: select * from test
+-----------------------+
| a                     |
+-----------------------+
| 3.302823479723636e+38 |
| Infinity              |
| NULL                  |
+-----------------------+
WARNINGS: Error converting column: 0 TO FLOAT (Data is: test)
file: hdfs://host-10-17-80-87.coe.cloudera.com:8020/user/hive/warehouse/case_88616.db/test/float.txt
record: test

Fetched 3 row(s) in 1.48s

Ideally both records 2 and 3 should both return NULL for consistency with similar error message.