hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gopal V <gop...@apache.org>
Subject Re: row_number() over(Partition by) Throw Error with Null Input.
Date Mon, 10 Nov 2014 06:49:17 GMT
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
>
>


Mime
View raw message