hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niklaus Xiao (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-14694) UDF rand throws NPE when input data is NULL
Date Fri, 02 Sep 2016 08:41:20 GMT

     [ https://issues.apache.org/jira/browse/HIVE-14694?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Niklaus Xiao updated HIVE-14694:
--------------------------------
    Attachment:     (was: HIVE-14694.1.patch)

> UDF rand throws NPE when input data is NULL
> -------------------------------------------
>
>                 Key: HIVE-14694
>                 URL: https://issues.apache.org/jira/browse/HIVE-14694
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>    Affects Versions: 2.2.0
>            Reporter: Niklaus Xiao
>            Assignee: Niklaus Xiao
>            Priority: Minor
>             Fix For: 2.2.0
>
>
> When use {{rand}} function with null, HiveServer throws NPE:
> {code}
> 0: jdbc:hive2://10.64.35.144:21066/> desc foo1;
> +-----------+------------+----------+--+
> | col_name  | data_type  | comment  |
> +-----------+------------+----------+--+
> | c1        | bigint     |          |
> +-----------+------------+----------+--+
> 1 row selected (0.075 seconds)
> 0: jdbc:hive2://10.64.35.144:21066/> select * from foo1;
> +----------+--+
> | foo1.c1  |
> +----------+--+
> | NULL     |
> | 1        |
> | 2        |
> +----------+--+
> 3 rows selected (0.124 seconds)
> 0: jdbc:hive2://10.64.35.144:21066/> select rand(c1) from foo1;
> Error: java.io.IOException: org.apache.hadoop.hive.ql.metadata.HiveException: Unable
to execute method public org.apache.hadoop.hive.serde2.io.DoubleWritable org.apache.hadoop.hive.ql.udf.UDFRand.evaluate(org.apache.hadoop.io.LongWritable)
 on object org.apache.hadoop.hive.ql.udf.UDFRand@37a2b47b of class org.apache.hadoop.hive.ql.udf.UDFRand
with arguments {null} of size 1 (state=,code=0)
> {code}
> Stack trace:
> {code}
> Caused by: java.lang.reflect.InvocationTargetException
>         at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:498)
>         at org.apache.hadoop.hive.ql.exec.FunctionRegistry.invoke(FunctionRegistry.java:1010)
>         ... 36 more
> Caused by: java.lang.NullPointerException
>         at org.apache.hadoop.hive.ql.udf.UDFRand.evaluate(UDFRand.java:57)
>         ... 40 more
> {code}



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

Mime
View raw message