Tim Armstrong created IMPALA-10173:
--------------------------------------
Summary: Allow implicit casts from numerics to STRING when
inserting into table
Key: IMPALA-10173
URL: https://issues.apache.org/jira/browse/IMPALA-10173
Project: IMPALA
Issue Type: Improvement
Components: Frontend
Reporter: Tim Armstrong
Impala is somewhat stricter than other engines such as Hive when it comes into
implicit casts. This avoids a lot of ambiguity and edge cases with complex SQL,
but we could consider loosening it for simple cases like inserting into a table
where the meaning/intent is pretty straightforward.
Repro
{code}
CREATE TABLE iobt ( c0 FLOAT ) ;
INSERT INTO iobt(c0) VALUES ('0'), (1562998803);
{code}
Error
{code}
AnalysisException: Incompatible return types 'STRING' and 'INT' of exprs ''0''
and '1562998803'.
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
