Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Sat, 25 Mar 2017 20:33:41 +0000 (UTC)
From: "Pengcheng Xiong (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13024068.1480424178000.122878.1490474021776@Atlassian.JIRA>
In-Reply-To: <JIRA.13024068.1480424178000@Atlassian.JIRA>
References: <JIRA.13024068.1480424178000@Atlassian.JIRA> <JIRA.13024068.1480424178716@jira-lw-us.apache.org>
Subject: [jira] [Commented] (HIVE-15304) Implicit down cast should throw
 error
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Sat, 25 Mar 2017 20:33:49 -0000


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

Pengcheng Xiong commented on HIVE-15304:
----------------------------------------

Hello, I am deferring this to Hive 3.0 as we are going to cut the first RC and it is not marked as blocker. Please feel free to commit to the branch if this can be resolved before the release.

> Implicit down cast should throw error
> -------------------------------------
>
>                 Key: HIVE-15304
>                 URL: https://issues.apache.org/jira/browse/HIVE-15304
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.13.0, 0.14.0, 0.13.1, 1.0.0, 1.2.0, 1.1.0, 1.0.1, 1.1.1, 1.2.1, 2.0.0, 2.1.0, 2.0.1, 2.1.1
>            Reporter: Christian Zorneck
>
> Implicit down casts from a bigger numeric  type to a smaller type should throw an error, when a numeric overflow happens.
> Example:
> CREATE TABLE downcast_test (int_value INT);
> -- implicit cast to BIGINT and than implicit cast to INT
> INSERT INTO TABLE downcast_test SELECT 2147483647 + 1;
> -- implicit cast from BIGINT to INT
> INSERT INTO TABLE downcast_test SELECT 2147483648L;
> -- implicit cast from DOUBLE to INT
> INSERT INTO TABLE downcast_test SELECT 2.147483648E9;
> SELECT * FROM downcast_test;
> =>
> -2147483648  -- expected int overflow value
> -2147483648  -- expected int overflow value
> 2147483647  -- what happend here? cast from DOUBLE to INT results in INT max value
> Here you can see another nice bug with cast from DOUBLE to INT, but this is not the issue here.
> Reading the following documentation
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-AllowedImplicitConversions
> implicit down casts from BIGINT and DOUBLE to INT are not allowed. So an exception is expected. But no exception will be thrown, it quite casts the values somehow down to INT


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)