[jira] [Created] (IMPALA-10173) Allow implicit casts from numerics to STRING when inserting into table

["Tim Armstrong (Jira)" <ji...@apache.org>]

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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org