[IMPALA-966] Type errors are attributed to wrong expression with insert

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 1.3
• Fix Version/s: Impala 3.3.0
• Component/s: Frontend
• Target Version: Product Backlog
• Assignee: Alice Fan
• Reporter: Henry Robinson
• Created: 28/Apr/14 23:06
• Updated: 16/May/19 00:47
• Resolved: 15/May/19 05:44

Description

The type error below belongs to the second row to be inserted (sqrt() returns DOUBLE). But the obviously FLOAT first expression gets blamed for the error.

[localhost:21000] > insert overwrite alltypesnopart_insert(float_col) values(CAST(1.0 AS FLOAT)), (sqrt(-1));
Query: insert overwrite alltypesnopart_insert(float_col) values(CAST(1.0 AS FLOAT)), (sqrt(-1))
ERROR: AnalysisException: Possible loss of precision for target table 'functional.alltypesnopart_insert'.
Expression 'cast(1.0 as float)' (type: DOUBLE) would need to be cast to FLOAT for column 'float_col'