Re: row_number() over(Partition by) Throw Error with Null Input.

[Gopal V]

On 11/9/14, 10:16 PM, karthik Srivasthava wrote:

select row_number() over (PARTITION BY
country,state,department,branch_name) from Employee_details;
select count(*) over (PARTITION BY country,state,department,branch_name)
from Employee_details;

You haven't posted the entire back trace, so I'm guessing this is the 
PTF bug that was fixed in hive-14 last month

https://issues.apache.org/jira/browse/HIVE-8361

Cheers,
Gopal

#################### ERROR

Container released by application,
AttemptID:attempt_1415054619959_1346_1_00_000
000_3 Info:Error: java.lang.RuntimeException: java.lang.RuntimeException:
Hive R
untime Error while closing operators: null
Caused by: java.lang.RuntimeException: Hive Runtime Error while closing
operator
s: null
         at
org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.close(Reduce
RecordProcessor.java:390)
         at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java
:179)
         ... 6 more
Caused by: java.lang.NullPointerException

#################### ERROR