[ https://issues.apache.org/jira/browse/HIVE-14694?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15462563#comment-15462563 ]
Niklaus Xiao commented on HIVE-14694: ------------------------------------- Unrelated test failures. > 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 > > Attachments: HIVE-14694.1.patch > > > 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)