[
https://issues.apache.org/jira/browse/IMPALA-1333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16784222#comment-16784222
]
Sandeep Suman commented on IMPALA-1333:
---------------------------------------
Any ETA on this ticket? Our application is failing due to this by-design
behavior.
> Missing implicit casts between char/varchar/string.
> ---------------------------------------------------
>
> Key: IMPALA-1333
> URL: https://issues.apache.org/jira/browse/IMPALA-1333
> Project: IMPALA
> Issue Type: Improvement
> Components: Frontend
> Affects Versions: Impala 2.0, Impala 2.2, Impala 2.3.0
> Reporter: Lenni Kuff
> Priority: Minor
> Labels: sql-language, usability
>
> The following scenario needs to work:
> {code}
> create table vc (v varchar(10));
> insert into vc select 'a';
> ERROR: AnalysisException: Possible loss of precision for target table
> 'default.vc'.
> Expression ''a'' (type: STRING) would need to be cast to VARCHAR(10) for
> column 'v'
> {code}
> *Workaround*
> Use explicit casts.
> {code}
> Query: insert into vc select cast('a' as varchar(10))
> Inserted 1 row(s) in 0.32s
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
