Wenzhe Zhou created IMPALA-10564:
------------------------------------

             Summary: No error returned when inserting an overflowed value into 
a decimal column
                 Key: IMPALA-10564
                 URL: https://issues.apache.org/jira/browse/IMPALA-10564
             Project: IMPALA
          Issue Type: Bug
          Components: Backend, Frontend
    Affects Versions: Impala 4.0
            Reporter: Wenzhe Zhou


When using CTAS statements or INSERT-SELECT statements to insert rows to table 
with decimal columns, Impala insert NULL for overflowed decimal values, instead 
of returning error. This issue happens when the data expression for the decimal 
column in SELECT sub-query consists at least one alias. This issue is similar 
as IMPALA-6340, but IMPALA-6340 only fixed the issue for the cases with the 
data expression for the decimal columns as constants so that the overflowed 
decimal values could be detected by frontend during expression analysis.  If 
there is alias (variables) in the data expression for the decimal column, 
Frontend could not evaluate data expression in expression analysis phase. Only 
backend could evaluate the data expression when backend execute fragment 
instances for SELECT sub-queries. The log messages showed that the executor 
detected the decimal overflow error, but somehow it did not propagate the error 
to the coordinator, hence the error was not returned to the client.  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org

Reply via email to