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

Demeter Sztanko commented on HIVE-9047:
---------------------------------------

This is how to recreate the error:

{code}
create table HIVE_9047 (ts double);
set hive.limit.query.max.table.partition=1;
select cast(ts as int) from HIVE_9047;
{code}

I am running Hive 1.2.1
Subversion git://localhost.localdomain/home/sush/dev/hive.git -r 
243e7c1ac39cb7ac8b65c5bc6988f5cc3162f558
Compiled by sush on Fri Jun 19 02:03:48 PDT 2015
>From source with checksum ab480aca41b24a9c3751b8c023338231

> NULL POINTER EXCEPTION
> ----------------------
>
>                 Key: HIVE-9047
>                 URL: https://issues.apache.org/jira/browse/HIVE-9047
>             Project: Hive
>          Issue Type: Bug
>          Components: CLI
>    Affects Versions: 0.13.0, 0.14.0
>            Reporter: ErwanMAS
>
> NPE during parsing .
> {noformat}
> insert into table foobar
>                select cast ( t.begindate as date ) as begindt , cast ( 
> t.enddate as date ) as enddt ,
>                    datediff ( cast ( t.enddate as date ) , cast ( t.begindate 
> as date ) ) as diffday
>                    t.iduser from foobaractions t ;
> {noformat}



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

Reply via email to