[jira] [Resolved] (IMPALA-3217) Allow text quoted by single quotes be treated as a literal value of char/varchar

["Peter Rozsa (Jira)" <ji...@apache.org>]

     [ 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)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org