[jira] [Commented] (HIVE-10898) CAST AS BIGINT produces wrong value

["Thejas M Nair (JIRA)" <ji...@apache.org>]

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

Thejas M Nair commented on HIVE-10898:
--------------------------------------

[~andrew.kurochkin] I am not able to reproduce this with apache hive 0.13 or 1.2.0 .


With hive 1.2.0 -
{code}
hive> SELECT CAST("775983671874188101" as BIGINT);
OK
775983671874188101
Time taken: 0.059 seconds, Fetched: 1 row(s)
{code}

With 0.13.1 -
{code}
hive> SELECT CAST("775983671874188101" as BIGINT);
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Hadoop job information for null: number of mappers: 0; number of reducers: 0
2015-06-03 07:53:40,131 null map = 100%,  reduce = 0%
Ended Job = job_local238023464_0001
Execution completed successfully
MapredLocal task succeeded
OK
775983671874188101
Time taken: 7.324 seconds, Fetched: 1 row(s)
{code}


> CAST <string> AS BIGINT produces wrong value
> --------------------------------------------
>
>                 Key: HIVE-10898
>                 URL: https://issues.apache.org/jira/browse/HIVE-10898
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.13.1
>         Environment: Hive running on Spark in Standalone mode
>            Reporter: Andrey Kurochkin
>            Priority: Critical
>
> Example Query:
> SELECT CAST("775983671874188101" as BIGINT)
> Produces: 775983671874188160L
> Note: last 2 digits.



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