[jira] [Commented] (KUDU-1716) CAST a STRING column to INT returns NULL

["Todd Lipcon (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KUDU-1716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15593054#comment-15593054 ] 

Todd Lipcon commented on KUDU-1716:
-----------------------------------

This sounds like an Impala bug report, not a Kudu one, right? The CAST happens in the Impala execution layer. Anyway, I can't reproduce:

{code}
[vd0340:21000] > update customer set c_comment='123' where c_custkey=441273106;
Query: update customer set c_comment='123' where c_custkey=441273106

Fetched 0 row(s) in 0.31s
[vd0340:21000] > select c_comment, cast(c_comment as int) from customer where c_custkey=441273106;
Query: select c_comment, cast(c_comment as int) from customer where c_custkey=441273106
+-----------+------------------------+
| c_comment | cast(c_comment as int) |
+-----------+------------------------+
| 123       | 123                    |
+-----------+------------------------+
Fetched 1 row(s) in 0.18s
{code}

> CAST a STRING column to INT returns NULL
> ----------------------------------------
>
>                 Key: KUDU-1716
>                 URL: https://issues.apache.org/jira/browse/KUDU-1716
>             Project: Kudu
>          Issue Type: Bug
>          Components: supportability
>    Affects Versions: 1.0.1
>         Environment: Linux
>            Reporter: Pavan Kulkarni
>              Labels: kudu
>
> create a kudu table
> create table test (id INT, name STRING)
> select id, CAST(name as INT) from test;
> returns id,NULL



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)