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

Thanks Gopal .. That should help Thanks Karthik > On Nov 10, 2014, at 0:49, Gopal V wrote: > >> 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

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

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

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

Hi, 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; These queries throw Error when Employee_details table has zero rows They work great if the tabl

Re: Oozie job not running

Can try.. Nc -vz 192.168.31.130 11000 On Nov 5, 2014 2:41 AM, "Rahul Channe" wrote: > Hi All, > > I am trying to run my oozie job but its giving below error > > user@ubuntu:~/hive_oozie$ oozie job -oozie http://ubuntu:11000/oozie > -config job.properties -run > Error: E0501 : E0501: Could not p