[ https://issues.apache.org/jira/browse/IMPALA-966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alice Fan resolved IMPALA-966. ------------------------------ Resolution: Fixed Fix Version/s: Impala 3.2.0 > Type errors are attributed to wrong expression with insert > ---------------------------------------------------------- > > Key: IMPALA-966 > URL: https://issues.apache.org/jira/browse/IMPALA-966 > Project: IMPALA > Issue Type: Bug > Components: Frontend > Affects Versions: Impala 1.3 > Reporter: Henry Robinson > Assignee: Alice Fan > Priority: Minor > Fix For: Impala 3.2.0 > > > 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. > {code} > [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' > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)