[
https://issues.apache.org/jira/browse/IMPALA-10173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on IMPALA-10173 started by Peter Rozsa.
--------------------------------------------
> 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
> Assignee: Peter Rozsa
> Priority: Minor
> Labels: 2023Q1, ramp-up, sql-language, supportability
>
> 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.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
