[
https://issues.apache.org/jira/browse/IMPALA-3217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Peter Rozsa resolved IMPALA-3217.
---------------------------------
Resolution: Done
> Allow text quoted by single quotes be treated as a literal value of
> char/varchar
> --------------------------------------------------------------------------------
>
> Key: IMPALA-3217
> URL: https://issues.apache.org/jira/browse/IMPALA-3217
> Project: IMPALA
> Issue Type: New Feature
> Components: Frontend
> Affects Versions: Impala 2.4.0
> Reporter: Yibing Shi
> Priority: Minor
>
> Currently, in Impala, a string quoted with single quotes (such as 'abcd') is
> treated as a literal value of String type. To use it with char/varchar type,
> an explicit conversion is needed.
> For example, blow query doesn't work:
> {code:sql}
> insert into table tbl (char_col) values ('abcd')
> {code}
> Only below query works:
> {code:sql}
> insert into table tbl (char_col) values ( cast ('abcd' as char(20)))
> {code}
> It does make sense to allow the first query.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
