Peter Rozsa created IMPALA-12236:
------------------------------------
Summary: Inaccurate error reporting in incompatible set operations
Key: IMPALA-12236
URL: https://issues.apache.org/jira/browse/IMPALA-12236
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 4.3.0
Reporter: Peter Rozsa
In set operations like multiple VALUES clauses, the incompatible column error
reports wrong type. The problem arises when the common type is deduced for the
set operation and later on this common type is applied (CAST) to every
respective column in the set elements.
Example:
{code:java}
insert into t06(string_col) values(100), (1000.0)
-
ERROR: AnalysisException: Target table 'default.t06' is incompatible with
source expressions.
Expression '100' (type: DECIMAL(5,1)) is not compatible with column
'string_col' (type: STRING){code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
